[Excel] getSelectedRange() error about office-js

[Zlatkovsky]

@kevishi , could you please take a look?

[sumurthy]

Hi @FelipeCostaGualberto, in this scenario, what would you expect the right behavior to be?

We don't yet support get selected table/chart/or other objects.

We did add getActiveCell API in the newer release (still in beta). https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/workbook.md#getactivecell

Would that help?

[FelipeCostaGualberto]

I need a macro to easily color the background of my selection, be it a Range or a TextBox. VBA demonstration:

Sub ColorSelection()
    Const FILL_COLOR = 6299648
    
    Select Case TypeName(Selection)
        Case "Range"
            Selection.Interior.Color = FILL_COLOR
        Case "TextBox"
            Selection.ShapeRange.Fill.ForeColor.RGB = FILL_COLOR
        Case Else
            MsgBox "Can't color this type of object: " & TypeName(Selection)
    End Select
End Sub

[JuaneloJuanelo]

Probably this is a by design issue. The name of the method is getSelectedRange

Now that we are implementing shapes, charts, etc we should consider adding a generic "getSelection()" and let the user infer whats contained. This is actively on design.

we understand the requirement, so closing the issue at this point.