[Libreoffice-bugs] [Bug 142553] Save CSV Cell Contents As Shown Ignored for Hidden/Zero-Height Rows/Columns

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142553

--- Comment #5 from flywire <flywire0 at gmail.com> ---
(In reply to Eike Rathke from comment #4)
> (In reply to flywire from comment #3)

Agree, a view of data is the right approach. Looking at the cut-and-paste
output in Comment 3:

- Hidden data is still in the dataset, just not shown (fix the terminology)
- Filtered data is not in the dataset, like a view of a data table (database
query).

The "As formatted (and hidden)" data view (tab delineated) is *exactly* what
cut-and-paste returns (see Comment 3). So should csv export (with comma) by
default.

----------

BUG: csv export exports data the is not in the filtered view

----------

BUG: label "Save cell content as shown" doesn't reflect functionality

----------

No confirmation. Probably few are aware of the intricacies of this
functionality, you never know what you are going to get. Examples below are
default (no user-formatting applied):

*csv_demo1_as_shown.csv*

Date,Amount
25/12/95,1
01/01/21,1.1

*csv_demo1.csv*

Date,Amount
25/12/1995,1
01/01/2021,1.1

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210816/7021e98d/attachment-0001.htm>