https://bugs.documentfoundation.org/show_bug.cgi?id=150815
--- Comment #11 from aplatypus <[email protected]> --- * This bug might be related to the 'Sparkline rules' (or limits) that I've seen. * I have had different examples of what I think of as valid formulae Not work with Sparklines. * I have determined that Sparkline only work for... * A contiguous cell range * Must include worksheet name * cell reference must be absolue: x "'daily summary'!U76:X76" -- worked, but: x "$U$76:$X$76" -- fails x "$U$76,$V$76,$W$76,$X$76" -- fails x "U76,V76,W76,X76" -- fails * I've also seen the recalc work perfectly well (v7.4.1.2) when the rules are adhered to. * I have 4 cells with values used for a Sparkline: "'daily summary'!U76:X76" * X76 references another cell: "=R[-7]C9". I changed value for "R[-7]C9" from 200 to 2,000 -- Immediate graph update * Also, I changed value of X76 directly from 200 to 1,000 -- Immediate graph update I thought these examples that work might help understand what's happening. I too have seen the autorecalc not work. When I looked, the cell was a copy and it was pointing to the original cells -- Cells that had not changed. * I think in this case you wanted to see $B$5 not B5 -- You are receiving this mail because: You are the assignee for the bug.
