https://bugs.freedesktop.org/show_bug.cgi?id=66717
--- Comment #4 from Mike Kaganski <[email protected]> --- (In reply to comment #3) You just haven't tried to understand what had been asked. I tried to express the question as detailed as possible, and included an example of desired behaviour in form of use case of a built-in function. Have you tried it to see what is it about? There's no problem if you need all the range. But the problem arises if you need just a single cell in the range, when the only thing you know is that the cell is in the same row (or in the same column) with the cell in which the formula resides. Suppose that there are ranges (columns) in the worksheet named "Length", "Diameter" and "Thickness" describing properties of some pipes. You need to create a column with the weights of the pipes. You write formula like "=8,7*Length*PI()*Thickness*(Diameter-Thickness)" and put it to all the cells in that column. Note that the arguments are _ranges_, not individual cells, but each resulting cell only uses _one_cell_ from each range, that is in the same row with that resulting cell. That is what I want to be able to do in User-defined functions, and something that seems to be impossible there now. -- 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
