[Libreoffice-bugs] [Bug 111662] New: "="- reference between cells does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: ib-zoelch at t-online.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170810/2da5b734/attachment-0001.html>