Hi Friends!
For the Italian association to which I belong, I’ve just installed, by native “deb” packages (not Docker), on my own Debian Server, Collabora Online 6.4 on Nextcloud 19.01 and all seems to works fine
I, however, a worry: how is it possible to export CSV from Collabora Online spreadsheet?
Actually if I go to “Save As” no any other options/possibilities can find:
I’ve find this documentation , but I don’t find a match, and what I expect to find is also, be able to activate options format into “Save As” menu item.
Do I need to complete additional server-side procedures?
For the Italian association to which I belong, I’ve just installed, by native “deb” packages (not Docker), on my own Debian Server, Collabora Online 6.4 on Nextcloud 19.01 and all seems to works fine
that’s great!
I, however, a worry: how is it possible to export CSV from Collabora Online spreadsheet?
Actually if I go to “Save As” no any other options/possibilities can find
Yes! You can just rename the file extension to .csv and it should work
Save as .CSV
File > Save as…
Rename file extension to .csv
you can now test it by trying to import it
Import .CSV
Open you .csv file using your preferred simple text editor
Select all its contents
Copy ctrl + c
Go to your Collabora Online browser tab and open a spreadsheet document
Paste it ctrl + v
A dialog appears where you can tweak the formatting (separated by comma) and check the preview, hit ok : )
I’ve made some test, and confirm: “saving as” csv convert files to “comma separated values” files.
But things happen:
the file is exported in UTF16, where here in Italy we use UTF8 (so, at first sight, it seems unreadable, with all the consequences that this can generate in non-expert users. You had me going there…
(Optional) Set the field options for the Text CSV file.
Select Edit filter settings.
In the Export of text files dialog, select the options that you want.
Click OK
but there is not an text export files dialog, where to customize the csv output format. Why does the documentation describe something that isn’t there? Would I need to install something additional on the server side?
into documentation, on point 5 is described
…
Why does the documentation describe something that isn’t there?
The documentation is for Collabora Office, while we discuss Collabora Online here Of course, the latter has a very different UI, and what you read for the former might not apply for the latter. It’s not “something that isn’t there”
You are right, it seems there’s no way to export to CSV with settings.
While IMO it should not allow to “download as” CSV (for the obvious reason that CSV can’t handle most basic cases, like several sheets in a file), it seems natural to provide the CSV in the clipboard when you select and copy. Currently it seems to put some TSV-like thing to clipboard in that case, e.g. skipping empty cells.
Wrt UTF-16: I couldn’t repro that on our test instance. For me, it exported in ASCII or something like that (e.g., turned Russian characters into ?). Possibly that depends on some server configuration (locale? Collabora Office’s registrymodifications.xcu?).
I wonder if there is a better way to avoid misunderstandings, maybe by not loading the newly created text file (.csv) automatically (because it kinda by passes the import options step leading to faulty end result).
However that type of behavior (to load automatically) is expected from Save as hm…
I’m not sure to have understand what you mean, but from my CO installation, I’ve not the ability to import CSV.
Trying to open any “.csv” file from NextCloud (open with Collabora Online Developer Edition…) do not produce any understandable spreadsheet.
I want to clarify that this CSV was created by CO.
Yes, i’ve been seen your previous post where you described the same procedure, anyway what need is a easiest way, otherwise Google Documents eats gnocchi on our heads *