Hi Cley, I've now changed my code to accommodate the new date structure in LO v4.1 and it is working well.
I actually had two errors occurring simultaneously. The date one seemed the easiest to fix, so I did it first. The other error was - 'The contents of a combo box or list field could not be determined. Invalid value "2" for parameter "columnIndex" [90008-139] ' I have 5 combo boxes and one list field in my Form. The problem turned out to be in the bound field in the list. I have a single column in the associated query, and in LO v3.5 the bound field is 1, but in LO v4.1 it needs to be 0. I hunted high and low through my macro code to try to find where the problem was. Finally realised that it was in the Form specifications for the list field! Hopefully this might save others some time if they get the same error. Thanks for your help, Noel -- Noel Lodge [email protected] On 29 March 2014 00:44, Cley Faye <[email protected]> wrote: > > 2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge <[email protected]>: > > My macro is expecting a single value, but under v4.1 it has three values, >> so it's obvious why it is throwing the error. >> >> In both cases I have used the Java version 1.6.0_29, so I cannot work out >> why there is this difference in the way the OdateModel object is storing >> its Current Value. I could test for the Current Value's Type each time >> and >> extract the date with appropriate code. But this doesn't seem to be the >> right way to go. And there could be other variances between the LO >> versions that I haven't come across yet. >> >> I am running an H2 Database on Windows 7 64 bit. Can anyone spot what I >> might be doing wrong with my Java settings in LO v4.1? >> > > There was a change in date objects: > <https://wiki.documentfoundation.org/ReleaseNotes/4.1> (look for "Changes > to UNO APIs") > > This looks like the culprit in your case. The best course of action is > likely to update your code to follow these changes (either a quick fix to > "reproduce" the old value, or more long-term fix in the code around it). > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
