https://bugs.documentfoundation.org/show_bug.cgi?id=104731
Bug ID: 104731
Summary: Formulas in many cells are totally corrupted when some
other data in the spreadsheet in transposed
Product: LibreOffice
Version: 5.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A simple paste special with transpose operation results in the complete
corruption of formulas in other range on the sheet, that have no relation
whatsoever with the cells where the paste operation is enacted. See below
"steps to reproduce" for details.
Steps to Reproduce:
1. Open the attached file. in the range A1:E9 there are some formulas, that
have only references within that range (check it out if you want).
2. Now select the data in range A15:G16, cut it, select as active cell A15 and
paste special the data there using the "transpose" button.
3. The direct result is ok, but as a result, most formulas in the rage above
A1:E9 get totally corrupted since their references to other cells are changed
in an apparently random fashion.
4. This results in a complete mess and loss of the correct formulas in A1:E9
Actual Results:
Formulas get their references messed up completely
Expected Results:
Nothing should change to formulas in A1:E9 range
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
