https://bugs.freedesktop.org/show_bug.cgi?id=54774
--- Comment #4 from mariosv <[email protected]> 2012-09-14 00:23:11 UTC --- Created attachment 67127 --> https://bugs.freedesktop.org/attachment.cgi?id=67127 Test screenshot. Sorry Marcus, I think I'm missing something or sure I am in a mistake. As you can see CF seems to work well, if you change the selection in J6, just change the CF in H6, or in any other selectable cell only changes their CF result in their row, despite having defined formulas relative which each was defined relative to its own row. I think this is different from what you are talking about. Only pairs of cells "J8:J9" and "U8:U9" were created as array. As you can verify by selecting them and editing their CF. Which must be displayed in the window as a range, only true for the first array. As I remember the others CF were created one by one, but can not remember if any, were copied from another. In any case your working basis imply that the behavior of the CF formula copying from one cell to another is not the same as the formula of the corresponding cell even being equal both formulas, when they have relative addresses. I believe it is necessary that the formulas work consistently at any place where they can be used. People can not ask themselves at each step how the formula works. And in this case I think the formulas work as expected. In summary, it appears that the CF work properly but the window does not show the conditions that each cell actually has. If the window does not show or can not show the actual contents of the condition, IMHO better not show it. Sometimes less is more. Attached screenshot, with a small sample in a file from scratch. I hope it will be clear enough. Regards. And please try to understand my English.(In reply to comment #3) -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
