https://bugs.documentfoundation.org/show_bug.cgi?id=111662
Bug ID: 111662
Summary: "="- reference between cells does not work
Product: LibreOffice
Version: 5.3.4.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 135430
--> https://bugs.documentfoundation.org/attachment.cgi?id=135430&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
