Categories > OpenTBS with XLSX >

BUG found if a cell contains the following character "/"

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
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