It’s not an issue at all.
The csv import options are stored in your profile. Simply hit Enter to confirm the settings you applied last time.
1 Like
This delimiter problem can be easily solved by adding a function to the macro I described earlier in this thread.
I solved my issue by implementing a custom desktop file for importing CSV with default values for English. I really do not see why a config file would not work for the majority of users for their data import schemes. It’s very easy to have a YAML file with a list of different import schemes depending on what’s being implemented. Could be abstracted and work for importing other file types as well.
.
Before importing the user configures the import scheme desired for data from that organization, and can change it if needed for other organizations. Something similar would still apply for other file formats. I mean VIM supports stuff like this for all sorts of files in Vimscript.
Not saying there are not problems. It just seems like settings that could be saved per user based on the data they’re working with.
Why should I be doing that every time is my point if Libreoffice already knows my last import settings, which were the default setting Libreoffice gives me. Multiple CSV files from different companies, and different websites all import the same for me.
.
This is largely whey I believe Libreoffice should implement shares using cryptocurrency and their end users could then vote on where funds get directed for development. This sounds like a feature your users want, which would increase shareholder value.
feel free to contribute to the real world : https://community.documentfoundation.org/t/update-on-budget-2024/12219
and again :
1 Like
All crypto is is a means of issuing financial products without involving an intermediary. It literally lowers the cost for issuing shares and bonds, while reducing the cost of capital allocation in the process through automating financial institutions. It makes sense for a lot of open source projects to move towards this to receive funding by investors looking to receive ROI. Open source is extremely capitalist friendly.
.
I’d give money to fund features I think would make LIbreoffice more competitive against the Microsoft software stack if I could receive ROI. I’m honestly, more likely to fund a fork of Libreoffice as I think the management behind it has problems.
.
I really do not understand why a large group of developers using Libreoffice are opposed to developing a means of autoimporting. Especially, when large corporations, like the big four standardize how their spread sheets are formatted. I’m pretty sure having to go through that import window is the minority of use cases for spreadsheets, after doing it once. Especially, in the English speaking world, and the majority of countries with large populations and high GDPs.
Welcome to AskLibo! - #3 by alexanderwerner
Please be reminded that this is not a forum, so you are encouraged to revise your questions and answers, and comment other questions and answers if they seem unclear, but not to discuss topics.
Just a troll.
2 Likes
It’s clearly a problem with a solution as mentioned here.
.
I don’t understand why there’s so much resistance on this one particular issue for improving UX. If a file gets imported incorrectly on those edge cases they could just go through the dialogue.
Beause you are just a manipulative coin bro.
1 Like
I’m a capitalist. Are the LIbreoffice developers all opposed to capital markets? Are you some type of Communists, like Mozilla?
.
Literally, all cryptocurrency is is equity markets with a bunch of traditionally left wing jobs, in compliance and regulation, that introduce capital inefficiency, automated out of existence. Those jobs are replaced by computers. It literally let’s everyone with some savings play venture capitalist. It’s literally no different from the US equity markets, or any equity market. There are just as many scams as you find in regulated markets.
.
That’s not to mention the fact sending large amounts of money, and making large financial transactions have cheaper fees than tradfi. All of the financial markets are filled with fraud. It’s kind of the standard when dealing with money.
First. You are off topic. No more posts about unrelated stuff please, you are close to the line.
.
You are talking to users here, not developers.
.
You are welcome to use whatever office suite you like.
.
If it isn’t a high priority for most people (it isn’t) then you may pay someone to add the option of importing csv with the previous settings to LibreOffice.
I’m sorry.
.
I’m just surprised this entire topic gets responded with hostility by a vocal part of the userbase and developers. By looking over that bug report it looks like the topic causes flame wars. Sounds like it has something to do with region and language spoken for whether CSVs import easily or not. I just find it strange there’s a group so opposed to this when even the people believing the dialogue prompt is the right choice most likely have a general case that would work for most imports.
.
I understand it’s not a priority. I don’t even really need it since there’s a workaround. I just seems like an easy feature to add if anyone felt like it. It’s just a config file parser, and it looks like most of the code required to implement the feature is already there. I might do it myself if I have the time.
Some of the hostility comes from using Excel in a country that does not use USA type date formatting. In New Zealand, when Microsoft removed the text import dialogue, importing CSVs became an exercise in vigilance.
With date columns, Excel would convert anything that looked like a date to USA format where it could, the rest of the column was left as text in NZ date format causing damage to data as dates were wrongly created. Probably Excel has got better at reading locale from its own settings but I am not interested in buying it just to test that.
.
I had to create macros to import CSVs that were exported from our database to avoid such damage. You can create your own macro to import CSV if it is always the same layout. The book by Pitonyak is a good start for understanding LibreOffice macros, www.pitonyak.org/oo.php
2 Likes
In countries such as the US, UK and Australia, the default list separator is a comma, so you get CSV comma delimited. In non-English speaking European countries, a comma is reserved for the decimal symbol, and the list separator is generally set to semicolon. Based on this, your demand is quite unreasonable for the simple reason that at some point the translation has to be done anyway before the listing is printed on the screen or on paper. So now the question turns upside down: who are there more in the world, ordinary consumers or people working in the financial sector? And last but not least, who will end up footing the bill?
1 Like
While I can see the polarized opinions, I fail to see the stated “hostility by … developers”. Could you please point to the source of this specific part of your statement?
For my part, I see greed (even a bit of McCarthyism) in some of the opinions. Everything should be available to them for free. As far as I know, when running a business, for example, investments in software are tax deductible.
Well, it seems to be very common for deep rooted capitalists, for example, when they’re driving their luxury car and the road has potholes, they complain that nothing works, but at the same time they demand tax breaks and foremost see commies everywhere 
OK, let’s dumb down further.
What is this: 123,456 
Well, if you add a € sign after that, it’s just pocket money.
But if you add a $ sign in front of it, it’s quite big pocket money
Wrong. It’s 2 integers separated by a comma. 
1 Like
That was pretty good 