Open LibreOffice type into cells:
A1: Customer No
A2: '010 → notice I have put the ’ character to make it display like text
B1: Sells Quantity
Mark cells from A1 to B3.
Data | Pivot Table | Create.
Current Selection and OK button.
Move Customer No to Rows Fields.
Move Sells Quantity to Data Fields.
Click on OK button.
Now data appears in pivot table. Notice in cell A4 there is customer no. “10” displayed instead of 010.
Is this a bug? Can I overcome this settings?
LibreOffice 3.5.0 on Windows XP.