Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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 Lodge

On 29 March 2014 00:44, Cley Faye <> wrote:

2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge <>:

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
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:
<> (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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.