https://bugs.freedesktop.org/show_bug.cgi?id=71339
Priority: medium
Bug ID: 71339
Assignee: [email protected]
Summary: EDITING SUM function range selection broken
Severity: blocker
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
The SUM function (this is the SIGMA icon next to the formula bar) does not work
as expected.
In some instances: if the range selected has a blank cell in it, the selected
range is truncated to include only cells after the blank cell.
The range has to be updated by editing the SUM() function within the formula
bar to include cells that occurred before the blank cell.
Under all circumstances: if the range selected starts with blank cells in it,
the selected range is truncated to include only cells after the blank cells.
The range has to be updated by editing the SUM() function within the formula
bar to include the blank cells.
The user reason for the blank cells, is that values are entered into the blank
cells at some later time and so should be reflected in the SUM.
This behaviour is a disaster from a business user perspective.
We simply can't explain to non technical office workers why LibreOffice should
appear to be so capricious in this way.
We have found that this behaviour makes it impossible to convert Excel users to
using Libreoffice. This is blocking adoption of Libreoffice in our customer
organizations.
Please correct this behaviour so that Libreoffice sheet behaves in a similar
way to all other major spreadsheet programs such as:
Excel, Google Sheet, Zoho, Kingsoft etc.
Thanks for reading this - I sincerely hope that you choose to fix this as
LibreOffice is such a great alternative to MS Office.
--
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
