https://issues.apache.org/ooo/show_bug.cgi?id=114992
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from [email protected] --- 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.
