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

2017-01-08 Thread Andreas Säger
[Tutorial] Date-Time Conversion in StarBasic including a spreadsheet document and a Basic function which converts all types of dates, times, timestamps into any other type. Date-times can be represented by UNO structs, integers,

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

2017-01-07 Thread Andreas Säger
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

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

2017-01-07 Thread ptoye
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

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

2017-01-03 Thread ptoye
Hi Robert, What you say is of course all true. But it's not to do with database records (my original experiments were in fact on a spreadsheet), but the data as held in the dialog(ue). Your method (thanks again) of copying a UNO Date into the field works fine, as does changing the text. But