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?
(In reply to m_a_riosv from comment #2) > I'm wrong or custom formats are not available in LO for PT. > > Isn't this a duplicate of tdf#122472? Possible, but the "custom format" here is in the meaning that not one of the built-ins in Excel/Calc, but entirely user made. Also it is applied by Excel "automatically" somehow, not applied by me manually (if you try to "clear formatting" in Excel, it is not cleared). Yet it may be still a duplicate, I'm not 100% sure what is happening there. I'd keep it open for now.