https://bugs.documentfoundation.org/show_bug.cgi?id=151198
Bug ID: 151198
Summary: Function ROUNDSIG fails to export correctly to XLSX,
or be opened correctly in Excel
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: filters and storage
Assignee: [email protected]
Reporter: [email protected]
Description:
The Calc function:
ARRONDI_PRECISION(((B4/B2)*100);4)
fails to be exported correctly to XLSX format.
When attempting to open the XLSX file generated, Excel flags the cell as
containing an unsupported function, with the following string written into the
cell:
=@_xlfn.ORG.LIBREOFFICE.ROUNDSIG(((B4/B2)*100);4)
Steps to Reproduce:
1. Create a new Calc sheet
2. In cell B2, enter an integer
3. In cell B4, enter an integer
4. In cell B5, enter =ARRONDI_PRECISION(((B4/B2)*100);4)
5. For EN language users, this is the ROUNDSIG function.
6. Save the Calc file.
7. Now Save As Excel XLSX.
8. Open the Excel file in Excel (in my case, Excel for Mac, version 16.65 -
22091101)
9. Notice how the cell with ROUNDSIG function is declared as unrecognized (drop
down flag to left hand side of cell) and instead an error with #NAME? is
displayed in the cell.
Actual Results:
ROUNDSIG function export from Calc to XLSX not supported when reopening file in
Excel.
Expected Results:
The function should be supported, or the nearest appropriate function used when
saving to XLSX.
The nearest function in Excel actually appears to be
ROUND(number;number_sig_figures).
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.4.1.2 / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
