https://bugs.documentfoundation.org/show_bug.cgi?id=157089
Bug ID: 157089
Summary: A question about lack of what seems to me a very
essential feature for LibreOffice Calcs.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hello. Without exaggeration it was shocking to me to find that this feature is
not in Calcs. But because this feature seems to me essential i don't think it
was missed but rather there is reason not to support it and im curious about
the reason.
So in Google Sheets, the product i started my spreadsheet experience with, once
i wanted to include in my array all cells from columns A, B, C and all rows
beginning from 4 and down. Intuitively i tried "A4:C", and it worked. I did not
read about it anywhere, it just makes sense. Then i was, mildly put, surprised
to find this does not work in LibreOffice Calcs. I was like, there is no way.
Out of curiosity i tried this in other products, WPS Office, OnlyOffice, even
MS Office. It didn't work. Ok, at this point there has to be a reason, can
someone please explain why? btw i tried this a while ago so maybe it is now
supported by some of the products. Thank you.
Steps to Reproduce:
1.ranges like "a3:a", "a1:4"
Actual Results:
not working
Expected Results:
should be supported
Reproducible: Always
User Profile Reset: No
Additional Info:
No other information
--
You are receiving this mail because:
You are the assignee for the bug.