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.

Reply via email to