https://bugs.documentfoundation.org/show_bug.cgi?id=158432
Bug ID: 158432
Summary: CSV IMPORT: add option to keep (not overwrite) target
cell formatting
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CSV filter applies formatting to imported cells. E.g., it may set column widths
and number formats.
It might be useful to avoid changes of formatting in cases when a user has some
pre-formatted range, and pastes a CSV there, e.g. using
> FilterName="Text - txt - csv (StarCalc)"
> FilterOptions="44,34,76,1,,1037"
> ThisComponent.AreaLinks.insertAtPosition(address,url,source,filter,options)
The 'options' could make use of a new option to avoid change of the target
format. So that the CSV import filter does all the processing of the data in
the file, recognizes it according to the normal rules (as defined in the filter
- e.g., detects special numbers or not; uses fixed widths of separators;
considers E-notation as numbers or strings ...), but when putting it to the
cells on sheet, it would only put data, not formats (so e.g. recognized dates
could possibly appear as numbers - it would be OK).
--
You are receiving this mail because:
You are the assignee for the bug.
