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
I cant' reproduce it with Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0c4913e03e8427a576138601958f2dbf13b8c37b CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
You're entirely correct, Xisco. The newer version fixed it, I should have checked whether the version in the default Ubuntu PPA is up to date. Thank you for the help! I'm a bit unsure whether this should be marked as fixed or invalid, I chose invalid for now.
WORKSFORME sounds like the correct choise