https://bugs.documentfoundation.org/show_bug.cgi?id=161787
Bug ID: 161787
Summary: On opening Excel spreadsheet with function and
intersection character (space " " for Excel), change
to intersection character (exclamation mark "!" for
Calc)
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ovari...@zoho.com
Description:
On opening Excel spreadsheet with function and intersection character (space "
" for Excel) should change intersection character (exclamation mark "!" for
Calc).
Steps to Reproduce:
1. Excel spreadsheet, Sheet2:
(a) Cell C16:
=INDIRECT(B16) INDIRECT(C15)
(b) Cell D16:
=INDIRECT(B16) INDIRECT(C15)>5000
Actual Results:
(a)
Displayed: {=INDIRECT(B16) INDIRECT(C15)}
Value: Err:509
(b)
Displayed: {=INDIRECT(B16) INDIRECT(C15)>5000}
Value: Err:509
Expected Results:
Currently:
(a)
Displayed: {=INDIRECT(B16)!INDIRECT(C15)}
Value: 7,131
(b)
Displayed: {=INDIRECT(B16)!INDIRECT(C15)>5000}
Value: TRUE
When Calc supports Dynamic Arrays:
(a)
Displayed: =INDIRECT(B16)!INDIRECT(C15)
Value: 7,131
(b)
Displayed: =INDIRECT(B16)!INDIRECT(C15)>5000
Value: TRUE
Reproducible: Always
User Profile Reset: No
Additional Info:
Attachments to follow.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
