https://bugs.documentfoundation.org/show_bug.cgi?id=173140
Bug ID: 173140
Summary: #ref! is added to subtotals after saving and exiting
an xlsx calc file.
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a spreadsheet with 3 tabs that contain subtotals. I used the subtotal
function from the data > subtotals bar. The subtotals all work fine until I
save and exit the file (saving as an xlsx). when I re-enter the file and go to
one of the subtotaled tabs, every subtotal has a #ref! added to the formula and
the cells report an Err:509.
Steps to Reproduce:
1.subtotal a column in a tab
2.save the file as an xlsx
3.reopen the file and go to the tab.
4.notice the Err:509
Actual Results:
as described.
Expected Results:
I expected the subtotals to still be in place correctly.
Reproducible: Always
User Profile Reset: No
Additional Info:
I found out that if I save the file as an ODS this error does not occur.
--
You are receiving this mail because:
You are the assignee for the bug.
