[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 #3 from flywire <flywire0 at gmail.com> ---
(In reply to raal from comment #1)
> Look at help:
> https://help.libreoffice.org/7.2/en-US/text/shared/00/00000207.
> html?System=UNIX&DbPAR=CALC&HID=modules/scalc/ui/imoptdialog/
> fieldframe#bm_id3154839
> Save cell content as shown
> Enabled by default, data will be saved as displayed, including applied
> number formats. If this checkbox is not marked, raw data content will be
> saved, as in older versions of the software.
> 
> I think it's not a bug, the "Save cell content as shown" option is about
> formats of data, not about filtered rows.

Disagree, given cell content is not shown because of the format is *exactly*
why it is a bug. There is no other way for user to export data as shown without
changing it or using macro, both unreasonable.

Agree current functionality is "Save data format as shown" rather than "Save
cell content as shown" but the documented intention is clearly to "Save cell
content as shown".

==========

Interesting raising filtering which was unintentionally included in example by
filtering rows rather than hidden/zero-width rows.

Filtering is inconsistent too:

eg hide A2, zero height A4, filtering out A6, A8, A10

cut and paste

Col1    Col2    Col3    Col4
A1      B1      C1      D1
A2      B2      C2      D2
A3      B3      C3      D3
A4      B4      C4      D4
A5      B5      C5      D5
A7      B7      C7      D7
A9      B9      C9      D9


export as csv

"Col1","Col2","Col3","Col4"
"A1","B1","C1","D1"
"A2","B2","C2","D2"
"A3","B3","C3","D3"
"A4","B4","C4","D4"
"A5","B5","C5","D5"
"A6","B6","C6","D6"
"A7","B7","C7","D7"
"A8","B8","C8","D8"
"A9","B9","C9","D9"
"A10","B10","C10","D10"

-- 
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/20210529/2f651e6f/attachment.htm>