https://bugs.documentfoundation.org/show_bug.cgi?id=165932
Andrew Kopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|medium |low Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #5 from Andrew Kopf <[email protected]> --- Hello Ole Tange, Thank you for reporting the bug. I can confirm that the bug is present in master. Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 19f3b72f34c487dc97d582712d21734a7e055fd5 CPU threads: 22; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded The issue concerns the conversion of a formula that Excel does not like. Original formula =IF(C9>0 AND (TODAY()-A9-365) > 0, "For gammel startdato", "OK") It is not Excel-compliant. When turned into XLS, it becomes =IF(AND(C9>0, (TODAY()-A9-365) > 0), "For gammel startdato", "OK") This conversion is not done when saving to xlsx, and Microsoft is removing the broken formula. -- You are receiving this mail because: You are the assignee for the bug.
