Macros/Basic/Calc/Data

    From The Document Foundation Wiki

    Return to Index

    Data

    In this topic, many examples using current selection, caution, you sure the current select object is correct.

    Read

    Read like string for one cell (ScCellObj)

    selection = ThisComponent.getCurrentSelection()
    MsgBox selection.getString()

    Read like value for one cell (ScCellObj)

    selection = ThisComponent.getCurrentSelection()
    MsgBox selection.getValue()

    Write

    Write string for one cell (ScCellObj)

    selection = ThisComponent.getCurrentSelection()
    selection.String = "Ingrid Bergman"

    Write value for one cell (ScCellObj)

    selection = ThisComponent.getCurrentSelection()
    selection.Value = 100

    Delete

    Data series

    Search and replace

    Notes