search

scraperwiki / xlsx-cgi

0 stars 0 forks source link

Won't open in libreoffice or gnumeric #1

Closed pwaller closed 10 years ago

pwaller commented 10 years ago

I've just tried two open source spreadsheet applications and neither can read the output generated by sqlite2xlsx :(

Both show just a single row. One gives no errors, gnumeric reports:

Encountered uninterpretable "ext" extension in namespace "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}"

pwaller commented 10 years ago

Ah, b760cd44f9807af96b185251f130ea87daaddede did fix the problem of there being one row in both applications.

Now it's just the problem of the mysterious namespace.

sean-duffy commented 10 years ago

Does LibreOffice read the file with no errors now?

pwaller commented 10 years ago

Yes @sean-duffy

pwaller commented 10 years ago

I'm inclined to think the uninterrpetable "ext" namespace is a bug in gnumeric:

https://bugs.freedesktop.org/show_bug.cgi?id=30770

We may consider removing the offending tag if the resulting file still works in all software.

pwaller commented 10 years ago

Here is a branch with the offending tag removed:

https://github.com/sean-duffy/xlsx/pull/2

However, it changes the error to Unknown theme colour 1, which is annoying. I think it's an unrelated problem with gnumeric.

pwaller commented 10 years ago

https://github.com/sean-duffy/xlsx/blob/5afc11737b09883ff4b04521c817ba9680604e90/templates.go#L106 are the cause of the Unknown theme colour 1, I think. It would be nice to try and eliminate this.

pwaller commented 10 years ago

https://github.com/sean-duffy/xlsx/pull/3 and https://github.com/sean-duffy/xlsx/pull/4 fix the remaining issues, and then it is error-free in gnumeric, which is a good sign, I think! :)

sean-duffy commented 10 years ago

These pull requests have been merged now.