https://bugs.documentfoundation.org/show_bug.cgi?id=168589
Bug ID: 168589
Summary: Formulae in Microsoft Excel spreadsheet change when
opened in LibreOffice calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Created attachment 203009
--> https://bugs.documentfoundation.org/attachment.cgi?id=203009&action=edit
Accounting cashbook - error occurs on "Balances" sheet.
On the "Balances" sheet of the workbook that I have uploaded, the figures in
each column of line 6 are intended to be the sum of the figures immediately
below.
This works correctly in Microsoft Excel, running on a Windows 8 laptop, but
when the workbook is opened on a Windows 11 laptop using LibreOffice 25.8, the
figures on line 6 are the same as on line 7.
For example, the line 6 formula in cell E6 should be =SUBTOTAL(9,E7:E27)
However, when opened with LibrOffice, the formula appears as =SUBTOTAL(9,E5:E7)
--
You are receiving this mail because:
You are the assignee for the bug.
