Change CSV delimiter/separator when saving

[markkuit]

Do you want to request a feature or report a bug? Feature

What is the current behavior? There seems to be no way to set a CSV separator different than comma when saving as CSV. Can't choose a delimiter either. I found out the doc mentions it, but those options don't seem to be available in the desktop version.

Which versions of DesktopEditors, and which OS are affected by this issue? Did this work in previous versions of DesktopEditors? 4.8.6.386

[vatterspun]

I imagine someone coming across this and saying CSV is dead and no one uses it but I've seen a surprising number of cases where the use of various CSV file types are alive and well. Also if you're saving conversational text data, comma-delimited can cause problems because most conversational data will have commas. Some other separator is ideal.

I can't say whether or not this should be a priority for the ONLYOFFICE team, only that it's not a dead format. I can say that LibreOffice already has a pretty good lock on broad format capability, with their CSV options pictured below:

If the priority for ONLYOFFICE is usability and good object management, that won't hurt my feelings.

[markkuit]

I can confirm CSV is still very much used in data exchange (which is, incidentally, the case I needed it for) and quite often the separator is not comma. This is literally the only issue preventing me from using and recommending ONLYOFFICE in my work day and work place.

[markkuit]

Is this in the roadmap by any chance yet?

[EddFigueiredo]

Can't believe this was reported in 2018 and to this day no one did anything... Now that most distros are using OnlyOffice this became a huge problem

[Rita-Bubnova]

Sorry, currently there is no news regarding this issue. Also in 2018 we forgot to mention here, but this is issue 36923 in our private issue tracker.

[markkuit]

I (and my team) simply since ended up switching to another office solution, as the disregard for this was absurd to deal with.

[cnieman]

Someone just brought ONLYOFFICE to my attention, but not being able to set the delimiter (and, to a lesser extent, character encoding) when saving a CSV is a deal breaker for me. It is the first thing I tested as it is something we use regularly. I hope to be able to revisit your office suite in the future when this basic functionality is added.

[Mroussigne]

Any news regarding this feature request ?

[ShockwaveNN]

@Grumbyy Sorry, no news, we'll comment here as soon as our dev team will have free time to implement it

[Mroussigne]

Thanks, I am looking forward to it

[SjoerdV]

Really looking forward to this feature being added

[bbrother92]

Please fix this important issue

[AlejandroMoneoMartinez]

Please fix this, it's very important to save CSV into different separators...

[thedevale]

Please

[leofabris]

Any news?

[Rita-Bubnova]

@leofabris, sorry, no news.

[Foosec]

Bump on this one, as everyone probably knows, its very common to see semicolons or even pipe characters as delimiters. Perhaps this and #982 could be done together? Since it seems to be this isn't programmed because the format selection relies on the OS file selection window under Save As. Perhaps an Export button with the UI inside the editor would be better suited?

[JayRugMan]

Can we get some kind of status on this. Is this something that's just too difficult to do or not a concern for developers? I imported as CSV and it was able to ask where the delimiters were. Can't the same/similar dialogue be used in export or save?

[Rita-Bubnova]

@JayRugMan, sorry, I'm just a QA specialist, I can't answer this question, unfortunately. You better contact sales@onlyoffice.com.

[ethicnology]

?

[rstanuwijaya]

Bumping up the issue. Hopefully can be implemented soon!

[kawaiier]

Would be great to implement the feature

[svtcpx]

This is a BASIC requirement when working with CSV files, especially when working internationally.

[scwall]

Hello, Is it still on? We also need it for our use

[fabianofa]

Right now the alternative is to have LibreOffice Calc and this one in the same system, copy and paste the cells into LibreOffice, then save as, pick csv and check the "Edit filter settings", which btw is a very good reference for what should be done, and then change the settings you want there.

The fact this is almost 7 years old issue is very weird. As said, field and string delimiters, with the charset, are basic settings when dealing with CSV.

[nvkv]

Oh, what a peculiar antiquity. Yes, this feature is much needed. It's ridiculous I have to use LibreOffice to save CSVs from spreadsheets I have prepared in OnlyOffice. Kind of defeats the purpose.

[marcosdly]

So while opening the file I can choose between separators I didn't even know could be used, but I can only save as comma-separated? Sackable.

[DinossauroProductions]

I am a game developer and I'm trying to use .csv files to serve as lookup tables for game data, which is a huge portion of the game I am developing. It is quite bizarre that this feature is now implemented, as I felt that it should be a basic feature of any software supporting .csv file formats. I come from brazil, where the decimal separator is "," and if I am required to put any decimal numbers in my database, I just have to make all sorts of loops, like opening the file on another editor, selecting all "," and substituting them for ";". Come on guys, it can't be that hard to implement, and given the amount of people asking for it in this issue, I think it should be a priority at this point. It's been pointed out 6 years ago and the development team should be aware of this already.

[OskyEdz]

This is the # 6 oldest feature request on this github. I gave the first comment 1 my thumbs up to be prioritized.

[scwall]

Still no news on this feature? we're obliged to install libreoffice to do this on most corporate PCs. @alexeybannov 🤣