Search found 311 matches
- Thu Apr 18, 2024 9:25 am
- Forum: Writer
- Topic: Split large book file into 2 odt files
- Replies: 12
- Views: 1362
Re: Split large book file into 2 odt files
Other options: Don't split, but export to pdf accordingly. Assuming you have 5 pages of front matter like title/toc: 1-373 and then 1-5, 374- this will have continuing page-numbers. Use a master document wich imports part one and two. You may then even use 3 versions of the master file: complete and...
- Thu Apr 18, 2024 9:14 am
- Forum: Calc
- Topic: No windows button on taskbar - unable to freeze rows/columns
- Replies: 8
- Views: 515
Re: No windows button on taskbar - unable to freeze rows/columns
... But there is nowhere to "view" or click on a drop down menu from a "window" button. ITs simply not there, but the two rows of other functions are there. ... Please share a Screenshot of your screen. Maybe someone has an idea, what you are looking at - even, if we don't use a...
- Thu Apr 18, 2024 7:45 am
- Forum: Forms
- Topic: Calculations in Form
- Replies: 3
- Views: 217
Re: Calculations in Form
... Can this be done? If so how? ... If your values are not connected to the database there will be no "help" from the database. So create a button, wich you bind to a macro you have to write. This can access the fields on your form and calculate the sum and other things you like. At the ...
- Fri Apr 12, 2024 8:34 am
- Forum: Install, Setup and Troubleshooting
- Topic: [Solved] Critical database crash
- Replies: 4
- Views: 470
Re: [Solved] Critical database crash
..., 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...
- Wed Mar 20, 2024 9:50 am
- Forum: Macros and UNO API
- Topic: Place image in Calc via macro
- Replies: 4
- Views: 864
Re: Place image in Calc via macro
... 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...
- Wed Mar 20, 2024 9:18 am
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 949
Re: SQL Query: Need "Time" + "MinuteLen" as "EndTime"
... 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...
- Wed Mar 20, 2024 9:11 am
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 949
Re: SQL Query: Need "Time" + "MinuteLen" as "EndTime"
.... 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...
- Wed Mar 20, 2024 9:05 am
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 949
Re: SQL Query: Need "Time" + "MinuteLen" as "EndTime"
..." 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 ...
- Sat Mar 16, 2024 8:45 pm
- Forum: Tables & Queries
- Topic: [Solved] Create report with "Comments" filled in
- Replies: 3
- Views: 901
Re: Create report with "Comments" filled in
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...
- Fri Mar 15, 2024 8:26 am
- Forum: Base
- Topic: Base underlying driver performance test
- Replies: 2
- Views: 622
Re: Base underlying driver performance test
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.
He can be easily found on the ask site of LibreOffice and is the author of the german guide for base.
- Fri Mar 15, 2024 8:14 am
- Forum: Writer
- Topic: Merge documents from your Thunderbird address book
- Replies: 12
- Views: 978
Re: Merge documents from your Thunderbird address book
.... 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...
- Wed Feb 28, 2024 8:41 am
- Forum: General Discussion
- Topic: When will LibreOffice catch up with OpenOffice updates?
- Replies: 11
- Views: 1725
Re: When Will LibreOffice Catch Up with OpenOffice Updates?
Quite true even using ODF 1.3, seems to need a lot of work:
https://cwiki.apache.org/confluence/plu ... /287607470
- Sun Feb 25, 2024 1:55 am
- Forum: Tutorials
- Topic: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
- Replies: 7
- Views: 12593
Re: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
..... 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...
- Sat Feb 24, 2024 7:20 pm
- Forum: Tutorials
- Topic: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
- Replies: 7
- Views: 12593
Re: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
... 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...
- Thu Feb 22, 2024 9:14 am
- Forum: General Discussion
- Topic: [Solved] Features which Excel can't save in ODS format
- Replies: 6
- Views: 1958
Re: [Solved] Which Excel features are not available in Calc's ODS format?
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
https://wiki.documentfoundation.org/Fea ... oft_Office
- Fri Feb 09, 2024 9:31 am
- Forum: Calc
- Topic: [Solved+Issue] Date format and date entry do not match
- Replies: 17
- Views: 2246
Re: Date format and date entry do not match
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...
- Fri Feb 09, 2024 8:57 am
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 7284
Re: SQLite in LibreOffice
... 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...
- Thu Feb 08, 2024 12:52 am
- Forum: Calc
- Topic: [Solved+Issue] Date format and date entry do not match
- Replies: 17
- Views: 2246
Re: Date Format
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, ...
- Thu Feb 08, 2024 12:43 am
- Forum: Calc
- Topic: [Dropped] Determine nearby locations using German postal codes
- Replies: 11
- Views: 1319
Re: Arrange a Nearby search via zip code
...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...
- Tue Feb 06, 2024 7:49 pm
- Forum: Calc
- Topic: [Dropped] Determine nearby locations using German postal codes
- Replies: 11
- Views: 1319
- Mon Feb 05, 2024 9:35 am
- Forum: Calc
- Topic: [Solved] Copy sheet feature differs from Excel's feature
- Replies: 3
- Views: 787
Re: Copy sheet corrupts references and conditional formats
...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...
- Thu Feb 01, 2024 9:17 am
- Forum: Base
- Topic: [Solved] OpenOffice database crashes every time I try to open it
- Replies: 10
- Views: 1389
Re: OpenOffice Database Crashes Every time I try to open it
... 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...
- Thu Feb 01, 2024 8:42 am
- Forum: LibreOffice
- Topic: [Solved] Lost My Templates after LO Update
- Replies: 11
- Views: 1793
Re: Lost My Templates after LO Update
... 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...
- Thu Jan 11, 2024 11:49 pm
- Forum: Reporting
- Topic: Easy method for showing text, not IDs in reports?
- Replies: 10
- Views: 1987
Re: Easy method for showing text, not IDs in reports?
... 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
- Mon Jan 08, 2024 8:39 am
- Forum: MS Windows
- Topic: [Solved] Contact the file owner...
- Replies: 5
- Views: 1720
Re: "Contact the file owner..."
... 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...
- Wed Jan 03, 2024 9:39 am
- Forum: External Programs
- Topic: [Solved] Connect to LO Portable UNO using BASIC
- Replies: 4
- Views: 2266
Re: Connecting to L.O. Portable UNO using BASIC language
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...
- Tue Jan 02, 2024 10:31 pm
- Forum: Macros and UNO API
- Topic: Conversion from Visual Basic for Applications (VBA)
- Replies: 16
- Views: 3960
Re: Conversion from Visual Basic for Applications (VBA)
... 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...
- Tue Jan 02, 2024 10:06 pm
- Forum: MS Windows
- Topic: [Solved] Run OpenOffice from USB drive
- Replies: 7
- Views: 2055
Re: Run OpenOffice from USB drive
... 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 ...
- Mon Jan 01, 2024 4:05 pm
- Forum: Calc
- Topic: [Solved] Unable to sum cell values
- Replies: 15
- Views: 1787
Re: Unable to sum cell values
- 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...
- Mon Jan 01, 2024 3:53 pm
- Forum: Calc
- Topic: [Solved] Unable to sum cell values
- Replies: 15
- Views: 1787
Re: Unable to sum cell values
... 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...