https://bugs.documentfoundation.org/show_bug.cgi?id=162595
Bug ID: 162595
Summary: Generated Titles of Pivot Table Should Be Editable
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
While working with Pivot Tables, I was not able to edit the genereted title of
a column. As a result, I could not use Calc for the task I had to complete,
because the generated title was wrong semantically.
Steps to Reproduce:
1. Create a Pivot Table out of some sample data.
Example for sample data:
|Number|Room Number|m²|
|------|-----------|--|
|1 |Living Room|30|
|2 |Bedroom |25|
|3 |Closet |12|
2. Configure the Pivot Table as follows:
Drag the buttons for "Number" and "Room Number" to the Row Fields area. Drag
the button for "m²" to the Data Fields area.
3. The resulting Pivot Table should be as follows:
|Number |Room Number|Sum - m²|
|------------|-----------|--------|
|1 |Living Room|30 |
|2 |Bedroom |25 |
|3 |Closet |12 |
|Sum - Result| |67 |
4. The title "Sum - m2" ist wrong. The values in this column aren't sums. The
one an only sum in this table is the value in the results row. Try to rename
the title "Sum - m2" to "m2" or "Area - m2". Calc will refuse to rename the
title.
Actual Results:
The genereated title for that column, which contains the values to be summed up
in the very last row, is "Sum", which is wrong.
Expected Results:
One should be able to rename the title of the row.
Reproducible: Always
User Profile Reset: No
Additional Info:
Possibly compare with with a Pivot Table in Excel. The generated titles are
similar (wrong), but you are able to rename them.
--
You are receiving this mail because:
You are the assignee for the bug.
