[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 Eike Rathke changed: What|Removed |Added CC||7qia0t...@sneakemail.com --- Comment #14 from Eike Rathke --- *** Bug 48571 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 shunesbur...@yahoo.fr changed: What|Removed |Added Priority|high|highest --- Comment #13 from shunesbur...@yahoo.fr --- It would be good to fix it before the release of LO 5.0, we can't work properly with this bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 lee.e...@centrum.cz changed: What|Removed |Added Priority|medium |high Severity|enhancement |blocker --- Comment #12 from lee.e...@centrum.cz --- This bug has had status "new" since January 2012. We can consider this to be a bug (not enchancement) as the whole row/whole column reference should be supported according to the specification (paragraph 4.8 of the Open Document Format for Office Applications (OpenDocument) Version 1.2 ( https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB4QFjAA&url=https%3A%2F%2Fwww.oasis-open.org%2Fcommittees%2Fdownload.php%2F37765%2FOpenDocument-v1.2-part2-cd02-rev05-editor-revision.odt&ei=kZQrVeqPEZfdava-gIAK&usg=AFQjCNFep36B2Tlk0Vdz9tuCz8sp8QLd1Q&sig2=p4OnoQUkrwpI3AsoE9ePVg&bvm=bv.90491159,d.d2s ) "The syntax supports whole-row and whole-column references" So what do we need to do in order to: - change the status of this from NEW to ASSIGNED - change the importance from "enchancement" to "bug" ? Although there is some progress in recognition of "A:A" [.A] in formulas, it is still broken as insertion of a row in the range referenced by "A:A" [.A] results in a #REF! error because A:A is being internally stored as "A$1:A$1048576" [.A$1:$A1048576]. This effectively makes it impossible to maintain files containing these whole-row/whole-column references . Also the lack of functionality to be abile to click column headings when writing formulas and have the A:A [.A] inserted into the formula is a significant productivity barrier. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 m.a.riosv changed: What|Removed |Added CC||ov...@hotmail.com --- Comment #11 from m.a.riosv --- *** Bug 90573 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 aaker changed: What|Removed |Added CC||markus.weyerm...@gmx.net --- Comment #10 from aaker --- Unfortunately setting "formula syntax" to "Excel A1" is not really satisfying because internally column syntax "=SUM(A:A)" is referenced as "=SUM(A$1:A$1048576)". Inserting row(s) will lead to "#REF!" Value. This seems to be a basic bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 Alex Puntigam changed: What|Removed |Added Priority|high|medium Version|3.4.4 release |unspecified --- Comment #9 from Alex Puntigam --- I have just tested this out with the Excel A1 setting, and it works, which is great. However, I think it would still be extremely convenient if this worked under the default Calc A1 setting also. I use the A:A type column reference daily in all my spreadsheets, I find it incredibly useful to ensure people don't break the spreadsheets I build in the business environment (where people are incapable of NOT breaking stuff). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 raal changed: What|Removed |Added CC||goscrewyourself@sogetthis.c ||om --- Comment #8 from raal --- *** Bug 85417 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 --- Comment #7 from Сергій Загорія --- FYI: My father just refused to use Calc because it's extremely uncomfortable to select a column from another file. And I agree with him that it's extremely unobvoius in the current state. Is clicking on the title patented or somehow difficult to implement? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 kaese...@gmail.com changed: What|Removed |Added CC||kaese...@gmail.com --- Comment #6 from kaese...@gmail.com --- *** Bug 69843 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419
--- Comment #5 from lee.e...@centrum.cz ---
This seems to have been fixed in version 4.0.4.2 which is great! It works for
me when I have set the formula settings to "Excel A1"
(tools>options>formula>calc>formula>formula syntax).
Final wish is that when writing a formula, clicking with the mouse on the
column/row header would automatically write the column/row reference as it does
with single cells or ranges. To explain what I am after, I would like to be
able to type as follows:
"=VLOOKUP("
then click on cell A2 [formula bar now shows "=VLOOKUP(A2"] - this bit works
then type comma [formula bar now shows "=VLOOKUP(A2,"]
then click on the "G" for the header of column G and drag the mouse across to
column S and have the formula bar showing "=VLOOKUP(A2,G:S" - this bit doesn't
work (also in Excel it shows that 13 columns have been selected)
then type ",13,false)" to complete the formula as "=VLOOKUP(A2,G:S,13,false)"
This is about productivity using Calc, and becomes especially key where
referencing row/column ranges in an other sheet (where manually typing formulas
really slows you down). I would say "best practice" for workbook structure is
to have a "summary" sheet which VLOOKUPs or SUMIFs to a "detail" sheet, so this
is a really common task that I do many times a day in my work, so remains a
productivity barrier to my final full-time switch from Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 --- Comment #4 from bugquestcon...@online.de --- I was about filing a bug report when I found this one. It would be great if this bug fixed / enhancement implemented. BTW, the topic popped also up again in AskLibO. Thus it seems there is some kind of urgency. I am always grateful to our devs for their excellent work. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 Joel Madero changed: What|Removed |Added Status|UNCONFIRMED |NEW Priority|medium |high Ever Confirmed|0 |1 --- Comment #3 from Joel Madero 2012-07-03 10:53:08 PDT --- I'm unable to use SUM(A:A) either, I'm getting a #name error when I try it. If this is supposed to be supported (according to last comment Open Formula should support A:A) then this is a bug, not an enhancement request. The second part may very well be an enhancement (ie. multiple columns such as SUM(A:B:D:F). Because part is a bug, part is not, I'm going to leave as enhancement but set as HIGH priority. Thanks for helping us make LO better for everyone. -- 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419 --- Comment #2 from Markus Mohrhard 2012-01-08 19:19:05 PST --- See OpenFormula 5.8. This is a valid reference according to OpenFormula/ODF 1.2: B:B, 3:15, ... -- 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 44419] Allow column or row ranges in formulae
https://bugs.freedesktop.org/show_bug.cgi?id=44419
--- Comment #1 from Ed 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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
