Re: [libreoffice-users] Errors in LO 4.1 but not in LO 3.5

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
lodgemn@gmail.com


On 29 March 2014 00:44, Cley Faye <cleyfaye@gmail.com> wrote:

> 2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge <lodgemn@gmail.com>:
>
> 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: users+unsubscribe@global.libreoffice.org
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