Search found 31039 matches

by Villeroy
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.
by Villeroy
Thu Mar 21, 2024 8:21 pm
Forum: Calc
Topic: Hyperlink to today's date
Replies: 18
Views: 1134

Re: Hyperlink to today's date

t111375.ods
(21.62 KiB) Downloaded 11 times
by Villeroy
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.
by Villeroy
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...
by Villeroy
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...
by Villeroy
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...
by Villeroy
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:

Code: Select all

Sub Snippet
  
  oTextFields = ThisComponent.getTextFields()
  oObj2 = oTextFields.createEnumeration()
  
  oObj3 = oObj2.nextElement()
End Sub
[Tutorial] Introduction into object inspection with MRI
by Villeroy
Wed Mar 06, 2024 7:56 pm
Forum: Extensions
Topic: SQLite in LibreOffice / OpenOffice Base
Replies: 19
Views: 6540

Re: SQLite in LibreOffice / OpenOffice Base

psilocybe wrote: Wed Mar 06, 2024 4:38 am You have to install by hand...
Can I simply replace the old jars with the niew ones?
Why does the old version install cleanly but not the new one?
by Villeroy
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...
by Villeroy
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...
by Villeroy
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.
by Villeroy
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...
by Villeroy
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...
by Villeroy
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...
by Villeroy
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...
by Villeroy
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...
by Villeroy
Tue Feb 06, 2024 8:51 pm
Forum: Base
Topic: Updating records from a query again, again
Replies: 14
Views: 1801

Re: Updating records from a query again, again

open_mike wrote: Tue Feb 06, 2024 7:49 pm To recap, my goal is to have the answer field in Table1 populated with the results of value1 + value2
Makes no sense. Why do you store a calculation result? When you change value1 or value2, the stored sum will not update.
by Villeroy
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.
by Villeroy
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
by Villeroy
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

Code: Select all

SELECT * FROM "Direct_SQL_Query"
and use that for the form.
by Villeroy
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.
by Villeroy
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?

Hagar Delest wrote: Wed Jan 10, 2024 10:46 pm
Villeroy wrote: Wed Jan 10, 2024 10:43 pm111087.ods
Interesting but the column width has to be fixed and the factor adjusted to the full width.
OK. Try =REPT("|";A2/B2*CELL("width")*2.35)
2.35 is an approximation which depends on default font settings.
by Villeroy
Wed Jan 10, 2024 10:43 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?

111087.ods
(9.96 KiB) Downloaded 58 times
by Villeroy
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.
by Villeroy
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
by Villeroy
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.
by Villeroy
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...