Bug 76548

Summary:	Spreadsheet Editing additional rows not being included in column totals
Product:	LibreOffice	Reporter:	Richard Slipper <richardslipper01>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	major	CC:	cno
Priority:	medium
Version:	4.2.1.1 release
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Richard Slipper 2014-03-24 10:33:47 UTC

I have had situations where data in an additional row inserted into a sheet is not being included in the sum formula for the range. This means that all formulas have to be altered manually.

In addition the additional rows through out the transfer of totals to another sheet.

This is becoming vexing as it means I cannot be sure of the accuracy of my data.
Business use.

Thank you.

Comment 1 Cor Nouws 2014-03-24 12:57:58 UTC

Hi Richard,

thanks for reporting. There is another report also for this one.

Cheers,
Cor

*** This bug has been marked as a duplicate of bug 76402 ***

Comment 2 Richard Slipper 2014-03-24 18:10:12 UTC

Apologies, for not recognising that the existing report was there. Bit techy speak for me. I've done user testing but never had to 'technalise' the information. :-)

Comment 3 Cor Nouws 2014-03-24 20:07:29 UTC

(In reply to comment #2)
> Apologies, for not recognising that the existing report was there. Bit techy
> speak for me. I've done user testing but never had to 'technalise' the
> information. :-)

thanks for your message Richard.
And no problem - it can happen anyone to report a duplicate issue. It's not always easy to recognise/find issues.