Re: Spreadshi^Heet software

Nuno Silva <[email protected]> writes:
> On 2026-06-28, Stéphane CARPENTIER wrote:
>> For me, the biggest issue with Excel opening CSV is because it assumes
>> things and changes the document based of those fucking assumptions. And
>> once it's change, you can't do anything about it and you have to manage
>> your CSV file before opening it with Excel.
> [...]
>> Some other articles spoke about Excel, I don't know about OpenOffice or
>> OnlyOffice. But what I know is that OpenOffice and OnlyOffice let me
>> chose the field separator and the encoding before doing anything. So if
>> everything is messed up, it's my fault and start again doing the right
>> choices.
>
> Yeah, my thought while I was reading your post was "wait, Excel doesn't
> prompt for this"? I'm quite used to see the comprehensive CSV import
> dialog in OOo/LibO, Excel doesn't do something comparable!?

Excel didn’t offer me a dialog and did expect *.csv files to be
comma-separated, not (for example) semicolon-separated. I guess they
expect comma-separated values to be comma-separated, which is not
_entirely_ unreasonable. Maybe there’s an option somewhere to enable a
dialog but I have better things to do than look for it.

LibreOffice does offer a dialog which lets me select from a range of
separators, but didn’t offer a way to treat ‘,’ as a decimal point, as
far as I could see.

-- 
https://www.greenend.org.uk/rjk/