https://bugs.documentfoundation.org/show_bug.cgi?id=147398
John Murphy <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from John Murphy <[email protected]> --- Created attachment 178247 --> https://bugs.documentfoundation.org/attachment.cgi?id=178247&action=edit ODS of 2 sheets each displaying the same issue slightly differently. Sheet 1 is a multi column data range with an =Sum and an =CountA at the top. In this sheet the column Sum and Count appear to work correctly when additional data is added to the range covered. However when the totals of the Sum and Count of all the columns is used in a simple =Sum(*:*)/Sum(*:*) to give an overall average it works initially but will not readjust if additional data is addte to other cells covered in the range. Sheet 2 Is a simple two column data range set up as per Sheet 1. However I have noticed that when initially created, if data is added to the Left Hand column the overall average will not update, while data added to the RH column did update the O/A Avg. However having saved and closed the file, upon reopening it now does the same as Sheet 1 above. -- You are receiving this mail because: You are the assignee for the bug.
