https://bugs.documentfoundation.org/show_bug.cgi?id=152805
Bug ID: 152805
Summary: indirekt() works incorrectly after Excel import
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The Calc function INDIREKT() works incorrectly. If a document was imported from
an xlsx file and saved as an ods file, these two problems then occur:
1. =INDIREKT("xyz.A1") produces #REF! with the separator "!" however not. =>
=INDIREKT("xyz!A1")
2. The table name cannot contain spaces, as this also results in #Ref! leads.
=> =INDIREKT("xyz xy!A1")
Steps to Reproduce:
1.xlsx document save as ods document
2.use INDIREKT() with "."
3.
Actual Results:
345
Expected Results:
#REF!
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
