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!

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.

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

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


The import did not succeed.

>* 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.

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

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

> 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

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

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

Thanks for your help on this.

I will have a look at Gnumeric later.

Regards,