Define an array with (2,0) and have this code in place. On the opposite side, we want to fill 1 single column with multiple rows.

My_range = ThisComponent.Sheets(0).getCellRangebyName('A3:C3')įill Rows Using Range Set a columns of cells using range Note that columns starts with 0 thus 0 to 2 is 3 columns that we want to fill. For this, we need to define an array with (0,2) where 0=row and 2=column.

We want to fill a row of cells using range. Now, get on with more complex range processing. Single cell fill using Range Set a row of cells using range If you run the above sets of code, the result would be: My_range = ThisComponent.Sheets(0).getCellRangebyName('A1') “A1” and put the defined array inside setDataArray() function. Thus define an array with one element and set its value. If you choose a range “A1” which is nothing but a single cell, then the correcponsing array should have only value. The argument of this function is a 2D array of same size of the range. Ranges can be set using a function setDataArray(array). We will start with a single cell fill-up using range, then go on to more complex range processing. If you need guidance on how to create a basic macro – click here. Add a function say rang_processing_demo() with below lines which would provide a hold of the spreadsheet before we start processing range. See below:Ĭreate a new macro in LibreOffice Calc. So a typical range – “A1:D5” refers all cells starting from (1,1) to (4,5). and all rows are numbers starting from 1 and so on. In Calc all columns are identified using letters “A”, “B”, “C”, …. Define a RangeĪ range is typically defined using “start_cell_address:stop_cell_address”. Part 1 would consists of writing in spreadsheet ranges. In this two part tutorial series I will talk about how to process “Range” in LibreOffice (LO) Calc spreadsheet application. Thus Range is sometimes preferred on top of the individual cell processing. One can access each cells using “row, column” way which is expensive in terms of processing time and complexity. In many automation tasks we need to access spreadsheet using range to reduce processing time.

Openoffice calc set print area