..., apart from the simple disappointment in an operation that had previously gone so well. ... Additional hints: Keep backups of your files!! In a case lake this, it would be easy to import your data in an older version of your database, so you could avoid re-creating your forms. . Keep in mind: T...

... However when trying this from a macro belonging to the database, nothing happens.... Check your code: You obtain "document", wich will point to your database, when started there. When you use this reference you can not expect it to be replaced by "address of some Calc sheet, plea...

... In a query, OO crashes if the query includes references to a linked table. These references work if there are no calculated fields, so I can either have the calculation or the reference fields, but not both. ... Show the code here, so one can check, because this is not a real restriction of Bas...

.... The SQL editor requires the formula to be without spaces: e.g. HOURS("Time")/24.00000. However, after closing the editor and re opening it, the spaces are added back and have to be removed before saving any edits. ... Never seen that, but I'm using LibreOffice. If you wish to keep yo...

..." The formula that works is: SELECT "Time", "Length", HOUR( "Time" ) /24.00000 + "Length" /1440.00000 AS "End" FROM "Lessons" Then I change the "End" column to a Time format. This works as long as the Length value is not ...

IMHO spreadsheets and csv-files are really "datasources" and read only from the database side. If you wish to modify them, you have to open the spreadsheet in Calc. For an report wich combines data from two tables use a "real" database and create your tables there. I recommend to...

I remember RobertG made some comments on the performance of the native MariaDB connector vs JDBC. I don't know, if he programmed a macro for this.

He can be easily found on the ask site of LibreOffice and is the author of the german guide for base.

.... Nevertheless in Writer you may also access to thunderbird address source to obtain the list. While there is an entry in menu, I guess it will not work since Thunderbird changed the format of the address-book. And the structure of the database is not easily accessed. I use an ODBC connection an...

robleyd wrote: ↑Wed Feb 28, 2024 3:32 am ...
It seems unlikely that OpenOffice is going to keep pace with LibreOffice.

Quite true even using ODF 1.3, seems to need a lot of work:
https://cwiki.apache.org/confluence/plu ... /287607470

..... it's only the JRE (Java Runtime Environment) version people need to worry about when choosing 32- vs 64-bit. (I assume you choose at install time and it's not automatic.) ... Not only. Years ago, I've chosen 32bit, because I needed to use an ODBC-driver, wich had 32bit 64 was "experiment...

... Also should mention the ".msi" installers are for both 32- and 64-bit, so everyone only needs one download (I think that wasn't specifically mentioned)... Is not mentioned because it is WRONG! You choose the OS on the Website as Win 32 or Win 64 and are lead to different files named x...

The following link compares Libre and MS-Office, but it is more feature compare, than a detailed analysis:
https://wiki.documentfoundation.org/Fea ... oft_Office

You explained precise, but you look at the wrong place, as your problem ... when entering 7 February 2024 as 7/2, the result is returned as 2 July 2024. ... is not the formatting ( DD MMM YYYY for 2 July 2024) but wrong recognition/interpretation of abbreviated input as M/D, while you would prefer D...

... create composite primary keys (on several columns) ... One warning (not with your driver, but from my tests with Sqlite3/ODBC): In Base my tables with composite keys were read-only. However I could write to the same database/table via sqlite-Studio, so I assumed this was no restriction of Sqlit...

You mix 2 features: Recognition depends on date-acceptance pattern, wich you could set in preferences (on Mac, Menu Tool>Options on other OS) - if you use LibreOffice .The recognized sequence is converted to a float. The integer part representa days since 30.12.1899, the decimals the part of a day, ...

...German post codes type 22307 ... As german codes are numeric, one can easily calculate a difference ABS(target-zip) and then use KKLEINSTE(), the german variant of SMALL(), to find the 10 "nearest" values. . But actually you can move in Berlin just 100m north and jump from 10xxx to 14x...

riva wrote: ↑Tue Feb 06, 2024 6:56 pm ...
.and idea how to arrange this!?

Why not sort the table by your zip codes?

Next question would be, if you have duplicates, and how to handle this...

...relative worksheet references (and I can't imagine why one would want to) ... Not my recommend design for data, but a common pattern I see is Calc/Excel-Files with one Sheet per Week/Month/Year etc. For example to count working hours/holidays ... Here the following sheet can easily pick data fro...

... I have created backups ... If you created this backups before the crash happened, try to open a new copy of your backup. If you created the backup after the crash, it may not help much, but you may rename a copy to .zip and check, if contents are available inside. If you used an embedded databa...

... Is there a way on future updates to prevent them removing my templates? I know Windows doesn’t have this feature but perhaps LO is smarter? ... Usually we assume the smart part is in front of the computer, while programs are quick.... The general precaution is to have backups. LibreOffice behav...

... unable to install LibreOffice on this computer atm --- I am using an older OSX .... For the MacOS 10.12 your signature shows, the latest possible Version is 7.3 wich can be found in the archives linked from the download page. https://wiki.documentfoundation.org/Documentation/System_Requirements

... However, I am the file owner. And I do not know how to give myself permission. I hope I'm doing this correctly. The "file owner" is the identity wich was registered on the other computer. As your computer has usually no "eyes" and is not asking for your passport, there is no...

From AutoIt description: It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks So the question is: Why should it not work? Have you tried? At this stage my only guess would be you identify the target window or task and there may be c...

... Please, why discourage conversion? One application alone contains 791 procedures with a total of 14,407 lines of VBA code. ... Actually size and numbers are not the big problem. The question is, what your code is doing, and how much it depends on the api of VBA. You may have 1000 lines of calcu...

... question: can you imagine that the Win machine is configured so strict (by our company-admins) that i am not able any more - to run a openoffice-portable version!`?!! Quite easy to imagine, because this is what happens, if you activate app and folder protection: Only allowed software and after ...

- This chat app; which shows 'Windows Vista' under my posts. This can easily be corrected by reading in the User Agent String instead of using a default string. But again this would take a little attention to detail which is clearly lacking. "A little attention to detail" would reveal &qu...

... For some reason the developers of OpenOffice chose to copy Excel's behavior, but the only reasonable solution would be to show an error message, so it would be clear that such a situation exists instead of showing possibly wrong results. There are a lot of spreadsheets out there, wich would not...

... I am able to save other file types (.txt, .xls) to OD, so there's something going on between OD and OO. Any suggestions....next steps to try? ... Suggestions: Obviously don't rely on OD for Backup... At least, try to copy a file fro OD to a local place and efit it there. If this works, you have...

... result is 0 Which obviously is not correct Why is this obvious, for anybody who only reads this thread? With neither file nor screenshot we have to trust the person who had to ask to find the icon to SUM. So I'd conclude you don't ask for help but pity or wishes to leave a rant. But you should ...

... HTML document which I wan't to import into an OO table. ... Usually I try copy/paste first, but nit from my html-editor or notepad, but from the browser. This should create a table in Writer. Second try would be to import to Calc first. When working in code I guess you don't want to replace <TD...