Bug 54311 - Calc EDITING: add auto-adjusting of formulas during deleting of row
Summary: Calc EDITING: add auto-adjusting of formulas during deleting of row
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2012-08-31 09:10 UTC by sasha.libreoffice
Modified: 2017-06-20 22:06 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
test case for demonstrating problem with numbering (9.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-31 09:10 UTC, sasha.libreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sasha.libreoffice 2012-08-31 09:10:54 UTC
Created attachment 66393 [details]
test case for demonstrating problem with numbering

Description of problem: I have added numbers of rows in one column in Calc using formula =1+A1 and drag&fill. It works. But when I deleting some row, formulas becomes #REF! beginning from deleted row and downwards.

How to reproduce: open attachment, select row 10 by clicking on row head on left edge of screen, right mouse click and select "Delete rows" from context menu

My proposal: add adjusting of formula reference in row below to deleted
Comment 1 A (Andy) 2012-12-26 20:27:22 UTC
reproducible with LO 3.6.4.3. (Win7 Home, 64bit)

I would agree, that if it is technical possible that LO would recognise this reference and e.g. adjust the formular to the row "above", because this is a relative and not an absolute reference.
Or maybe has somebody else another solution or comment, why this should better not be done?  Maybe there are some reasons against it?