Created attachment 58218 [details] Cell A4 in pivot spreadsheet is displaying 10 instead of 010 1. Open LibreOffice Calc type into cells: A1: Customer No A2: '010 --> notice I have put the ' character to make it display like text A3: '100 B1: Sells Quantity B2: 1000 B3: 1100 2. Mark cells from A1 to B3. 3. Data | Pivot Table | Create. 4. Current Selection and OK button. 5. Move Customer No to Rows Fields. 6. Move Sells Quantity to Data Fields. 7. Click on OK button. Now data appears in pivot table. Notice in cell A4 there is customer no. "10" displayed instead of 010.
Thanks for bugreport reproduced in 3.3.4 and 3.5.4 on Fedora 64 bit (Windows not tested) Cells are shown inside of PivotTable without leading zeros What is interesting: if we press button "Customer No", then there cells shown with leading zeros If we change cells format on "Sheet1" to text, and then refresh PivotTable, cells becomes with leading zeros
Now I have also tested on LibreOffice v3.5.4.2 on Windows XP. Problem persists.
changing version to 3.3.4 as most early reproducible
I have tested in LibreOffice 3.6.4.3 on Windows XP and I see bug is fixed. P.S. Bug is fixed when reproducing step-by-step from first post bug report. If document attached in first post is opened there is still wrong displayed, but I thing this is due to the fact pivot table was created with defected LibreOffice version. If new pivot table created then it works fine. I am marking this bug as fixed.
In 3.6.4 on RFR 17 64 bit: Even with attached document, if we right hand mouse click ->Refresh, Pivot table becomes correct. We use status WFM if do not know by which exactly patch bug is fixed.