Created attachment 135430 [details] calc-bug reference between cells does not work Hi, I have an ots-file with three sheets. Now I want to duplicate the value from a cell on sheet1 to the same cell on sheet2 and sheet3. In some cases it works, in other cases not. see the atteched file: source (sheet1): pauschal auf Stundenbasis used cells: C1 (empty), M1 (empty), Q1 (actual date =HEUTE() ), C2 (empty) sink (sheet2): pauschal auf Flächenbasis C1: ='pauschal auf Stundenbasis'.C1 -> 0 (as expected) M1: ='pauschal auf Stundenbasis'.M1 -> 0 (as expected) Q1: ='pauschal auf Stundenbasis'.Q1 -> actual date ( =HEUTE() ) (as expected) C2: ='pauschal auf Stundenbasis'.C2 -> ='pauschal auf Stundenbasis'.C2 sink (sheet2): pauschal auf Flächenbasis C1: ='pauschal auf Stundenbasis'.C1 -> ='pauschal auf Stundenbasis'.C1 M1: ='pauschal auf Stundenbasis'.M1 -> ='pauschal auf Stundenbasis'.C1 Q1: ='pauschal auf Stundenbasis'.Q1 -> actual date ( =HEUTE() ) (as expected) C2: ='pauschal auf Stundenbasis'.C2 -> ='pauschal auf Stundenbasis'.C2 curious, in some cells it works, in some cells not.
The cell C2 on the second sheet is formatted as text instead of number. To fix the problem: cut the formula in the formula bar, change the cell format to Number, paste the formula in the formula bar. Closing as NotABug. Please feel free to reopen if I am wrong. Best regards. JBF