https://bugs.freedesktop.org/show_bug.cgi?id=78476

          Priority: medium
            Bug ID: 78476
          Assignee: [email protected]
           Summary: EDITING: I'm trying to enter a formula referencing
                    another sheet. When I click the mouse the sheet+cell
                    reference is not entered in the input line.
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.2.3.3 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 98737
  --> https://bugs.freedesktop.org/attachment.cgi?id=98737&action=edit
sample sheet to ilustrate the problem

Problem description: 
problem also described in 
http://ask.libreoffice.org/en/question/11871/im-trying-to-enter-a-formula-referencing-another-sheet-when-i-click-the-mouse-the-sheetcell-reference-is-not-entered-in-the-input-line-ver-40/
As above. I think, that problem concerns some specific worksheets. 
This bug still occures in calc 4.1 and 4.2.3.3 

Steps to reproduce:
1. Open attached file 
2. Select sheet "err_sh"
3. Select cell "C3"
4. Press "=" on keyboard
5. Select another sheet "sh1"
6. Pick with mouse cell "B23"
7. Press "enter" to complete the formula.

Current behavior:
In sheet err_sh the formula does not appear properly and contains only "="

Expected behavior:
There should be created a formula like: "=sh1.B23" in the edited cell in
"err_sh"

Interesting info:
When I start the formula in sheet "sh1" or "st1" everything works OK. It works
ok also if I start in the first row or colum (locked) on sheet "err_sh". Only
unlocked area in "err_sh" seems to be affected with that bug.

Operating System: Windows 7
Version: 4.2.3.3 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to