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: [email protected]
Reporter: [email protected]
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.
