The resultSet object contains all of the information needed to get the data of the copied row. The idea is to copy a row and then run the macro to create the new row, for example by binding it to a hotkey of your choice. Msgbox("Clipboard does not have data of type. 'windows_formatname="Data source Table"') 'application/x-openoffice-dbaccess-table ' ".clipboard.SystemClipboard", ctx)ĭataFlavors = transferable.getTransferDataFlavors()ĭf.HumanPresentableName = "Data source Table" OClip = ctx.getServiceManager().createInstanceWithContext( from import DataFlavor, UnsupportedFlavorExceptionĬtx = XSCRIPTCONTEXT.getComponentContext() This macro code is in Python-UNO, but it could be adapted to LO Basic or Java. But since you explicitly do not want forms, here is one way that should work. What you want can be done in various ways with forms, for example with a table control. The table data view does not have a lot of features. Did they support this in later versions ? I was wondering if anyone knows of a way around this hole, preferably by doing something intuitive like ^c to copy and ^v to paste on an empty line at the bottom of the table. We don't want to use forms or click buttons, so I'm frowning on that one. But calling the macro wojuld have to be via clicking a button in a form. It's surprising because one would think this would be a pretty basic thing one would want to do/support. I've googled around and it looks like I'm not the first to hit this. In the table/spreadsheet style interface, I can't seem to copy a record in the table to the end of the table where I would then make changes (to avoid primary key violations). I read that LibreOffice Base is a good alternative and indeed, it appears to be in all but one respect. I'm evaluating a replacement for using the MS-Access front-end to a Postgres table backend, primarily because Microsoft seems to be itching to EOL Access. Running version 5.2.2.2 of LibreOffice on linux.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |