![]() ![]() Each individual cell is defined by its content type. ![]() Note that first arguments of getCellByPosition is column and then row.Īfter we get the cell object my_cell is set, we have to access its contents. My_cell = ThisComponent.Sheets(i).getCellByPosition(col,row) Typical way of accessing a cell as below. Once we get a handle of a sheet using Sheets(subscript), we can access each individual cells using getCellByPosition method. To access them, we have to use subscript like Sheets(0), Sheets(1) so on. All the sheets is assigned to object my_sheets as an array. Once this is done, the Sheets collection is assigned to my_sheets object to access all the sheets of the workbook. Set my_doc using ThisComponent which refers to the current Calc workbook is open. Sheet1, Sheet2 and Sheet3 contains below data:įirst, we will declare 3 Objects to define the Calc workbook, collection of sheets and a cell. After read, we will show the formatted read contents in a message window. We will read a Calc spreadsheet with 3 sheets, one after another and read the contents of it. In this tutorial, we will demonstrate basic processing of worksheets, cells which is a foundation of many complex macros. Many times it is required to process those using Macro to automate various tasks. If not set the SAL_ENABLESKIA=1 environment variable prior to firing up this LibreOffice Git build.Spreadsheet applications like Calc consists of workbooks, worksheets and individual Cells. Via the LibreOffice "about" dialog will confirm if Skia and Vulkan are being used. It would be great if LibreOffice has a representative UI benchmark (there is this LibreOffice test profile albeit limited to document conversion/handling operations and not encompassing the UI).įor those wanting to try out the Vulkan-enabled LibreOffice, the latest development daily builds can be found here. ![]() ![]() I didn't try the CPU-based Skia support to know whether any changes "feel" like they are from the transition to Skia as opposed to the Vulkan-based drawing, but when this follow-on release to LibreOffice 6.4 approaches later on in 2020 I will be around with more testing. Unfortunately I am not aware of any LibreOffice UI-representative benchmarks, but just from my experience so far in testing the latest LO 6.5 development build. The Skia usage can be done either on a CPU or Vulkan if a Vulkan-supported GPU/driver is detected and needing Vulkan 1.1.Īt least from some basic testing, the LibreOffice Skia+Vulkan configuration does appear to be a bit faster when dealing with scrolling / presentation of large documents/spreadsheets. #Libreoffice Hardware Acceleration code#I tried out a new development build of LibreOffice and it's indeed working when activating the Skia code path. Skia is more modern and much better maintained than Cairo so that alone is a huge win, but the Vulkan support makes it even more interesting with not being aware of any other open or proprietary office programs with Vulkan drawing support. #Libreoffice Hardware Acceleration software#Currently the development builds are towards LibreOffice 6.5 (though given the big impact we wouldn't be surprised if it morphed into LibreOffice 7.0) and one of the features that landed at the end of November is the Cairo drawing being replaced by Skia and with that Vulkan-based rendering support for this free office suite.Īs written about at the end of November, in the LibreOffice 6.5/Git code is Skia drawing code to ultimately replace the Cairo code and with the use of Google's Skia graphics engine is not only CPU-based rasterization but also Vulkan GPU acceleration for the LibreOffice office software collection. While LibreOffice 6.4 isn't even coming out until the end of January, we are already stoked about the follow-on release to this open-source office suite. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |