CellAddressConversion.UserInterfaceRepresentation (?)

eeigor · October 22, 2021, 9:23am

@marus_b wrote:
“The code shows sheet name and currently selected cell on all sheets, except for the first one, where it shows only the cell coordinates”.
Link: Issue with active sheet and active cell display

Indeed, it’s works as stated only on the first sheet:

Dim oConv As Object
oConv = ThisComponent.createInstance(com.sun.star.table.CellAddressConversion)
oConv.Address = oCell.CellAddress
Dim s$
s = oConv.UserInterfaceRepresentation  'bug: sheet name is not skipped if it is not the 1st sheet
s = Mid(s, InStr(s, ".") + 1)  'w/o sheet name

MsgBox s & Chr(10) & oConv.UserInterfaceRepresentation

Version: 7.2.1.2 / LibreOffice Community Build ID: 2c9f9a7aa7c967a1b7ec3448959cff87b32f6580 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded

sokol92 · October 22, 2021, 10:10am

The CellAddressConversion interface was marked as depreciated many years ago (A. Pitonyak also wrote about it), and the documentation does not mention it either. Fortunately, it has many substitutes (e.g. AbsoluteName).