https://bugs.documentfoundation.org/show_bug.cgi?id=120630
--- Comment #16 from Mike Kaganski <mikekagan...@hotmail.com> ---
Please use "Format quoted field as text" checkbox to treat quoted values as
text. See
https://help.libreoffice.org/latest/en-US/text/shared/00/00000208.html#hd_id314847422.
(In reply to tes from comment #10)
> > ...Without treating unquoted numbers as numbers,
> > you would simply have *all* data from CSV as text - because, well, initially
> > that's all text.
>
> In my opinion the best default setting.
The best *default* setting is the one that works best for most cases for
non-techy majority of users. Fir them, opening a CSV and being unable to sum
values would be unexpected. Given the wast variety of in-the-wild CSV flavors,
with huge inconsistencies and nuances, we provide defaults targeted at that
group, and versatile dialog with telling labels. People who can read RFCs are
expected to be able to guess the meaning of "Format quoted field as text".
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
