Re: strange behaviour in LibreOffice Calc save to CSV

["Gareth Evans" <donotspam@fastmail.fm>]

On Wed 18/06/2025 at 13:15, Gary Dale <gary@extremeground.com> wrote:
> If I open a .csv file containing e-mail addresses then save it back as a 
> .csv, underscores and "@" get translated into a character code. It does 
> this whether I use save or save as.
>
> However, if I check the box in the save as dialog to edit the filter 
> settings, it saves properly, even if I don't change any filter settings.
>
> It's only recently (for the last month) started doing this. Before it 
> saved the characters as themselves rather than codes.

Hi Gary,

I noticed character encoding of @ signs recently in calc and it turned out the file had been saved (or perhaps just loaded) with a non UTF-8 character set.  Correcting this in the CSV options screen on loading fixed it.  Presumably the original encoding is retained unless changed, deliberately or otherwise.

I seem to get the "edit filter" dialog whether "edit filter" is ticked or not, when saving to CSV.

$ apt policy libreoffice
libreoffice:
  Installed: 4:25.2.3-2~bpo12+1
  Candidate: 4:25.2.3-2~bpo12+1
  Version table:
 *** 4:25.2.3-2~bpo12+1 100
        100 http://deb.debian.org/debian bookworm-backports/main amd64 Packages
        100 /var/lib/dpkg/status

Does that help?

Gareth