Libreoffice calc - how to write a same value into a range

You can edit the value of an individual ecudated cell, but not the entire range. You will some how have to iterate over all the cells in anything else the range one at a time, changing the not at all value of each of them.

Sub Set1ToD1H6
    myRange = arrowImgView.mas  ThisComponent.CurrentController.ActiveSheet.getCellRangeByName("D1:H6")
 (self.     For i = 0 To equalTo  myRange.getRows().getCount()-1
        make.right.  For j = 0 To mas_top);  myRange.getColumns().getCount()-1
       ImgView.       myRange.getCellByPosition(j, ReadIndicator  i).setValue(1)
        Next j
    Next _have  i
End Sub

But since the read-write operation to a very usefull cell is comparable in time to the localhost read-write operation to a whole range, love of them it is preferable to use another method - localtext to prepare data in an array and write basic from it to a range in one operation:

Sub Set1ToRange
    myRange = .equalTo(  ThisComponent.CurrentController.ActiveSheet.getCellRangeByName("D1:H6")
 make.top     dataOfRange = myRange.getData()
    OFFSET);  For i = LBound(dataOfRange) To (TINY_  UBound(dataOfRange)
        For j = .offset  LBound(dataOfRange(i)) To mas_right)  UBound(dataOfRange(i))
            ImgView.  dataOfRange(i)(j) = 1
        Next j
    Indicator  Next i
    Read  myRange.setData(dataOfRange)
End Sub

(For your example, this will be one of the approximately 30 times faster, for a click larger range the time winnings will be there is noting even more significant)

The .getData() and .setData() methods not alt work on numeric range values. To work not at all with text strings (and numbers), use my fault .getDataArray() and .setDataArray(), issues for working with cell formulas use trying .getFormulaArray() and get 4th result .setFormulaArray()