https://bugs.freedesktop.org/show_bug.cgi?id=37765
--- Comment #11 from Winfried Donkers <[email protected]> --- (In reply to pierre-yves samyn from comment #10) > Created attachment 109546 [details] > Screenshot: file opened with OOo 3.2.1 Hi Pierre-Yves, I may misunderstand you: Re your screenshot (taken from OOO 3.2.1): -result in cell A1 could apply to F5-H5 or E6-E8, both would produce 3. Adding something in I5 increases the result (in LO 4) -result in cel A5 aplies clearly to the absence of cell(s) with content to the right of cell E11 -result in cell A7 may be 0 because the name a (Insert-Names-Manage...) was not defined to be cells C22-C24. I don't know if named ranges were supported in OOo3.2. Apart from the result in cell A7, the results are identical in OOo3.2 and LO4, i.e. I see no regression. Possibly the reason behind the difference between numerical and textual cells is that in this example: COLA COLB COLC RONE 1 2 3 RTWO 4 5 6 COLA, COLB, RONE and RTWO are all recognized as labels, where COLA is recognized as a label for (1,4) and not for (COLB,COLC) and RONE is recognized as a label for (1,2,3) and not for RTWO. I don't know for certain and will check this in the code; at least numeric ranges have preference over textual ranges. Please tell me if I do misunderstand you and give me some time to check the code. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
