https://bugs.freedesktop.org/show_bug.cgi?id=44419
--- Comment #1 from Ed <[email protected]> 2012-01-03 04:50:36 PST --- I have just come across the Calc feature where textual column and row labels are recognised automatically as names for column and row ranges respectively. Very nice feature, and this goes some way towards meeting my enhancement request: it does appear to behave as desired for single-row and single-column ranges. However, as far as I can see it does not allow you to handle ranges of multiple columns or rows. For example, sum('Col 1':'Col 3') does not work. Although cases where we want to add together the values in multiples columns or rows might be regarded as rare, handling references to multiple columns or rows is vital to the VLOOKUP and HLOOKUP functions. One way of meeting this enhancement request might be to enhance this feature, so that something like sum('Col 1':'Col 3') would work. This could turn out to be a greater complication, and I leave that decision to the designers! -- 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
