Hi there!
I'm trying to parse hundreds of old xls-Files to just extract numbers and text and do some stuff with the result.
Therefore I'm reading allways without boReadFormulas.
In most cases this works fine, original formulas beeing read as cells with type cctNumber. Value can then be accessed throug cell^.Numbervalue.
For some formula cells with have exactly the same formatting and similar contents as the rest of the formulas (no fancy stuff like conditional formats or anything) this fails without reason.
The result is still a cell with type cctFormula (boReadFormulas being turned off!). The formula can be accessed through ReadFormulaAsString(Cell) (resulting e.g. in "SUM(B7:M7)"). A call to ReadNumericValue(Cell,DValue) gives false (=no result). I somehow need to get the number value. Furthermore I suspect this might be a bug.
I would be happy to provide a sample file, but I can't size them down to the problem area, as altering the files in Excel 2019 solves the problem, even when saving back to xls. So the only way would be to provide a rather unhandy original file. Resaving all old files is no solution by the way, as we're looking at aprox. 500 files.
Maybe a solution would be to automatically convert all files to xlsx via FPSpreadsheet, but this is not a one time only action and I rather would implement a solution that is not just a work around, that maybe for future versions of FPSpreadsheet would be complete nonsense.
Thanks for any viable solution.
Kind regards
R. Köhler