Excel found unreable Text in the Document

FLX TMS FlexCel for VCL & FMX
1

Hello!


We are using the FlexCel XLSX Export in our program, but when i export the file and open it in excel, excel always wants to repair the file.

I've uploaded it to my dropbox folder for Testing:

https://www.dropbox.com/s/vpliygog08pzwt3/20130108151129185%20-%20Copy.xlsx

Do you have any idea whats wrong with the file?

Thanks,

Lars
2

Hi,

The problem is in the formulas, they are using ";" instead of "," to separate parameters. For example, inside this file you have:
SUM((SUM(D42:D43;D46;D49:D55;D68;D70:D71)))
And it should be:
SUM((SUM(D42:D43,D46,D49,D55,D68,D70:D71)))

I am not sure on how this happened.  While localized Excel versions (like mine which is in spanish) do use ";" instead of ",", internally the xlsx always must write ",".


And I tried to enter a formula like this: (again, in a spanish machine where "," is the decimal separator):
 xls.SetCellValue(1, 1, tformula.create('=sum(a1;a2)'));

And it returns an error. What exact string are you using to enter the formulas?
That is, what line of code did you use to enter for example
=SUM((SUM(D42:D43;D46;D49:D55;D68;D70:D71)))
in your file?

Also, just to make sure: Haven't  you localized the file
_FormulaMsg.Resources.pas
so  SFm_fmFunctionSep is a ";" not a ',' ?  I just realized that somewhere in the docs it says you could localize this, but reality is, you can't (or xlsx files will be written wrong).
3

Hello!


Thanks for the answer, yes, i found the problem, too after some more debugging. I did localize the the constants and then the xlsx file was not usable.

But now it works great!

Thanks,

Lars