Search found 31039 matches
- Mon Mar 25, 2024 10:09 pm
- Forum: Macros and UNO API
- Topic: Need a macro to change percent in cell to value*100
- Replies: 4
- Views: 388
Re: Need a Macro to change Percent in Cell to Value*100
Find/Replace % with nothing and you get the decimal cell value.
- Thu Mar 21, 2024 8:21 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1134
- Tue Mar 19, 2024 10:30 pm
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 664
Re: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
Any operation with a Null value returns Null.
- Tue Mar 19, 2024 8:02 pm
- Forum: Tables & Queries
- Topic: [Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"
- Replies: 10
- Views: 664
Re: SQL Query: Need "Time" + "MinuteLen" as "EndTime"
Embedded HSQL does not have a DateAdd function like most other database engines have. As a work-around, you can calculate the day fractions and add them as you would do in a spreadsheet. A formatted control on a form or report can display this value as a time. SELECT *, Hour("Time")/24 + M...
- Tue Mar 19, 2024 12:56 pm
- Forum: Calc
- Topic: [Solved] Set chart Data Rages from cell value
- Replies: 2
- Views: 445
Re: Change range of cells automatically
Tools>Options>Calc>"Expand references when rows/columns are inserted " = ON Now you can insert new cells anywhere within or directly below the referenced range and all references in formulas, names, charts, conditional formatting etc. will expand automatically. With that setting turned off...
- Fri Mar 15, 2024 10:01 am
- Forum: Writer
- Topic: Merge documents from your Thunderbird address book
- Replies: 12
- Views: 789
Re: Merge documents from your Thunderbird address book
Hi guy, Didn't you notice that the user can merge emails simply by activating the Option menu? Is your extension by the way really necessary? Regards Nick In the LibreOffice options, you can specify your outgoing SMTP Server with log-in credentials. However, this feature is broken currently. You ca...
- Fri Mar 08, 2024 1:36 pm
- Forum: Macros and UNO API
- Topic: Get all Annotations/Comments/Notes
- Replies: 18
- Views: 1678
Re: Get all Annotations/Comments/Notes
Annotations are special types of TextFields. MRI records the following:
[Tutorial] Introduction into object inspection with MRI
Code: Select all
Sub Snippet
oTextFields = ThisComponent.getTextFields()
oObj2 = oTextFields.createEnumeration()
oObj3 = oObj2.nextElement()
End Sub
- Wed Mar 06, 2024 7:56 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 6540
- Tue Mar 05, 2024 6:41 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 6540
Re: SQLite in LibreOffice / OpenOffice Base
Trying to update from 1.1.5 to 1.2.2 on Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Error while installing extension jdbcDriver...
- Sun Mar 03, 2024 8:05 pm
- Forum: Calc
- Topic: [Solved] 03/04/24 changed to ¾ 24 (fraction)
- Replies: 5
- Views: 726
Re: Can't format cells for date
Hello Sir, I've seen for myself. Please find enclosed test file. Regards Nick Your column A uses the default locale, which is German(Germany) in my case and the dates are displayed like 31.12.99 here. If your default locale is English(UK), 31/12/99 might be the displayed date. Column B uses English...
- Sun Feb 25, 2024 11:50 pm
- Forum: Forms
- Topic: [Solved] Form control filter by date
- Replies: 22
- Views: 20264
Re: [Solved] Form control filter by date
How to filter by criteria in form controls without any macro: http://forum.openoffice.org/en/forum/do ... p?id=11663 (search this forum for "power filtering").
LibreOffice canceled the integer dates and times in favor of date and time structs.
LibreOffice canceled the integer dates and times in favor of date and time structs.
- Tue Feb 20, 2024 10:11 pm
- Forum: Calc
- Topic: [Solved] Report of product sales
- Replies: 6
- Views: 1065
Re: Formula to have list of how many of each product sold
The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table
- Tue Feb 20, 2024 4:53 pm
- Forum: Calc
- Topic: [Solved] LOOKUP in LO Calc
- Replies: 3
- Views: 630
Re: LOOKUP in LO Calc
LOOKUP in LO Calc It's the same LOOKUP function since the very first version of Visicalc in the year 1979 and successive spreadsheet applications such as Lotus 1-2-3, Excel and Calc. LOOKUP never did what most users expect it to do. In your specific example =CODE(D1)-43 returns a correct result wit...
- Mon Feb 19, 2024 9:05 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 6540
Re: SQLite in LibreOffice / OpenOffice Base
By the way, "OOo" in the name jdbcDriverOOo is misleading for two reasons. "OOo" refers to the product "OpenOffice.org" which was named after the website hosted by Sun Microsystems. - Since 2011 the product name is Apache OpenOffice (AOO). - Your package is incompatible...
- Sat Feb 17, 2024 6:34 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 6540
Re: SQLite in LibreOffice / OpenOffice Base
Somehow, the Thunderbird application grabs all access rights, no matter if it is started before or after LO Base. The Base frontend gets into some "frozen" state when TB is running. My problem is, that I can not open the database in read-only mode, so it does not interfere with TB in any w...
- Mon Feb 12, 2024 5:04 pm
- Forum: Extensions
- Topic: SQLite in LibreOffice / OpenOffice Base
- Replies: 19
- Views: 6540
Re: SQLite in LibreOffice / OpenOffice Base
Great job. This driver allows me to access the contacts database of the Thunderbird mail client without too many issues. Can you tell me if it is possible to establish a read-only connection? If I load the database document after the Thunderbird client, the database is locked (does not show any tabl...
- Thu Feb 08, 2024 9:31 pm
- Forum: Calc
- Topic: [Solved+Issue] Date format and date entry do not match
- Replies: 17
- Views: 2182
Re: Date format and date entry do not match
The locale is the relevant setting. You can set it for the entire office document, for cells and cell ranges, text fields, for anything numeric in templates for documents. How to enter a date in a spreadsheet cell (Calc, Excel and others): 1/ enters the first day of current month 1/2/ enters this ye...
- Tue Feb 06, 2024 8:51 pm
- Forum: Base
- Topic: Updating records from a query again, again
- Replies: 14
- Views: 1801
- Mon Jan 29, 2024 7:09 pm
- Forum: Macros and UNO API
- Topic: [Solved] [Basic] Replace Sheet with a new one
- Replies: 4
- Views: 1127
Re: [Basic] Replace Sheet with a new one
Use a document template.
- Thu Jan 25, 2024 6:23 pm
- Forum: Forms
- Topic: [Solved] Subform From Query Not Linking with Mainform Record
- Replies: 5
- Views: 1074
Re: Subform From Query Not Linking with Mainform Record
One-to-many and many-to-many relations in tables, queries and forms with subforms and lisboxes.: download/file.php?id=11250
- Thu Jan 25, 2024 8:31 am
- Forum: Forms
- Topic: [Solved] Subform From Query Not Linking with Mainform Record
- Replies: 5
- Views: 1074
Re: Subform From Query Not Linking with Mainform Record
Turn it from direct SQL to parsed SQL. If this is not possible, create another parsed query like
and use that for the form.
Code: Select all
SELECT * FROM "Direct_SQL_Query"
- Wed Jan 10, 2024 11:23 pm
- Forum: Tables & Queries
- Topic: [Solved] Seeking assistance to configure SQL query
- Replies: 2
- Views: 1958
Re: Seeking assistance to configure SQL query
Put dbl-quotes around the aliase names "a", "i", "j" etc.
- Wed Jan 10, 2024 10:49 pm
- Forum: Calc
- Topic: [Solved] Can a cell be turned into a progress bar?
- Replies: 14
- Views: 1906
Re: Can a cell be turned into a progress bar?
OK. Try =REPT("|";A2/B2*CELL("width")*2.35)Hagar Delest wrote: ↑Wed Jan 10, 2024 10:46 pmInteresting but the column width has to be fixed and the factor adjusted to the full width.
2.35 is an approximation which depends on default font settings.
- Wed Jan 10, 2024 10:43 pm
- Forum: Calc
- Topic: [Solved] Can a cell be turned into a progress bar?
- Replies: 14
- Views: 1906
- Mon Jan 08, 2024 2:25 am
- Forum: Mac OSX
- Topic: MacOS 14 message: Developer cannot be verified
- Replies: 13
- Views: 2300
- Mon Jan 08, 2024 12:14 am
- Forum: Calc
- Topic: [Solved] Move a column using Mac
- Replies: 11
- Views: 1486
Re: How do you move a column using Mac
A click on the column header selects a cell range.
Drag that highlighted cell range, not the column header.
Ctrl+Drop copies the range.
Alt+Drag inserts the moved range and deletes the cells of the former range.
Drag that highlighted cell range, not the column header.
Ctrl+Drop copies the range.
Alt+Drag inserts the moved range and deletes the cells of the former range.
- Wed Jan 03, 2024 8:29 pm
- Forum: Macros and UNO API
- Topic: Conversion from Visual Basic for Applications (VBA)
- Replies: 16
- Views: 3450
Re: Conversion from Visual Basic for Applications (VBA)
Run your program with a VB runtime without "A" and access Open/LibreOffice when needed: http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html
- Wed Jan 03, 2024 2:01 am
- Forum: Calc
- Topic: [Solved] Open Office Calc 7.6.4 Insert Shapes
- Replies: 3
- Views: 958
- Mon Jan 01, 2024 5:56 pm
- Forum: Calc
- Topic: [Solved] Import CSV into existing Calc sheet
- Replies: 23
- Views: 20920
Re: Import CSV into existing Calc sheet
Sorry, wrong document. I replaced the file with the actual version. Please, test carefully. I didn't.
- Mon Jan 01, 2024 5:50 pm
- Forum: Base
- Topic: [Solved] Populate Writer with data from Base
- Replies: 5
- Views: 1389
Re: Populating a Writer doc with data from Base
A database report is very much like a text document. When you run a report, the result is a text document. Having only one record per invoice with no invoice items, a serial letter template may be the preferred solution. Talking about invoices, there should be 2 recordsets at least: 1. The recordset...