What Will I Learn?
In this video you will learn:
- How to create instance of com.sun.star.table.CellAddress
- How to create instance of com.sun.star.table.CellAddressConversion
To use the following properties and methods:
- getCellByPosition
- getCellAddress
- UserInterfaceRepresentation
- PersistentRepresentation
- Sheet
- Column
- Row
- getType
- AbsoluteName
- getString
- getValue
- getFormula
- setString
- setValue
- setFormula
Requirements
The tutorial tries to be self-contained but it is necessary:
- Intermediate knowledge of LibreOffice Calc
- Basic knowledge of programming
- This video is part of a series therefore the knowledge of the previous videos of the series is used.
Difficulty
- Intermediate
Description
In this video I will show you some of the methods that allow you to obtain and modify information from the "LibreOffice Calc" cells. For them it will be seen how to create structures that encompass the cells, how to obtain their position and address. How to modify its content and the different types of content that can be assigned, as well as each of its peculiarities.
Code used in the video: LINK
Video Tutorial
Thumbnail of the video.
Curriculum
Although the current video is in English, some of the previous videos are in Spanish. You can find the other videos of the series in the following links:
- Introducción a las macros en LibreOffice
- LibreOffice Macros. Variables
- LibreOffice Macros. Variables Variant, constantes, variables de usuario y bloque With.
- LibreOffice Macros. Arreglos parte 1
- LibreOffice Macros. Arreglos 2: Redimensionamientos.
- LibreOffice Macros. Arreglos 3: Errores comunes
- LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.
- LibreOffice Macros: Manipulation of spreadsheets
Posted on Utopian.io - Rewarding Open Source Contributors
Hey @zenkly I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
siento que leí algo en chino :( me voy al rincón T.T
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
\o/
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hahahahaha yo he sentido igual. es que en estos temas tengo que pedir primero de la ayuda divina porque si me distraigo un poco, me pierdo y no entiendo nada. pero es una muy buena información y muy buenos tips de herramientas para ayudarnos a comprender un poco mejor
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit