search

audreyt / ethercalc

Node.js port of Multi-user SocialCalc
https://ethercalc.net
Other
2.96k stars 533 forks source link

No OpenDocument Spreadsheet support. #289

Open Recharged opened 8 years ago

Recharged commented 8 years ago

I can't export to .ods. I'm not sure if there's a reason behind this, but I'd like to save my spreadsheets in a free-as-in-freedom format.

audreyt commented 8 years ago

Please contribute to https://github.com/SheetJS/js-xlsx — we will add .ODS support as soon as that is implemented upstream

rugk commented 8 years ago

So now XLS export is implemented, but there is still no ODS export. (although you can use ODS for import...)

LAfricain commented 7 years ago

Hi! Yes it will be very good to have the possibility to export in ods. Thank you already for your work... I can just encourage you!

magicvince commented 7 years ago

+1 how can we help you if we don't code?

eddyparkinson commented 7 years ago

Workaround There is an export to excel, and open office can read excel files. Of course you can then save as .ods

But don't think ether calc exports the formulas. To export formula, I think this version works https://github.com/quilt-js There is a pending commit to https://github.com/SheetJS that saves formuals

How to help @magicvince most feature get added by developers. So the more developers who know it exists the more people will add features. Am not sure if anyone has paid money to add a feature, but I am sure there are developers that would add such a feature if paid.

Reneeeee commented 7 years ago

Hi,

When read through the discussion I understood I should be able to export/import .xls(x?)-files from and to ethercalc (on Sandstorm), but I have no clue how to...

Can anyone point me to the right direction please?

rugk commented 7 years ago

Import: Drag & drop Export: There is a button at the top left.

Reneeeee commented 7 years ago

Thanks for the reply: I tried drag&drop earlier, but apparently this isn't supported in Sandstorm.

I looked for a upload/download/import/export-like button, but could find one either.

Am I missing something?

Thanks for your help!

audreyt commented 7 years ago

For Sandstorm, try drag-and-drop on the bottom panel in the space next to "Sheet1".

Reneeeee commented 7 years ago

That did the trick! Although partly: it works the same as select/copy/paste, but unfortunately it got rid of all the formulas and design attributes/elements like fonts, sizes, colors, borders etc.. It only managed to read the output data.

However for exporting to HTML, CSV or EXCEL, I did discover the Floppy disc icon at the top left of the sheet which is great! Thanks

Recharged commented 7 years ago

Why was my issue closed? As far as I can tell, there's still no OpenDocument support.

eddyparkinson commented 7 years ago

@Reneeeee import formulas I believe this works https://github.com/quilt-js but I never did get the time to sort out all the npm changes to make it load into ethercalc. It may need some fine tuning, but if I remember, the code is ready. If you are lucky you just swapping the code modules might be enough, I don't remember the fine details.

audreyt commented 7 years ago

For SheetJS and it seems write-to-ODF support is now implemented, so I've added export to ODS support (simply upgrade to a recent version of j module did it).

Importing in start.html should be straightforward (simply update ./static/xlsx.js to the latest version), feel free to try.

Reneeeee commented 7 years ago

@eddyparkinson & @audreyt thanks guys. Would be great if OD-support work.

Is there anyone who can test the code modules swapping suggested by eddy and/or test the update done by audrey? (I don't have Sandstorm running yet because I am waiting patiently for the apps like ethercalc, etherpad and WeKan meeting my requirements.)

Thanks!!