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

Hi Johnny,

You might distinguish it with Basic function IsUnoStruct?

Kind regards

Johnny Rosenberg schrieb:
Here's my problem:

I have both Apache OpenOffice and LibreOffice installed and I use them
both. I have quite a few Calc files with Basic macros. Today I found my
first difference between the Basic API in LibreOffice vs. Apache OpenOffice:

Dim Dlg As Object, Ctl As Object

Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and here's
the difference:
In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is
represented as 20141019. I made two functions to convert to and from the
format I needed.

When running my macro in LibreOffice, the macro was interrupted by an error
message, of course. After some debugging I found that the LibreOffice
version of Ctl.setDate/Ctl.getDate works with a struct:
Type DateType
Year As Long
Month As Long
Day As Long
End Type

This is of course not a big deal, I can make the macro accept both formats,
but the macro need to know if LibreOffice or Apache OpenOffice is running
it. How can I do that? I have tried to find the answer myself, both using
xray and searching the web, but so far nothing.

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.