https://bugs.documentfoundation.org/show_bug.cgi?id=155270
--- Comment #4 from m.a.riosv <miguelange...@libreoffice.org> --- (In reply to James from comment #0) > 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). Empty rows are for the whole row empty, not only one field. > > I - EDITING / FORMATTING - A somewhat similar but opposite vain to > https://bugs.documentfoundation.org/show_bug.cgi?id=149665. What you are trying to do?, please add the PT to the file. > > II - EDITING / FORMATTING - A column of numbers did change to reflect the > custom cell format. please add the PT to the file. > > 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". None empty row on the PT > > > 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 the PT all dates are represented as strings with the same format as in source data. >....... -- You are receiving this mail because: You are the assignee for the bug.