https://bugs.documentfoundation.org/show_bug.cgi?id=90573
Bug ID: 90573
Summary: EDITING Entire column/row formula incorrectly changes
on row/column deletion
Product: LibreOffice
Version: 4.4.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
1. Open LibreOffice Calc
2. Alt+T (Tools)
3. O (Options)
4. LibreOffice Calc → Formula
5. Formula Options → Formula syntax: Excel A1
6. OK
7. In cell B4, type: =SUM(D:D)
8. Right click on any row (except row 4), say row 15, and 'Delete Selected
Rows'
9. The formula in cell B4 should be the same as in point 7 but has now
incorrectly changed to: =SUM(D$1:D$1048575)
10. In cell B7, type: =SUM(10:10)
11. Right click on any column (except column B), say column F, and 'Delete
Selected Columns'
12. The formula in cell B7 should be the same as in point 10 but has now
incorrectly changed to: =SUM($A10:$AMI10)
13. The formula function could be replaced by another (eg. PRODUCT) and the
same incorrect change occur.
14. I understand that LibreOffice will have the column and row selection syntax
soon. When LibreOffice understands column and row selection the Formula Options
→ Formula syntax in points 5 could be left as: Calc A1. Hopefully this problem
will be solved by then.
--
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
