By: Gabriel
Date: 2014-10-01
Time: 17:29
|
BUG found if a cell contains the following character "/"If a cell contains the following character "/", the excel file seems broken.
Excel shows the following error. <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error035960_02.xml</logFileName><summary>Errors were detected in file 'C:\Users\XXX~1\AppData\Local\Temp\Export-4.xlsx'</summary><repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords></recoveryLog> Maybe there should be some character escaping function to be applied? Thanks! |
By: Skrol29
Date: 2014-10-01
Time: 21:46
|
Re: BUG found if a cell contains the following character "/"Hi Gabriel,
I cannot reproduce your problem. "/" are correctly accepted in y merging. Can you send to me a small snippet to reproduce the problem ? |
By: Gabriel
Date: 2014-10-01
Time: 22:05
|
Re: BUG found if a cell contains the following character "/"From observations I think this is something that happens when a certain cell has the "/" character.
May I send you the corrupted Excel file and a good one? |
By: Skrol29
Date: 2014-10-02
Time: 00:02
|
Re: BUG found if a cell contains the following character "/"Yes please. But also the way to make such a corrupted file.
Even if I found the error in the XML I will cannot find the origin. |
By: Gabriel
Date: 2014-10-02
Time: 16:32
|
Re: BUG found if a cell contains the following character "/"My bad... I as inserting data from a float type variable into a cell without using the "frm" option.
As for regional settings, that caused the cell value to be as "1234,50", and that confused Excel. Once I added the frm option, everything worked great. Thanks and sorry for bothering |