Bug 41868 - Removing sheet, breaks formulae
Summary: Removing sheet, breaks formulae
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: Other Linux (All)
: high blocker
Assignee: Markus Mohrhard
URL:
Whiteboard: target:3.5
Keywords: regression
Depends on:
Blocks:
 
Reported: 2011-10-17 04:11 UTC by Cor Nouws
Modified: 2011-10-18 20:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2011-10-17 04:11:45 UTC 
- new spreadsheet
- simple data /formulae on 3rd sheet
  e.g.

   A    B    C
1  2    3    =A1+B1

- remove 2nd sheet
 > C1 shows #REF

Doing the same with data on sheet 2 and removing sheet 1
results in value  0  in C1


Found in Build ID: 4456143-f6a1fc5-e1a2fb3 (2011-10-13)
Comment 1 Markus Mohrhard 2011-10-17 06:18:04 UTC 
I think I caused that with my work in ScDocument::InsertTabs and the formula adjusting.

I'll have a look at it.
Comment 2 Markus Mohrhard 2011-10-18 15:36:52 UTC 
will be fixed with: http://cgit.freedesktop.org/libreoffice/core/commit/?id=308b7a287d0962ad593c9bac8e5b8b474cc36216

it was just a by one error

Thanks a lot for finding that annoying bug.
Comment 3 Cor Nouws 2011-10-18 20:42:45 UTC 
(In reply to comment #2)

> it was just a by one error
One small error can couse lot of inconveinience ;-)
 
> Thanks a lot for finding that annoying bug.
THanks for fixing!