crash with strange format on xlsx file

[gvollant]

I received and xlsx file with this strange format

mini5.xlsx

#,##0\ "gche";[Red]\-#,##0\ "gche"

xlsx_drone crash when xlsx_open is called (in get_formetted function, called by get_related_category)

I'll subit a PR with a string length verification

[gvollant]

@damian-m-g

[gvollant]

@damian-m-g what do you think?

[damian-m-g]

Hi Gilles, thanks for reporting the problem. I checked the XLSX, not in depth, but at least I found that cell category (aka format code):

I couldn't yet debug the lib to reproduce the error, but I've tried to follow the problem by bare eye. I see no way, in which the length of the cell category could cause a problem. So get_related_category() which in time calls get_formatter(), gets passed the length of the cell category:

And then on get_related_category(), the code never pass an index out of the bounds of the cell category length:

So your first check according to this analysis could be in vain. About your second check, I followed this specific case and it should work fine (without the fix). In conclusion, I need to set up my machine to debug this code, as it got formatted recently. This could even be a problem of the third hand libraries we are using (perhaps SXMLC), or something else. When I have some time available I'll do it.

[Neustradamus]

@damian-m-g: Any progress on it?