[libreoffice-users] Re: Issues with date fields in dialogues

Andreas, Thanks Andreas, that's very helpful. But it doesn't seem to cover the presentation and updating of date fields in dialogues (as opposed to cells in a spreadsheet), which was my concern. I've found some anomalies in this which I've reported as a minor bug. Best regards, Peter mailto:l

[libreoffice-users] Re: Conditional formatting and named ranges issues.

As far as I understand the matter, the LibreOffice devs have broken the c.f. feature. The c.f. conditions are formula expressions but they do not behave like other formula expressions when you move, copy, expand or shrink references. This is one of the things that still work (almost) properly with

[libreoffice-users] Re: Problems exporting and importing a dialogue

Importing/exporting Basic modules and dialogs is easy when you do NOT store everything in libraries named "Standard". Use the organizer to create a library with a distinct project name within a template, document or in global container "My Macros" Move dialogs and code modules into the library. Now

[libreoffice-users] Re: Calculating hours using spin button - simplified - answered

There is a control named "DateField" writing to a cell named "DateField" There is a control named "TimeField" writing to a cell named "TimeField" There is a control named "CurrencyField" writing to a cell named "CurrencyField" etc. Each control has a "Text Modified" event which calls the macro. The

[libreoffice-users] Re: Problems exporting and importing a dialogue

Andreas, Thanks again. Regina's comment answered my questions. I'm not sure why you say it's best to avoid the "Standard" library, though. I tend to store my dialogues and macros within the document, as they're usually specific to the document. After all, a dialogue for updating my wines databa

[libreoffice-users] Re: Calc Options > Libreoffice Calc > General > Expand references when new columns/rows are inserted

Calc is dying of featuritis. You might be interested in a macro of mine. [Calc, Python] Expand/shrink list ranges -- View this message in context: http://nabble.documentfoundation.org/Calc-Options-Libreoffice-Calc-General-Expan

Re: [libreoffice-users] Re: LibreOffice 5 .config directory?

On 01/06/2017 09:19 AM, jim wrote: On 01/06/2017 04:08 AM, Dave wrote: Original Message From: jim To: users@global.libreoffice.org Date: Thu, 5 Jan 2017 17:17:13 -0600 I did a clean install of Ubuntu 16.04 which uses LO vers 5.1.4.2. When I look at my .config file I see /.

[libreoffice-users] Re: Issues with date fields in dialogues

Hit the push button which is attached to the sheet. It opens a dialog with a date and time control. The two controls read and write the A1 cell. It works with all versions of Libre/OpenOffice and it works correctly with different NullDate settings. Function convertDateTime is designed to convert a