Categories > OpenTBS with XLSX >

xlsx demo and others display incorrectly in libreoffice

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Nico
Date: 2013-05-21
Time: 17:39

xlsx demo and others display incorrectly in libreoffice

Generating xlsx in demo page and opening it with libreoffice doesn't show correctly. Any reason ? In Excel looks great!
By: Skrol29
Date: 2013-05-21
Time: 23:11

Re: xlsx demo and others display incorrectly in libreoffice

Indeed, you're right !
I don't know why. The merged XLSX respects the OpenXML standard. I don't know why LibreOffice doesn't show it correctly.
By: Daniel Degasperi
Date: 2013-05-22
Time: 15:07

Re: xlsx demo and others display incorrectly in libreoffice

Confirm. The xlsx in MS Office looks great, in LibreOffice it seems empty.

I've tried:
1. open the xlsx in MS Office
2. save it with MS Office without changes
3. open the saved xlsx with LibreOffice and it looks great

I've also checked the differences between this 2 versions and discovered:
* MS Office: relies to sharedStrings.xml
* TBS: put the strings inline into the sheet.xml

I hope this information could help.

Best regards,
Daniel
By: Daniel Degasperi
Date: 2013-05-23
Time: 11:02

Re: xlsx demo and others display incorrectly in libreoffice

We tried to import a opentbs generated file with gnumeric 1.12 and got following console output:

Unexpected element 'extLst' in state :
    styleSheet

** (gnumeric:1536): CRITICAL **: cell_tile_apply_pos: assertion `col >= 0' failed

** (gnumeric:1536): CRITICAL **: sheet_cell_create: assertion `col >= 0' failed
Foglio1 : Invalid cell [C-1]0

The import did not succeed.
By: Skrol29
Date: 2013-05-23
Time: 23:39

Re: xlsx demo and others display incorrectly in libreoffice

>* MS Office: relies to sharedStrings.xml
>* TBS: put the strings inline into the sheet.xml

Yes but this is part of the OpenXLM specification.
May be not well supported by LibreOffice.

>We tried to import a opentbs generated file with gnumeric 1.1

It seems to meet another problem, but the error message does not help so much.

I will research on that problem.
By: Daniel Degasperi
Date: 2013-05-24
Time: 10:28

Re: xlsx demo and others display incorrectly in libreoffice

Thanks for your quick reply

>* Yes but this is part of the OpenXLM specification.

Microsoft's "Open XML SDK 2.0 Productivity Tool for Microsoft Office" is not able to open the demo xlsx.

http://www.microsoft.com/en-us/download/details.aspx?id=5124

Best regards
Daniel
By: Skrol29
Date: 2013-07-09
Time: 03:21

Re: xlsx demo and others display incorrectly in libreoffice

Hi Daniel,

There is a fresh beta version of OpenTBS that save Ms Excel sheets with explicit references.
Now workbooks can be opened with LibreOffice.
Can you check if it also works with some of your tools, such as gnumeric ?

I've tested with "Open XML SDK 2.0 Productivity Tool for Microsoft Office" but I have an error message. Something like :
Cannot open the file: the specified component does not exist in the package.
(my message is in French)
It it's clearly related to the OPENTBS_DELETE_SHEETS operation. Because without this command, the workbook can be opened with SDK Tool and is valid.
I'm still working on it.

Regards,

http://www.tinybutstrong.com/dl.php?f=tbs_plugin_opentbs_beta.zip&s=2
By: Daniel Degasperi
Date: 2013-07-09
Time: 08:59

Re: xlsx demo and others display incorrectly in libreoffice

> Now workbooks can be opened with LibreOffice.
Great job. It works perfect with LibreOffice.

> Can you check if it also works with some of your tools, such as gnumeric?
Gnumeric for Windows does not throw errors anymore, but still has problems with text-based columns. Only numeric columns are shown correctly.

> It it's clearly related to the OPENTBS_DELETE_SHEETS operation.
Ok, thanks for the information.

Best regards,
Daniel
By: Skrol29
Date: 2013-07-14
Time: 00:41

Re: xlsx demo and others display incorrectly in libreoffice

Hi Daniel,

The last beta version do fixes the problem with "Open XML SDK 2.0 Productivity Tool for Microsoft Office".

Regards,

http://www.tinybutstrong.com/dl.php?f=tbs_plugin_opentbs_beta.zip&s=2
By: Daniel Degasperi
Date: 2013-07-29
Time: 09:18

Re: xlsx demo and others display incorrectly in libreoffice

Perfect. I've also successfully opened the export in "Open XML SDK 2.0 Productivity Tool for Microsoft Office".

Still Gnumeric for Windows has some problems. But this isn't important for me.

Best regards,
Daniel
By: Skrol29
Date: 2013-07-31
Time: 11:20

Re: xlsx demo and others display incorrectly in libreoffice

Thanks for your help on this.

I will have a look at Gnumeric later.

Regards,