Created attachment 203181 [details] Example file from Excel Attached example file has a custom number formatting applied on data used by a pivot table. The pivot table also uses this custom number format, but when the file is opened in Calc, it resets to standard number format. 1. Open attached file -> in the pivot table on Sheet3 the number appear as 1, 2 instead of the custom format that would show "less" and "much" strings instead of these. On the Sheet1.F2:G5 range - which are plain cells without pivot table - these custom number formats work. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 708abf24664a9a1aaeac452bcc8436026030e74e CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: de-DE (hu_HU); UI: en-US Calc: threaded and back to 3.3
Created attachment 203182 [details] The pivot table in Excel and Calc
I'm wrong or custom formats are not available in LO for PT. Isn't this a duplicate of tdf#122472?