https://bugs.documentfoundation.org/show_bug.cgi?id=101696
V Stuart Foote <vstuart.fo...@utsa.edu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |vstuart.fo...@utsa.edu
Ever confirmed|0 |1
Severity|normal |enhancement
--- Comment #1 from V Stuart Foote <vstuart.fo...@utsa.edu> ---
This already exists!
"Scientist" users need simply set a cell format as "Text" (Format -> Cells ->
Numbers tab: Text) for the target Column/Row or Sheet.
No conversion/corruption of the data being pasted will occur.
Also when opening to import TSV or CSV, the default column import format is
"Standard"--a standard import assigns all fields as "Number" with "General"
format--and again no conversion to a "Date" format will occur.
And after "Standard" import, the cell formats for the whole sheet can be set as
"Text" and the cell type protected.
Alternatively, the import cell format for the columns of the TSV or CSV can be
forced to "Text" (rather than "Standard") from the import dialog if
preferred--a simple drop down list selection while completing the import
dialog.
Suppose providing a user setting forcing the import dialog to "Text" format
might be a valid UI setting that could help issue of carelessness of
"Scientists" as described.
And possibly a similar sheet setting for paste actions, i.e. to "paste into
cells as 'Text' value" only should be possible.
--
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
