https://bugs.documentfoundation.org/show_bug.cgi?id=157560
Bug ID: 157560
Summary: Calc incorrectly converts DEC2HEX function when saving
as Mircosoft .xlsx
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The DEC2HEX
function(https://wiki.documentfoundation.org/Documentation/Calc_Functions/DEC2HEX)
is converted to the basic function com.sun.star.sheet.addin.Analysis.getDec2Hex
when saving a spreadsheet as .xlsx file. This function is not understood by
Microsoft Office.
The correct function in MS Office is also simply
"DEC2HEX"(https://support.microsoft.com/en-us/office/dec2hex-function-6344ee8b-b6b5-4c6a-a672-f64666704619)
Exactly the same problem applies to the DEC2BIN and DEC2OCT functions.
Steps to Reproduce:
1. Start new spreadsheet
2. Enter "=DEC2HEX(16, 8)" into a field (or any other numbers inside the
function)
3. Save as .xlsx
4. Open in MS Office (It shows either "#NAME?" or still has the actual result
saved. When the actual result was saved any update changed the result to "0"
for me)
Actual Results:
"DEC2HEX" has been converted to
"@com.sun.star.sheet.addin.Analysis.getDec2Hex", MS Office does not understand
it.
Expected Results:
"DEC2HEX" remains as "DEC2HEX", MS Office works fine.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
