https://bugs.documentfoundation.org/show_bug.cgi?id=155402
Bug ID: 155402
Summary: FILEOPEN XLSX CELL() function gives different value
compared to Excel with filename parameter
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
URL: https://help.libreoffice.org/7.5/en-US/text/scalc/01/0
4060104.html?DbPAR=CALC#bm_id3155509
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 106151
Created attachment 187392
--> https://bugs.documentfoundation.org/attachment.cgi?id=187392&action=edit
Example file from Excel
Attached document contains a CELL() function call with the "filename" infotype
parameter. (also all other supported infotypes using attachment 187170 as
external example file, but focus only on this one here)
In Excel this gives a string in the driveletter:\<path>\[filename]Sheetname
form, e.g
C:\Users\Gabor\Documents\[cell-function.xlsx]Sheet1
In Calc this is opened differently (and as
'file:///C:/Users/Gabor/Documents/cell-function.xlsx'#$Sheet1
It would be more interoperable to imitate the Excel-like behavior, at least in
case of xlsx-files. See also bug 106151 which suggests introducing a CELL.XL
function for interop purposes, starting with a different interop problem.
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: b3c88dc039d447322b8c8c564ab6e2f0ce9c5b90
CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded
and back to 3.5
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=106151
[Bug 106151] Add a new CELL() function for Excel compatibility
--
You are receiving this mail because:
You are the assignee for the bug.
