https://bugs.documentfoundation.org/show_bug.cgi?id=138994
Bug ID: 138994
Summary: Incorrect work =FORMULA()
Product: LibreOffice
Version: 7.1.0.0.beta1+
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
the function FORMULA() returns an incorrect punctuation mark after tab name
Steps to Reproduce:
1.A1 is text1, B1 is text2.
2.A2 is link on A1 with tab name (like without other tab).
3.=FORMULA(A2)
4.=INDIRECT(SUBSTITUTE(FORMULA(A2);"=";""))
5.=OFFSET(INDIRECT(SUBSTITUTE(FORMULA(A2);"=";""));0;1)
Actual Results:
3: =$tab.A1
4: EROR
5: EROR
Expected Results:
3: =tab!A1
4: text1
5: text2
Reproducible: Always
User Profile Reset: No
Additional Info:
In M$ excel work correct. See attach example.
--
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
