LibreOffice Base for Android: Using Tables and Grid Controls

When working with LibreOffice Base on Android, you may encounter situations where you need to create tables that are not necessarily related to each other. One obvious solution is to create a separate table, which we'll refer to as 'Table2', specifically designed for the table control. This allows data to be used in the same document without being tied to each other.

In LibreOffice Base, forms can contain multiple independent forms by navigating to Form -> Form Navigator. However, when it comes to creating a grid control in a dialog or form, things get more complicated. You may try using code like `oGridModel.GridDataModel = oDataModel`, but this won't work as expected.

Another issue with table controls is that they cannot have data unless they are bound to a data source. Unlike list or combo boxes, unbound table controls do not allow you to populate them with data. Instead, you need to get the rowset of the form that contains the table control using the `getRowSet()` method. However, this can be misleading, as the table control itself does not have a rowset.

To overcome these limitations, we'll need to provide some background information and propose a solution. When creating new records, you may encounter situations where you cannot easily reverse your changes. To confirm new data, you'll need to use update methods, as shown in previous sections.

For new records, there is a special method that allows you to switch to a new row in the table, similar to how you would change rows in a traditional spreadsheet. This method can help simplify the process of creating and editing new data.

In summary, when working with LibreOffice Base on Android, it's essential to understand how tables and grid controls work together. By using separate tables for unrelated data and understanding the limitations of table controls, you can create more effective and efficient solutions for your needs.

Libreoffice base for android