On Wed 18/06/2025 at 13:15, Gary Dale <g...@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
