https://bugs.freedesktop.org/show_bug.cgi?id=85654
Bug ID: 85654
Summary: FILESAVE: Consolidate don't properly save
'Consolidation ranges' after closing.
Product: LibreOffice
Version: Inherited From OOo
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108695
--> https://bugs.freedesktop.org/attachment.cgi?id=108695&action=edit
Simple sheet with 3 sheets consolidated in the 4th.
As I have learned about consolidation - it is a method of summarizing more
sheets with a similar structure. You can see the definition in Wikipedea. A
pivot-table only takes one source-table, but consolidate can take several
tables.
In the attached file there are 3 sheets with a Name-column and a Payed-column
- all summed up in 4. sheet.
1. Select Data - Consolidate...
2. Select range A1:B20 in sheet 1 and Add this to consolidation range.
3. Do the same with sheet 2 and 3 and remember adding the range to the
consolidation range
4. Copy the result to: Select A1 in sheet 4
5. Mark both Row- and Column-labels.
It should look like this
https://www.dropbox.com/s/h98a58ika7r6bnk/Sk%C3%A6rmbillede%202014-10-30%2013.17.57.png?dl=0
After creating the consolidated table, save the file and close.
Now open the file again and select Data - Consolidate. Only one of the sheets
range are saved - the 2 other has disappeared. Like this
https://www.dropbox.com/s/gexgg6e2mefi19l/Sk%C3%A6rmbillede%202014-10-30%2013.20.14.png?dl=0
More about this Consolidate:
Number format in column 2 in sheet 4 is totally ignored?
If you use 'Link to source data' - empty cells in column 2/sheet 1 to 3 gives a
empty cell in sheet 4. This should be updated in the consolidated table if you
add some values in the source tables.
It would really be nice if you could select external sheets to consolidation
ranges.
I use Windows 8.1 and tested with
LibreOffice 4.3.1.2 and 4.4.0
Apache OpenOffice 4.1.1
--
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
