Strange behaviour with XLSX files generated by Adobe Acrobat X
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
heribertB · 2019-12-12 08:02

Hi,

I've just noticed that XLSX files generated by Adobe Acrobat X contain
color value strings (??) that are already preceded by a #. Now,
TsSpreadOOXMLReader.ReadColor does add another # to the beginning of
this string when calling HTMLColorStrToColor, resulting in strtoint in
HTMLColorStrToColor failing with an EConvertError.

My dowdy workaround was to start HTMLColorStrToColor with a check for
this:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i if pos (
'##' , avalue ) = 1 then delete ( avalue , 1 , 1 ) ;
Attached please find a sample.xlsx that should allow to reproduce that
behaviour.

Regards

Heribert

----------------------------------------------------------------------
wp · 2019-12-12 09:38

Could you please add the attachment? And can Adobe also create an
OpenDocument file (.ods)? Send such a file, too. Maybe there is the
same issue...

Pack both files into a common zip which is accepted by the forum
software.

----------------------------------------------------------------------
wp · 2019-12-12 10:20

Please test r7207. It reads a file correctly which I manipulated to
have a # at the beginning of a color string. Interestingly Excel
itself does not show this color correctly.