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

          Priority: medium
            Bug ID: 76470
          Assignee: [email protected]
           Summary: Crash when inserting/deleting rows with absolute
                    reference
          Severity: critical
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: NEW
           Version: 4.2.3.1 rc
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 96187
  --> https://bugs.freedesktop.org/attachment.cgi?id=96187&action=edit
Insert row in row 3 does not operate

Description: Inserting/Deleting rows are inoperative with formulas. If action
is repeated, then crash

Steps to reproduce:
1. Create a new spreadsheet
2. Insert values in column from A1 to A4
3. In B1 to B4, insert formula "=$A$4"
4. right click on row# 3 > Insert Rows Above

Current behavior:
Nothing happen. 
- If you repeat Insert Rows, then crash
- If you try to select a cell, nothing happen (no selection)

Expected behavior:
A row should be inserted above row 3, and formulas should be updated.

The problem is the absolute reference to a cell below ($A$4). If you replace
with relative reference, then row is inserted.
The problem is with row 3: if you insert in row 2 or 4, then row is inserted.

Confirmed with
Version: 4.2.3.0.0+
Build ID: cade56eef6d23aa7dd6e374858cf30ff3fcd163b
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-07_13:22:50

Version: 4.3.0.0.alpha0+
Build ID: 9278df2c21fed09b6b10465ca33b227ad7c49b41
TinderBox: Win-x86@47-TDF, Branch:MASTER, Time: 2014-03-19_08:44:54

Version: 4.2.3.1
Build ID: 3d4fc3d9dbf8f4c0aeb61498a81f91c5b7922f13

NOT confirmed with
Version: 4.2.1.1
Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b

Version: 4.2.2.0.0+
Build ID: 50a2ddc88f7b9f48fecd562ca0f4bd76c79f0cc3
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-02-15_00:22:48

Version: 4.2.2.1
Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f

So introduced between 4.2.2.1 and 4.2.3.0.0+
May be with correction of bug 75053

-- 
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