Macros/Basic/Calc/Data

    From The Document Foundation Wiki
    Other languages:

    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