https://bugs.documentfoundation.org/show_bug.cgi?id=152091
--- Comment #11 from LeroyG <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #9) > Created attachment 183695 [details] > test file for formula = single-row or single-column cell range (LO 7.5 alpha) > > To show different cases of formulas that simply reference cell ranges. If there are no values at all in A2:A7 and in A14:F14, likewise you will get "#Value!". Following what I understood, A10 and H14 are an attempt of self-referencing formulas, but off the valid range of the formula. Try with "=A2:A7" (formula in C3) in C8. You gets "#Value!". -- You are receiving this mail because: You are the assignee for the bug.
