Bug 41868

Summary:	Removing sheet, breaks formulae
Product:	LibreOffice	Reporter:	Cor Nouws <cno>
Component:	Calc	Assignee:	Markus Mohrhard <markus.mohrhard>
Status:	RESOLVED FIXED
Severity:	blocker	CC:	cno, markus.mohrhard
Priority:	high	Keywords:	regression
Version:	Master old -3.6
Hardware:	Other
OS:	Linux (All)
Whiteboard:	target:3.5
Crash report or crash signature:		Regression By:

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!