https://bugs.documentfoundation.org/show_bug.cgi?id=157336
--- Comment #2 from [email protected] --- One could argue that this is not a bug as there is a work around as one can use a nesting of functions i.e. MAX(arg1, arg2, MAX(arg3,arg4)) You mentioned that something like A2:A20000 would work but these cells are contiguous. In my application, the MAX (or AVERAGE) function was using a list of spreadsheet cells that are not adjacent to each other. I have to add specific cells to the list by using a mouse click + command key (on a Macintosh) on the cells of interest. The other point that is concerning about this is that it is misleading to the user. They enter a formula into a spreadsheet cell that calculates a value, but when the spreadsheet is closed and reopened, The value that is previously calculated is replaced with a value of #N/A in the cell that had the original function. If there is really an issue with the formula, it should be indicated to the user once they hit the return key to accept the formula. Rob -- You are receiving this mail because: You are the assignee for the bug.
