https://bugs.documentfoundation.org/show_bug.cgi?id=155270
Bug ID: 155270
Summary: [ Calc - 7.5.3.2 (X86_64) / LibreOffice Community ] [
3x issues identified while using Pivot table, 2x
EDITING / FORMATTING and 1x UI ]
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Feel free to break this out into sub bugs if need be.
0 - UI - Despite having "Ignore empty rows" enabled under the options sub menu,
refreshing does not remove (empty).
I - EDITING / FORMATTING - A somewhat similar but opposite vain to
https://bugs.documentfoundation.org/show_bug.cgi?id=149665.
II - EDITING / FORMATTING - A column of numbers did change to reflect the
custom cell format.
Steps to Reproduce:
0 - UI
----------------------
1. Have a data set containing filled and empty rows.
2. Create a pivot table using the above.
3. Do not tick "Ignore empty rows" under options
4. Upon pivot table creation; Right click then "Properties".
5. Options -> tick "Ignore empty rows".
6. Hit ok and then right click, selecting "Refresh".
I - EDITING / FORMATTING
----------------------
1. Raw data is "3/1/2022"
2. Somehow during processing it become "'3/1/2022".
3. Removing the "'" allows for it to be converted to ISO-8601.
In this case I had several; entires of "'X/X/XXX" and was unable to use find
and replace to perform step 3.
II - EDITING / FORMATTING
----------------------
1. Have data such as XXXXXXXX
2. Highlight all applicable cells.
3. Right click, format cells.
4. User-defined.
5. Enter "0## ### ####"
Actual Results:
0 - UI
----------------------
(empty)
I - EDITING / FORMATTING
----------------------
3/1/2022
II - EDITING / FORMATTING
----------------------
XXXXXXXX
Expected Results:
0 - UI
----------------------
Render the cell blank as the case with pivot table data.
I - EDITING / FORMATTING
----------------------
2022-01-03
II - EDITING / FORMATTING
----------------------
0XX XXX XXX...
Reproducible: Always
User Profile Reset: No
Additional Info:
Upgraded from 7.4.X.X.
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-US
Calc: CL threaded
Workbook layout
Sheet A - Data set A
Sheet B - Data set B
Sheet C - Combines Data set A & B
Sheet D - Pivot table using Sheet C
--
You are receiving this mail because:
You are the assignee for the bug.
