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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)