Description: I select a range of cells and then run a macro that places a border around the selected cells. The macro uses ThisComponent.getCurrentSelection(), and I've checked it to see that it does get ScCellRangeObj. The macro works as expected. However, if the first row of the selected range contains merged cells, ThisComponent.getCurrentSelection() only "gets" the first row of merged cells as ScCellObj. Note: If the any other row conatins merged cells, ThisComponent.getCurrentSelection() gets the complete range, ScCellRangeObj. Steps to Reproduce: 1.In a Calc document merge cells A1:E1 2.Select A1:E10 3.Run a simple macro containing: Dim oSel As Object oSel = ThisComponent.getCurrentSelection() MsgBox oSel.ImplementationName Actual Results: ScCellObj, i.e., A1:E1 Expected Results: ScCellRangeObj, i.e, A1:E10 Reproducible: Always User Profile Reset: No Additional Info: Unable to copy the information from menu Help - About LibreOffice.
Hallo Cannot reproduce with: Version: 7.0.4.2 Build ID: 00(Build:2) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Raspbian package version: 1:7.0.4-4+rpi1+deb11u3 Calc: threaded
It only displays: "ScCellRangeObj"
(In reply to Werner Tietz from comment #1) > Hallo > > Cannot reproduce with: > > Version: 7.0.4.2 > Build ID: 00(Build:2) > CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Raspbian package version: 1:7.0.4-4+rpi1+deb11u3 > Calc: threaded I'm not surprised. I forgot to mention, I did not have this happen with older versions.
@Julien Nabet: Thats the expected return!
(In reply to Werner Tietz from comment #4) > @Julien Nabet: Thats the expected return! Ok so then how to know if the range is A1:E1 or A1:E10 ?
If I highlight A1:E10 I expect ThisComponent.getCurrentSelection() to get me A1:E10, and not A1:E1.
I just upgraded to: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded BUG no longer exists!
Let's rather put this one as WFM since there's no specific fix spotted here.
This is *most likely* bug 147122; however, neither comment 0, nor comment 3 mentioned the version that experienced the problem (and Julien didn't mention it, too ;-P) The version in the meta shows "7.5.2.2", which is confusing, since the problem is expected to be fixed in 7.5.1 already. In the future, please do not omit the full version info in the problem description, even if you believe it's "redundant", being filled in the metadata. No it is not; the metadata may change with time; and comments allow to track the evolution and e.g. if original problem isn't hijacked by someone experiencing a similar, but different thing. Thank you.