https://bugs.documentfoundation.org/show_bug.cgi?id=89102
Bug ID: 89102
Summary: PIVOTTABLE wont work if heading ends with '*'
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113110
--> https://bugs.documentfoundation.org/attachment.cgi?id=113110&action=edit
Example of a heading that ends with '*'
If you try to create a PivotTable and your heading ends with '*', it won't
work.
For example, this:
-----------
MyHeading*
A
B
C
A
B
A
-----------
When you create a PIVOTTABLE from this, the button in the Pivot Table dialog is
shown as 'MyHeading', not 'MyHeading*'. My guess is that the problem is here.
Steps:
1) Open a new spreadsheet and copy the rows above or open the attachment.
2) Click 'Data' -> 'Pivot table' -> 'Create...'. LibreOffice Calc will select
your data. Click 'OK' in the 'Select Source' dialog.
3) Move the 'MyHeading' button to the row or column box and click 'OK'
If you had the 'Data' field in the column box (it's pre-selected there), you
get an empty PIVOTTABLE. If you remove the 'Data' field, you get a "The pivot
table must contain at least one entry." message.
Creating a PIVOTTABLE from the following works:
-----------
OtherHeading*b
D
E
F
D
E
D
-----------
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
