https://bugs.freedesktop.org/show_bug.cgi?id=75053
Priority: medium
Bug ID: 75053
Assignee: [email protected]
Summary: Delete column modify wrongly formula
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
Created attachment 94160
--> https://bugs.freedesktop.org/attachment.cgi?id=94160&action=edit
Test file to delete column B, and check formula in column C
Problem description:
When deleting column referenced in other formula, formula are modified but do
not content #REF! as they should, even if they display #REF!.
When undo deletion, formula are wrongly restored, and display #REF!, even after
Ctrl+Shift+F9
Steps to reproduce:
1. Create new file (or open attached document) with values in column A, column
B=2*A, column C=B+A
2. Delete column B
=> Column C display #REF! which is normal
3. Click on a formula in column C
Current behavior:
Formula is "=A2+A2"
Expected behavior:
Formula should be "=#REF!2+A2"
Second steps:
4. Hit Ctrl+Z to undo
Current behavior:
Column B is restored (OK).
In column C, only the first formula in C2 is correctly restored: other cells
display #REF! and formula is "=A3+A3"
Expected behavior:
Column B and C should be restored. Formula in C3, C4,... should be "=B3+A3"
Confirmed on Win7, Version: 4.2.0.0.alpha0+
Build ID: 4a8f7ddc290d1ea3131de6611b6833b77ac7ab1f
Time: 2013-08-28_11:14
Regression against Version: 4.2.0.0.alpha0+
Build ID: 2f6cbe13e61c44d4bab8192a4708b698d3d9da33
TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-07-25_00:00:21
--
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
