https://bugs.freedesktop.org/show_bug.cgi?id=78925
Priority: medium
Bug ID: 78925
Assignee: [email protected]
Summary: EDITING: Formulas with custom functions are not
properly handled
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 99355
--> https://bugs.freedesktop.org/attachment.cgi?id=99355&action=edit
A test case file
Version: 4.2.3.3
Build ID: 4.2.3.3-1.fc20
System: Linux Fedora 20 x86_64
Desktop: Cinnamon 2.0.14-15.fc20.x86_64
Steps to reproduce (100% reproducible):
1) Open a new Calc document
2) Go to menu Tools->Macros->Organize macros->LibreOffice Basic
3) Select "Untitled1" (or whatever the current file name is) and click New to
create a new module "Module1"
(But this bug also applies to global macros)
4) In the module enter the following 2 functions
Function fn_1(d as any) as any
fn_1 = "FN_1"
End Function
Function fn_2(d as any) as any
fn_2 = "FN_2"
End Function
5) Select Sheet1
6) Enter this formula in cell A1: =FN_1(1)
7) Enter this formula in cell B1: =FN_2(1)
Expected result:
- cell A1 has formula "=FN_1(1)" and shows string "FN_1"
- cell B1 has formula "=FN_2(1)" and shows string "FN_2"
Actual result:
- cell A1 has formula "=FN_1(1)" and shows string "FN_1"
- cell B1 has formula "=FN_1(1)" and shows string "FN_1" (the bug)
- attempts to re-enter the formula "=FN_2(1)" in B1 again are ignored (the
formula is reset back to "=FN_1(1)" on Enter).
PS. Attached a file with those steps performed (but not sure you want to open
someone else's file with macros :-) ).
--
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
