[Libreoffice-bugs] [Bug 115214] FILESAVE XLSX Function Syntax Error (#Name?), with a reference to an external xlsx file and Excel formula syntax

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=115214

--- Comment #12 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 175176
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175176&action=edit
The example files after selecting the MAX functions target with Excel A1 syntax
enabled

Still a problem in

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 770dcb1f717d576facf31efed14bee403e1a7155
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Downloading attachment  139345 and attachment 139346 then reselecting the MAX
functions  range in the Function Wizard results in #NAME? error. Resulting
formula is:
=MAX('file:///c:/users/kelemengabo/downloads/function_error_source.xlsx'#$sheet1.a$1:A$3)

Works fine with Calc A1 formula syntax enabled, the formula is:
=MAX('file:///C:/Users/kelemengabo/Downloads/Function_Error_Source.xlsx'#$Sheet1.A$1:A$3)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210921/f8e31bc9/attachment.htm>