https://bugs.documentfoundation.org/show_bug.cgi?id=161592
--- Comment #28 from casa <[email protected]> --- Oh (sorry for 3 posts) after creating the B18 (duplicate) cell and seeing B17 would always need a hard-recalc but B18 got correct values (on first/autocalc)... I then deleted B17 (which moved B18 up to B17). That cell then started failing and required a hard-recalc to work so somehow proving the bug is likely involving either cell location or (as mentioned above) multiple cells in some sort of internal order/structure. The 'first' doens't calc correctly, but the second (and subsequent?) do. I actually hacked/fixed my spreadsheet by having BOTH B17 and B18 cells, but then drawing a strikethrough the value of B17 with essentially 'do not use' warning next to it while leaving it in place. -- You are receiving this mail because: You are the assignee for the bug.
