https://issues.apache.org/ooo/show_bug.cgi?id=114992
jkfi...@iupui.edu changed:
What|Removed |Added
CC||jkfi...@iupui.edu
--- Comment #6 from jkfi...@iupui.edu ---
I have attempted to replicate this bug using the following build and
configuration:
Apache OpenOffice 4.0.1; AOO401m5(Build:9714) - Rev. 1524958
Windows 7 Ultimate 64-bit, Service Pack 1
Intel Core 2 Duo T6600 2.20 GHz, 4GB RAM
I cannot replicate the warped formula results of the OP or comment 4, but there
is still unexpected behavior in Calc.
Results of initial attempt to replicate using the attachment in Comment 2
(example.ods) and the steps in Comment 1 follow
After completing Step 1 and switching to Sheet1, I am unable to select any cell
in Sheet1 by clicking. The formula remains unchanged after clicking cells in
Sheet1. The only cells that can be added to the formula in Sheet3.B2 are those
cells in Sheet2 or Sheet3.
I have also attempted some follow-up tests with same spreadsheet but slight
modifications. Details are further below, but here are the results of my
tests:
In order for the bug to occur...
1. It seems necessary that the sheet with the formula-in-progress be frozen
(Sheet3).
2. It also seems necessary for one of the other sheets to not be frozen.
Further results:
1. If a sheet is not frozen, we can add a frozen and/or non-frozen sheet's cell
to its formula bar by mouse-click.
2. If a sheet is frozen, we can add a frozen sheet's cell to its formula bar by
mouse-click, but we CANNOT add a non-frozen sheet's cell to its formula bar by
mouse click.
Expected results are received in each test if formulas are entirely typed (no
mouse-clicks).
I believe this is clearly unexpected behavior. By contrast, Microsoft Excel
2010 does not have this problem.
Test Details...
In each of these tests:
A single workbook with three sheets is used.
One or more of the sheets have frozen panes obtained by selecting B2, and
Window->Freeze.
Sheet1.B2 has value 1
Sheet2.B2 has value 2
In Sheet3.B2, we attempt to add the formula '=Sheet1.B2+Sheet2.B2' via
1. Type '=' in Sheet3.B2
2. Switch to Sheet1 and click Sheet1.B2
3. Type '+'
4. Switch to Sheet2 and click Sheet2.B2
5. Press Enter.
The expected result is Sheet3.B2 will display value 3.
Test t1
Sheets not frozen: 2,3
Sheets frozen: 1
Result: As expected.
Test t2
Sheets not frozen: 1,3
Sheets frozen: 2
Result: As expected.
Test t3
Sheets not frozen: 1,2
Sheets frozen: 3
Result: Bug.
Description: No cell in any sheet other than Sheet3 can be selected by mouse
click.
Test t4
Sheets not frozen: 1,2
Sheets frozen: 3
Result: As expected.
Test t5
Sheets not frozen: 2
Sheets frozen: 1,3
Result: Bug.
Description: Sheet1.B2 can be selected by mouse click but Sheet2.B2 cannot.
Test t6
Sheets not frozen: 1
Sheets frozen: 2,3
Result: Bug.
Description: Sheet2.B2 can be selected by mouse click but Sheet1.B2 cannot.
Test t7
Sheets not frozen: -
Sheets frozen: 1,2,3
Result: As expected.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
