Would be very helpful to be able to select multiple columns or rows when creating a formula. For Example =SUM(E) Or in a VLookup =VLOOKUP(B1,Sheet1.A:B), rather than having to select the individual cells. Cheers, Tim
Please be more specific with your description - provide a step-by-step explanation (http://wiki.documentfoundation.org/BugReport#What_to_include_in_bug_reports)
Created attachment 43192 [details] Example for column select
Attached above is an example file, check Sheet2 out for example. Step by Step: When creating a VLOOKUP, rather than selecting Sheet1.A1:B1048576, to select all of columns A & B, would be a lot easier to just click on the column headers, and have the formula as Sheet1.A:B. Start typing Formula, =VLOOKUP( Go to the sheet where you are doing the lookup Click and drag on the column headers to select which columns you would like to do the VLOOKUP Formula becomes Sheet1.A:B when selecting columns A & B. At the moment you cannot select a Column, you have to select the cells to be used in the formula.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
needinfo keyword redundant by needinfo status.
Confirmed as still not working in 3.5.0 Beta2 on OS X 10.6.8
There is a workaround for this matter: You can give names to ranges: -select column A -menu insert-names-define -give a name to the range (e.g. A) and use those names in formulas: -enter in cell =SUM( A ) to get the sum of all cell values in column A I hope this helps (as long as the requested enhancement is not realised).
*** Bug 93937 has been marked as a duplicate of this bug. ***
Submitted a patch for review at https://gerrit.libreoffice.org/#/c/20102/
*** Bug 92439 has been marked as a duplicate of this bug. ***
Added CC from Bug 92439
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e0b93ef5712264f78b8876993e718ccaad2c1216 tdf#34094 : Allow column and row selections while creating a formula It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Great news, I'd really love to see this already on 5.1 though. Using a lot of that feature.
(In reply to Commit Notification from comment #12) > Affected users are encouraged to test the fix and report feedback. Please see bug 96523. Thank you
(In reply to Commit Notification from comment #12) > Affected users are encouraged to test the fix and report feedback. Please see bug 96524. Thank you
(In reply to Commit Notification from comment #12) > Affected users are encouraged to test the fix and report feedback. Please see bug 96981. Thank you
Added bug 97084
(In reply to Commit Notification from comment #12) > Affected users are encouraged to test the fix and report feedback. Select Column {Ctrl+Space} (bug 92453); Row {Shift+Space} (bug 92452); Sheet {Ctrl+Shift+Space} (bug 96969) {using keyboard shortcuts} creating formula. Thank you