[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #9 from ady --- (In reply to Bigor from comment #0) > Expected Results: > selected a2:a5 Just click on any cell (so there is no "selected range"), then click on the upper-left "Name Box" and type-in "a2:a5" (without quotation marks). I am not sure about the consequences of applying any action to that selected a2:a5 range, considering that cell a4 is no longer just a4 alone. Now, while the selection itself is possible as I just mentioned, I agree with Aron in comment 5. I am not sure this should be considered a bug. FWIW, Calc already has some possibilities (on the individual cells that conform the merged area, a4:c4 in the example) that are not available in Excel (IIRC, but I cannot check it myself ATM). If you still need to perform actions on individual cells, them maybe they should not be really merged at all and the user should consider some alternative layout. Moreover, there are situations in which the current behavior is desired. Having said that, maybe the OP could provide some practical use-case where the request is more meaningful. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161204] UI - dashed outline for active cell border
https://bugs.documentfoundation.org/show_bug.cgi?id=161204 --- Comment #3 from ady --- (In reply to Robert Lacroix from comment #0) > Fix this problem once-and-for-all by changing cell border for active and > selected cells to a dashed line using the normal colour for dashes and the > complementary colour between the dashes. There are some merits to the proposal, but also some potential conflicts. The solid "focus" (or active) line might conflict with some borders and other lines used in Calc, but dashed lines are also in use under other conditions. In LO 24.2, there have been some changes that affect how the active cell is shown/marked. For instance, there is a new optional Column/Row Highlighting setting. Further changes in up-coming versions will also have an impact on this matter. For example, the active cell/range indicator (the same we are discussing in this enhancement request) is shown slightly outside the cell, instead of overlapping with the cell's limits / grid / border. So maybe this enhancement request includes an interesting suggestion, but perhaps the aforementioned changes reduce the need for it. Using a 2-colors "dashed" surrounding line to mark the active cell/range might be worth consideration anyway. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #8 from Aron Budea --- Let's see if my understanding if correct: - When you merge A4 to C4, there's no A4 cell anymore, only A4:C4 range, - A range is a rectangular area of cells, - When you select cells using Shift, or hold the left mouse button and drag, you select a range. This implies once the cells are merged in the example, there is no A2:A5 range anymore, and the smallest range including A2:A5 (and consequently A4:C4) is A2:C5. I'm not arguing there shouldn't be a way to select the least amount of cells+ranges that come with selection of cells, it just won't be a range anymore, and it should be a separate way apart from range selection. (In reply to Eyal Rozenberg from comment #7) > This seems like a bug to me, because it denies us the expressive potential > of the selection. We can choose to select a 3x5 region covering the merged > cell; and we can (try to) select 1x5 region, in one of 3 ways (left, middle, > right). Why should all four user behaviors result in the same thing, while > almost no mouse-down selection behavior can produce a selection of > a1,a2,a3,merged-a4-through-c4,a5 ? I see no argument in this comment why the selection you're looking for shouldn't be done in a different way, perhaps would be good to think about that first, instead of fragmenting the behavior by adding a compatibility flag. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161204] UI - dashed outline for active cell border
https://bugs.documentfoundation.org/show_bug.cgi?id=161204 --- Comment #2 from Robert Lacroix --- (In reply to m_a_riosv from comment #1) > Please attach a sample file, reduce the size as much as possible without > private information, and paste the information in Menu/Help/About > LibreOffice, there is a copy icon. Won't the colour of the border of the active cell depend on the user's platform, and not necessarily on the contents of a workbook? It's blue for me, the same colour as the row and column indicators. Version: 7.4.7.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 12; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Debian package version: 4:7.4.7-1+deb12u1 Calc: threaded -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161204] UI - dashed outline for active cell border
https://bugs.documentfoundation.org/show_bug.cgi?id=161204 m_a_riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m_a_riosv --- Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161204] UI - dashed outline for active cell border
https://bugs.documentfoundation.org/show_bug.cgi?id=161204 Stéphane Guillou (stragu) changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org Keywords||needsUXEval -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #7 from Eyal Rozenberg --- (In reply to Aron Budea from comment #5) This seems like a bug to me, because it denies us the expressive potential of the selection. We can choose to select a 3x5 region covering the merged cell; and we can (try to) select 1x5 region, in one of 3 ways (left, middle, right). Why should all four user behaviors result in the same thing, while almost no mouse-down selection behavior can produce a selection of a1,a2,a3,merged-a4-through-c4,a5 ? As for Excel compatibility... perhaps a toggle for our compatibility options in Tools > Options? -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160938] FORMCONTROLS: Add ability to Find and Replace field names
https://bugs.documentfoundation.org/show_bug.cgi?id=160938 --- Comment #5 from Eyal Rozenberg --- (In reply to Heiko Tietze from comment #4) > If you copy/paste a table with form controls the resulting names are amended > with a number like "top_left" becomes "top_left 1". What's wrong with it? How would you know which form has top_left and which has top_left_1, just by looking at the field names? -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161205] Font selection dialog doesn't persist choice of RTL-CTL + auto-chooses CJK
https://bugs.documentfoundation.org/show_bug.cgi?id=161205 Eyal Rozenberg changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org Version|Inherited From OOo |7.6.0.1 rc Blocks||129661, 83066, 113300 Keywords||needsUXEval --- Comment #1 from Eyal Rozenberg --- This is relevant probably since we introduced the last significant rework of the font selection dialog. Also, I meant Format | Character... (not Format | Font...). Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=83066 [Bug 83066] [META] CJK (Chinese, Japanese, Korean, and Vietnamese) language issues https://bugs.documentfoundation.org/show_bug.cgi?id=113300 [Bug 113300] [META] Language detection bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=129661 [Bug 129661] [META] Right-To-Left (RTL) user interface issues -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161203] When applying a style by double-clicking it in sidebar style list, keep list scroll position
https://bugs.documentfoundation.org/show_bug.cgi?id=161203 --- Comment #1 from Eyal Rozenberg --- Seen with: Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: en-IL (en_IL); UI: en-US -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161203] When applying a style by double-clicking it in sidebar style list, keep list scroll position
https://bugs.documentfoundation.org/show_bug.cgi?id=161203 Eyal Rozenberg changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org Blocks||103427 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||3292 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103427 [Bug 103427] [META] Styles and Formatting sidebar deck and floating window -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160657] Improve how Writer Navigator Headings are displayed when alphabetically sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=160657 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=16 ||0951 -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160874] Calc fails to suggest correction for formula cell without equal sign
https://bugs.documentfoundation.org/show_bug.cgi?id=160874 Heiko Tietze changed: What|Removed |Added Blocks||108253 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108253 [Bug 108253] [META] Calc cell formula bugs and enhancements -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160874] Calc fails to suggest correction for formula cell without equal sign
https://bugs.documentfoundation.org/show_bug.cgi?id=160874 Heiko Tietze changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160834] Unclear meaning of "Ignore pieces of length"
https://bugs.documentfoundation.org/show_bug.cgi?id=160834 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |ASSIGNED Assignee|libreoffice-b...@lists.free |heiko.tietze@documentfounda |desktop.org |tion.org Ever confirmed|0 |1 CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsDevAdvice, needsUXEval | --- Comment #5 from Heiko Tietze --- Presented the case in the ESC and got acceptance to remove the UI access. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 160896] Allow referencing Column & Row with Base 1 instead of 0 in Basic
https://bugs.documentfoundation.org/show_bug.cgi?id=160896 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX Blocks||127592 Status|UNCONFIRMED |RESOLVED --- Comment #5 from Heiko Tietze --- (In reply to NOYB from comment #0) > When counting things in that exist in the physical world the first item is > 1, not 0. But it does not in IT, see https://www.cs.utexas.edu/users/EWD/transcriptions/EWD08xx/EWD831.html (and many other articles) Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127592 [Bug 127592] [META] LibreOffice Basic macros incl."Option Compatible" modules -- You are receiving this mail because: You are on the CC list for the bug.
