You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/20 18:02:58 UTC

[Bug 124270] New: Wrong separator '.' when using visual assist to get value from second sheet, should be '!' as in Excel

https://issues.apache.org/ooo/show_bug.cgi?id=124270

            Bug ID: 124270
        Issue Type: DEFECT
           Summary: Wrong separator '.' when using visual assist to get
                    value from second sheet, should be '!' as in Excel
           Product: Calc
           Version: 4.0.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: conny.westh@verimentor.se
                CC: issues@openoffice.apache.org

Wrong separator '.' when using visual assist to get value from second sheet.


Cell formula in Sheet1 looks like this:

=Sheet2.A2


But I expected it to be like this:

=Sheet2!A2

Like it should be '!' as in Excel.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124270] Wrong separator '.' when using visual assist to get value from second sheet, should be '!' as in Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124270

--- Comment #1 from Conny Westh <co...@verimentor.se> ---
With "Visual assist" I mean that i put the cursor i cell B4 in Sheet1 and press
the equal sign ('='), the i klick on the Sheet2 tab and then klick at the cell
A2. When I press ENTER The cursor returns as expected to Sheet1 and cell B4,
but the ereference to the cell in Sheet2 displays like Sheet2.A2 but not as the
expected Sheet2!A2 as it whould in Excel.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124270] Wrong separator '.' when using visual assist to get value from second sheet, should be '!' as in Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124270

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #3 from Edwin Sharp <el...@apache.org> ---
No info from author.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124270] Wrong separator '.' when using visual assist to get value from second sheet, should be '!' as in Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124270

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo
                 CC|                            |elish@apache.org

--- Comment #2 from Edwin Sharp <el...@apache.org> ---
Please attach example.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.