https://bugs.documentfoundation.org/show_bug.cgi?id=167762
Bug ID: 167762 Summary: =(1,01)^1/12 fails in most columns but not in the T column or A to H Product: LibreOffice Version: 24.2.7.2 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: documentfoundation.that...@passmail.com Description: A fairly simple formula fails in some columns but work in other. see screenshot bellow. from what i can see if i paste it into the T or A To H columns it works fine but all other fails, the row nr doesn't look like it makes a difference. =(1,01)^1/12 This happens all the time it this document but not if i open a fresh document. but closing and opening the document changes nothing. There is no other strange behavior Steps to Reproduce: 1. not sure how the document got to this state, i was just playing around with formulas. changes that can be worth noting is changing default currency to euro and date and time to ddmmyyyy and to use , instead of . for decimals. 2. copy paste the formula to different columns (it's the same if written by hand) 3. Actual Results: =(1,01)^1/12 => #### Expected Results: =(1,01)^1/12 => 0,08416666 Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: fr-FR (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.