https://bugs.documentfoundation.org/show_bug.cgi?id=90001
Bug ID: 90001
Summary: EDITING: Delete firsts or lasts sheets used in 3D
formulas generates a #REF error
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 114090
--> https://bugs.documentfoundation.org/attachment.cgi?id=114090&action=edit
References3D.ods (includes 3D formula)
Hi
Delete firsts or lasts sheets used in 3D formulas generates a #REF error
Steps to reproduce:
1. Having a 3D formula like : =SUM(SEL1.C10:SEL10.C10)
2. Right click SEL1 (or SEL10) tab > Delete Sheet
Expected result: formula changed to =SUM(SEL2.C10:SEL10.C10)
Actual result: =SUM(#REF!.C10:SEL10.C10)
I set status to New because reproduced (fr-user) on:
- windows 7/64 & Version: 4.4.2.1
Build ID: 93fc8832889bf050a10ec6d0171dae213adc9b55
Locale: fr_FR
- Linux Mint 17.1 (Mate) & 4.2.7.2
I set REGRESSION because was ok for instance with
4.1.2.3 etait utilisée sous Mint 16
Regards
Pierre-Yves
--
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
