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
Of course it isn't, Excel does not have a ROUNDSIG() function. And no, anything ROUND() is not an equivalent for the functionality.
(In reply to Eike Rathke from comment #1) > Of course it isn't, Excel does not have a ROUNDSIG() function. > And no, anything ROUND() is not an equivalent for the functionality. What would the solution be then, to have interoperable, dataloss-free functionality in such a situation ? Just so that I know not to send any of my clients an exported sheet containing that Calc function in the future.