Re: Older IBM patches for VBA (from Symphony?)

[Chen Peng]

Hi Pedro,
   I think we can tagged them [From Symphony], and  I will look at
these patches. Thanks.

2012/8/10 Pedro Giffuni 

> Hello;
>
> I just wanted to point out that there are 4 open issues by lihuibj @ ibm :
>
> https://issues.apache.org/ooo/show_bug.cgi?id=106278
>
> https://issues.apache.org/ooo/show_bug.cgi?id=108863
>
> https://issues.apache.org/ooo/show_bug.cgi?id=108874
>
> https://issues.apache.org/ooo/show_bug.cgi?id=110746
>
>
> And there also cws/lihuivba01
>
> Perhaps this should be tagged [From Symphony] too?
>
> cheers,
>
> Pedro.
>

Older IBM patches for VBA (from Symphony?)

[Pedro Giffuni]

Hello;

I just wanted to point out that there are 4 open issues by lihuibj @ ibm :

https://issues.apache.org/ooo/show_bug.cgi?id=106278

https://issues.apache.org/ooo/show_bug.cgi?id=108863

https://issues.apache.org/ooo/show_bug.cgi?id=108874

https://issues.apache.org/ooo/show_bug.cgi?id=110746


And there also cws/lihuivba01

Perhaps this should be tagged [From Symphony] too?

cheers,

Pedro.

Re: VBA

[Fernand Vanrie]

Stefan ,

i use this code to open and run a report, the filter handling  is included

Sub Main ( sReportName ,sFilter, sBlancoFilter as string)

on local error goto errh
context = createUnoService("com.sun.star.sdb.DatabaseContext")
oDataBase = context.getByName("mysql_native_PMG_reports")
oDBDoc = oDataBase.DatabaseDocument
aArguments() = oDBDoc.getArgs()
  For i=LBound(aArguments()) To UBound(aArguments() ) ' nodig om te 
beletten dat er gevraagd wordt de macro's uit te voeren

If ( aArguments(i).Name = "MacroExecutionMode" ) Then
  aArguments(i).Value = 
"com.sun.star.document.MacroExecMode.ALWAYS_EXECUTE"

End If
  Next i
  oDBDoc.attachResource( oDBDoc.URL, aArguments() )

   oReports = oDBDoc.getReportDocuments()
   dim Arguments(2) as New com.sun.star.beans.PropertyValue
Arguments(0).Name = "OpenMode"
Arguments(0).Value = "open" 'openDesign
Arguments(1).Name = "ActiveConnection"
Arguments(1).Value = oDatabase.getConnection("sos","hooghte")
Arguments(2).Name = "Hidden"
Arguments(2).Value = true
   toclose = oReports.loadComponentFromURL(sReportName 
,"_blank",0,Arguments()) ' open en sluiten om bepaalde componenten in 
geheugen te laden

   wait 1000
   toclose.close(true)
   oReport = oreports.getbyname(sReportName)

   oreportComponent = oreport.component

   oreportComponent.Filter = sFilter   ' xray oreportCom
   oReport.open
   ' filter weer op "niets te vinden zetten" anders blijft hij de 
settings van vorige run onthouden

   oreportComponent.filter = sBlancoFilter
   ' xray oreportCom
   ' print "stop"
exit sub
ErrH:
beep
MsgBox "Error " & err & ": " & error$ , 16

 end sub

hope it helps

Fernand

I want open a Report and change the filter dynamicly

I found the Code to Open
subdlg = 
getController().loadComponent(com.sun.star.sdb.application.DatabaseObject.REPORT,"Ergebnisse",FALSE)


but i dont know how i change the filter in the report

mfg

Stefan

Re: VBA

[drew]

On Wed, 2012-07-04 at 10:03 +0800, Chen Peng wrote:
> Hi Stefan,
>   Do you mean you want to open a report then change the filter in the
> report using StarBasic macro?
>   if it is, this is not a VBA issue.
>   You can use the Record Macro function in AOO to store the macro
> action, maybe you can get the answer.

Hi Peng,

The record macro function will be no help here, well not much anyway.

A question of import is - what kind of report is it, one made from the
Report Builder or one made from the embedded report wizard. 

But - you can actually do this without in more ways then using a script
(macro).

1 - Be sure to create dynamic reports.

2 - Base your report on a query.

3 - Change the select criteria in the query before running the report.

For very simple changes you will not need a macro at all - you simply
use parameters for the selection criteria (or parts of it) and the
runtime system will prompt the user for specific values to replace those
parameters with. This is automatic in other words, with a dynamic report
based on a query definition.

//drew


> 
> 
> 
> 2012/7/4 Stefan Lindel 
> 
> > I want open a Report and change the filter dynamicly
> >
> > I found the Code to Open
> > subdlg = getController().loadComponent(**com.sun.star.sdb.application.**
> > DatabaseObject.REPORT,"**Ergebnisse",FALSE)
> >
> > but i dont know how i change the filter in the report
> >
> > mfg
> >
> > Stefan
> >

Re: VBA

[Chen Peng]

Hi Stefan,
  Do you mean you want to open a report then change the filter in the
report using StarBasic macro?
  if it is, this is not a VBA issue.
  You can use the Record Macro function in AOO to store the macro
action, maybe you can get the answer.



2012/7/4 Stefan Lindel 

> I want open a Report and change the filter dynamicly
>
> I found the Code to Open
> subdlg = getController().loadComponent(**com.sun.star.sdb.application.**
> DatabaseObject.REPORT,"**Ergebnisse",FALSE)
>
> but i dont know how i change the filter in the report
>
> mfg
>
> Stefan
>

VBA

[Stefan Lindel]

I want open a Report and change the filter dynamicly

I found the Code to Open
subdlg = 
getController().loadComponent(com.sun.star.sdb.application.DatabaseObject.REPORT,"Ergebnisse",FALSE)


but i dont know how i change the filter in the report

mfg

Stefan

Re: Hi I hava a question about how to use VBA language on the Linux

[史周波]

Hi Alex，

thank you very much for your answer.

Regards
Robertzhou

于 2012年05月04日 21:26, Alexander Thurgood 写道:
> Le 04/05/12 10:26, 史周波 a écrit :
>
> Hi Robert,
>
>> Hi all,
>> I am researching how port the App for windows to Linux.
>> I meet a question about how to use the VBA language in AOO on the Linux?
> The short answer is : you can't.
> The long answer is that you will have to rewrite your VBA in
> StarOffice/OOo Basic, the included Basic programming language (and API)
> that comes with AOOo. Some of the structures and constructs are similar,
> but there are notable differences. There used to be a Basic Programmer's
> Guide available for download on the internet, but I don't know if it is
> still around now that the project has moved to Apache stewardship, i.e.
> I don't know if that material was included in the grant made by Oracle
> to the Apache foundation. Someone else here might be able to provide
> more insight.
>
> You can always take a look at the built- in help, it has a chapter or
> three on programming with OOoBasic.
>
>
> Alex
>
>

Re: A wiki about how to support a VBA API

[Andrew Douglas Pitonyak]

On 05/07/2012 10:08 PM, TJ Frazier wrote:

On 5/7/2012 20:02, Andrew Douglas Pitonyak wrote:


I owe you one, for the help your (on-line) book provided, when I was 
writing the temporary GUI for the new encoding feature:



I might never have found the Config Provider without the magic word in 
your example: "com.sun.star.comp." It seems that "comp." is not listed 
as a module under c.s.s., nor have I seen it mentioned in the Dev 
Guide. But it works.


And this is why I like open source and sharing my work oh, and when 
others share their work as well. So, thanks for the thanks and thanks 
for posting your work.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

Re: A wiki about how to support a VBA API

[Juergen Schmidt]

On Tuesday, 8. May 2012 at 04:08, TJ Frazier wrote:
> On 5/7/2012 20:02, Andrew Douglas Pitonyak wrote:
> > 
> > > If your changes show properly in the Preview mode, then they will be
> > > correctly saved when you Save. Sometimes the ATS delivers stale pages,
> > > so you might see the original page, unchanged, after the Save. The
> > > workaround is described in "Moving Day":
> > > 
> > > Taking a break also works; the stale pages expire and go away.
> > > Sorry for the problem, but it's quite beyond my poor powers to fix.
> > > 
> > 
> > Thanks Time permitting, I will make some more changes as needed. The
> > important thing, however, is that it is already understandable :-)
> > 
> 
> I owe you one, for the help your (on-line) book provided, when I was 
> writing the temporary GUI for the new encoding feature:
> 
> 
> I might never have found the Config Provider without the magic word in 
> your example: "com.sun.star.comp." It seems that "comp." is not listed 
> as a module under c.s.s., nor have I seen it mentioned in the Dev Guide. 
> But it works.
> 
> 

...comp.. is typically used for the implementation name of an implementation 
object implementing a service. It is possible to have multiple implementation 
for one and the same service. For many services we have only one impl but for 
others (e.g. typical service provider interfaces like a smart tag extension) we 
have or can have more. 
The implementation used the last registered impl for a service when it founds 
more than one. But it is possible to use the impl name as well to instantiate 
exactly the implementation you want. Well that is an internal detail only and 
is used sometimes. But it could theoretically be changed at any time.

Ok enough for now, when you interested to learn more about the details feel 
free to ask.

Juergen
> 
> -- 
> /tj/
> 
> 

Re: A wiki about how to support a VBA API

[TJ Frazier]

On 5/7/2012 20:02, Andrew Douglas Pitonyak wrote:



If your changes show properly in the Preview mode, then they will be
correctly saved when you Save. Sometimes the ATS delivers stale pages,
so you might see the original page, unchanged, after the Save. The
workaround is described in "Moving Day":

Taking a break also works; the stale pages expire and go away.
Sorry for the problem, but it's quite beyond my poor powers to fix.


Thanks Time permitting, I will make some more changes as needed. The
important thing, however, is that it is already understandable :-)

I owe you one, for the help your (on-line) book provided, when I was 
writing the temporary GUI for the new encoding feature:



I might never have found the Config Provider without the magic word in 
your example: "com.sun.star.comp." It seems that "comp." is not listed 
as a module under c.s.s., nor have I seen it mentioned in the Dev Guide. 
But it works.


--
/tj/

Re: A wiki about how to support a VBA API

[Andrew Douglas Pitonyak]

If your changes show properly in the Preview mode, then they will be 
correctly saved when you Save. Sometimes the ATS delivers stale pages, 
so you might see the original page, unchanged, after the Save. The 
workaround is described in "Moving Day":


Taking a break also works; the stale pages expire and go away.
Sorry for the problem, but it's quite beyond my poor powers to fix.

Thanks Time permitting, I will make some more changes as needed. The 
important thing, however, is that it is already understandable :-)


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

Re: A wiki about how to support a VBA API

[Peng Chen]

Hi,
Thank you all for your concern about this topic, maybe there are some
confusion about VBA support, thanks for Ma's clarification. I also update
the wiki with two reference, anything wrong or unclear, please update the
wiki directly, thanks.

2012/5/5 TJ Frazier 

> Hi, Andrew,
>
>
> On 5/5/2012 02:48, Andrew Douglas Pitonyak wrote:
>
>> On 05/02/2012 04:29 AM, Peng Chen wrote:
>>
>>> Hi All,
>>> I post a wiki about how to support a VBA API in OpenOffice,
>>> http://wiki.services.**openoffice.org/wiki/How_to_**
>>> support_a_VBA_API_in_**OpenOffice<http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice>
>>>
>>>
>>> Any feedback will be appreciated, thanks.
>>>
>>> Now that I know what the page describes (thanks everyone), I gave this a
>> pretty careful read. It seems to provide significant information, and I
>> learned much. There are some issues with respect to language usage, and
>> they are easily fixed; I started to fix the wording (after I figured out
>> that I can), but I stopped after the first paragraph for two reasons:
>>
>> 1. It is not clear to me that my changes really did save, and
>>
>
> If your changes show properly in the Preview mode, then they will be
> correctly saved when you Save. Sometimes the ATS delivers stale pages, so
> you might see the original page, unchanged, after the Save. The workaround
> is described in "Moving Day":
> <http://wiki.services.**openoffice.org/wiki/Moving_Day<http://wiki.services.openoffice.org/wiki/Moving_Day>
> **>
> Taking a break also works; the stale pages expire and go away.
> Sorry for the problem, but it's quite beyond my poor powers to fix.
>
> /tj/
>
>
>> 2. It is very late and I need some sleep before my little girls drag me
>> out of bed (not to mention the bigger girl that I married).
>>
>>
>
>

Re: A wiki about how to support a VBA API

[TJ Frazier]

Hi, Andrew,

On 5/5/2012 02:48, Andrew Douglas Pitonyak wrote:

On 05/02/2012 04:29 AM, Peng Chen wrote:

Hi All,
I post a wiki about how to support a VBA API in OpenOffice,
http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice


Any feedback will be appreciated, thanks.


Now that I know what the page describes (thanks everyone), I gave this a
pretty careful read. It seems to provide significant information, and I
learned much. There are some issues with respect to language usage, and
they are easily fixed; I started to fix the wording (after I figured out
that I can), but I stopped after the first paragraph for two reasons:

1. It is not clear to me that my changes really did save, and


If your changes show properly in the Preview mode, then they will be 
correctly saved when you Save. Sometimes the ATS delivers stale pages, 
so you might see the original page, unchanged, after the Save. The 
workaround is described in "Moving Day":

<http://wiki.services.openoffice.org/wiki/Moving_Day>
Taking a break also works; the stale pages expire and go away.
Sorry for the problem, but it's quite beyond my poor powers to fix.

/tj/


2. It is very late and I need some sleep before my little girls drag me
out of bed (not to mention the bigger girl that I married).

Re: A wiki about how to support a VBA API

[Yong Lin Ma]

On Sat, May 5, 2012 at 9:51 AM, Claudio Filho  wrote:
> Hi
>
> 2012/5/3 Rob Weir :
>> We have VBA support in Symphony.  It looks like the Symphony
>> developers are starting to add some technical documentation about the
>> features they added to Symphony, beyond what is in OOo.
>
> Rob, a curiousity: this support is a translation from VBA to OOo Basic
> or other language? Or other thing?

VBA support means support to VBA script in MS document, especially in
excel documents.
It is not translation from VBA to OOo Basic.  But Star Basic script
engine is reused and VBA script is mapping to UNO API instead of
Star Basic.

VBA support includes correctly open and execute VBA script in a MS
document, editing and save back the VBA script in a MS document.
Things are also different for MS document binary format and 2007/2010 format.

>
> And, i'm not sure if i understood, but this expertise in Symphony will
> migrate to AOO?
>

This is just a wiki to clarify the VBA support status in AOO3.4. Chen
Peng is an expertise on VBA and OO.o programability from Symphony
team. But he is not a AOO committer yet. If he want to do anything
significant on VBA for AOO, he needs post his idea/plan in AOO wiki
first.

> Best,
> Claudio

Re: A wiki about how to support a VBA API

[Andrew Douglas Pitonyak]

On 05/02/2012 04:29 AM, Peng Chen wrote:

Hi All,
  I post a wiki about how to support a VBA API in OpenOffice,
http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice

  Any feedback will be appreciated, thanks.

Now that I know what the page describes (thanks everyone), I gave this a 
pretty careful read. It seems to provide significant information, and I 
learned much. There are some issues with respect to language usage, and 
they are easily fixed; I started to fix the wording (after I figured out 
that I can), but I stopped after the first paragraph for two reasons:


1. It is not clear to me that my changes really did save, and

2. It is very late and I need some sleep before my little girls drag me 
out of bed (not to mention the bigger girl that I married).


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

Re: A wiki about how to support a VBA API

[Claudio Filho]

Hi

2012/5/3 Rob Weir :
> We have VBA support in Symphony.  It looks like the Symphony
> developers are starting to add some technical documentation about the
> features they added to Symphony, beyond what is in OOo.

Rob, a curiousity: this support is a translation from VBA to OOo Basic
or other language? Or other thing?

And, i'm not sure if i understood, but this expertise in Symphony will
migrate to AOO?

Best,
Claudio

Re: Hi I hava a question about how to use VBA language on the Linux

[Fernando Cassia]

On Fri, May 4, 2012 at 10:26 AM, Alexander Thurgood  wrote:

>
> You can always take a look at the built- in help, it has a chapter or
> three on programming with OOoBasic.


See also
Porting Excel/VBA to Calc/StarBasic
http://www.openoffice.org/documentation/HOW_TO/various_topics/VbaStarBasicXref.pdf

FC


-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell

Re: Hi I hava a question about how to use VBA language on the Linux

[Jürgen Schmidt]

On 5/4/12 3:26 PM, Alexander Thurgood wrote:
> Le 04/05/12 10:26, 史周波 a écrit :
> 
> Hi Robert,
> 
>> Hi all,
>> I am researching how port the App for windows to Linux.
>> I meet a question about how to use the VBA language in AOO on the Linux?
> 
> The short answer is : you can't.
> The long answer is that you will have to rewrite your VBA in
> StarOffice/OOo Basic, the included Basic programming language (and API)
> that comes with AOOo. Some of the structures and constructs are similar,
> but there are notable differences. There used to be a Basic Programmer's
> Guide available for download on the internet, but I don't know if it is
> still around now that the project has moved to Apache stewardship, i.e.
> I don't know if that material was included in the grant made by Oracle
> to the Apache foundation. Someone else here might be able to provide
> more insight.

we have the Basic guide in the wiki
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide

Juergen

> 
> You can always take a look at the built- in help, it has a chapter or
> three on programming with OOoBasic.
> 
> 
> Alex
> 
> 

Re: Hi I hava a question about how to use VBA language on the Linux

[Alexander Thurgood]

Le 04/05/12 10:26, 史周波 a écrit :

Hi Robert,

> Hi all,
> I am researching how port the App for windows to Linux.
> I meet a question about how to use the VBA language in AOO on the Linux?

The short answer is : you can't.
The long answer is that you will have to rewrite your VBA in
StarOffice/OOo Basic, the included Basic programming language (and API)
that comes with AOOo. Some of the structures and constructs are similar,
but there are notable differences. There used to be a Basic Programmer's
Guide available for download on the internet, but I don't know if it is
still around now that the project has moved to Apache stewardship, i.e.
I don't know if that material was included in the grant made by Oracle
to the Apache foundation. Someone else here might be able to provide
more insight.

You can always take a look at the built- in help, it has a chapter or
three on programming with OOoBasic.


Alex

Re: Hi I hava a question about how to use VBA language on the Linux

[Yong Lin Ma]

As far as I know, only VBA import is supported in AOO 3.4.  Since VBA
export is not supported, I don't think you can edit it by far.
All these should be platform independent.

There is wiki for VBA support in
http://wiki.services.openoffice.org/wiki/VBA_interoperability_in_OpenOffice



On Fri, May 4, 2012 at 6:49 PM, Fernando Cassia  wrote:
> On Fri, May 4, 2012 at 5:26 AM, 史周波  wrote:
>
>> I am researching how port the App for windows to Linux.
>> I meet a question about how to use the VBA language in AOO on the Linux?
>>
>
> OpenOffice Basic is a programming language similar to Microsoft Visual
> Basic for Applications (VBA) but based on StarOffice Basic.
>
> http://www.openoffice.org/api/basic/man/tutorial/tutorial.pdf
>
> FC
> --
> During times of Universal Deceit, telling the truth becomes a revolutionary
> act
> Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
> Revolucionario
> - George Orwell

Re: Hi I hava a question about how to use VBA language on the Linux

[史周波]

Hi,
yes, user hope to edit the VBA code..
于 2012年05月04日 17:27, Yong Lin Ma 写道:
> Do you mean open a .xls file which contains VBA in AOO3.4 on Linux?
>
> On Fri, May 4, 2012 at 4:26 PM, 史周波  wrote:
>> Hi all,
>> I am researching how port the App for windows to Linux.
>> I meet a question about how to use the VBA language in AOO on the Linux?
>>
>> Regards.
>>
>> robertzhou

Re: Hi I hava a question about how to use VBA language on the Linux

[Yong Lin Ma]

Do you mean open a .xls file which contains VBA in AOO3.4 on Linux?

On Fri, May 4, 2012 at 4:26 PM, 史周波  wrote:
> Hi all,
> I am researching how port the App for windows to Linux.
> I meet a question about how to use the VBA language in AOO on the Linux?
>
> Regards.
>
> robertzhou

Hi I hava a question about how to use VBA language on the Linux

[史周波]

Hi all,
I am researching how port the App for windows to Linux.
I meet a question about how to use the VBA language in AOO on the Linux?

Regards.

robertzhou

Re: A wiki about how to support a VBA API

[Andrew Douglas Pitonyak]

Excellent... I thought that might be the case, but I wanted to be sure 
before I wracked my brain more. On more than one occasion, I had looked 
to see how this was done (and failed to figure it out). I will take 
another look. Thanks!


On 05/03/2012 01:45 AM, ZuoJun Chen wrote:
Hi,  Andrew, I think the article is about VBA Macros interoperability 
http://wiki.services.openoffice.org/wiki/VBA . It explains the details 
if you want to hack OO for more excel macros support.  Currently there 
are still many VBA apis not supported in OO,  although the support 
framework has been implemented.
2012/5/3 Andrew Douglas Pitonyak <mailto:and...@pitonyak.org>>


On 05/02/2012 04:29 AM, Peng Chen wrote:

Hi All,
 I post a wiki about how to support a VBA API in OpenOffice,

http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice

 Any feedback will be appreciated, thanks.

I am almost embarrassed to say this, but after having read it, I
have no idea what the article is about. I think that the problem
is that I lack the proper vocabulary. For example, when I see
"VBA", I think "Visual Basic Applications", which is something
that MSO (Microsoft Office) supports, and not OOo (OpenOffice.org).

Is this an article related to the VBA compatibility mode stuff
that can be enabled using a specific Option from inside of StarBasic?

After I have a handle on exactly what is accomplished, then I will
read this again, since it looks like you are probably answering
some very specific questions that I have in areas that I do not
fully understand, but have searched for in the past.

Sorry for my lack of immediate understanding.

-- 
Andrew Pitonyak

My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

Re: A wiki about how to support a VBA API

[Rob Weir]

On Thu, May 3, 2012 at 1:17 AM, Dave Fisher  wrote:
>
> On May 2, 2012, at 9:45 PM, Andrew Douglas Pitonyak wrote:
>
>> On 05/02/2012 04:29 AM, Peng Chen wrote:
>>> Hi All,
>>>      I post a wiki about how to support a VBA API in OpenOffice,
>>> http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice
>>>
>>>      Any feedback will be appreciated, thanks.
>>>
>> I am almost embarrassed to say this, but after having read it, I have no 
>> idea what the article is about. I think that the problem is that I lack the 
>> proper vocabulary. For example, when I see "VBA", I think "Visual Basic 
>> Applications", which is something that MSO (Microsoft Office) supports, and 
>> not OOo (OpenOffice.org).
>>
>> Is this an article related to the VBA compatibility mode stuff that can be 
>> enabled using a specific Option from inside of StarBasic?
>>
>> After I have a handle on exactly what is accomplished, then I will read this 
>> again, since it looks like you are probably answering some very specific 
>> questions that I have in areas that I do not fully understand, but have 
>> searched for in the past.
>>
>> Sorry for my lack of immediate understanding.
>
> I'm not sure what I am reading either. My reference is using Apache POI and 
> its User Defined Function (UDF) capability to rewrite a VBA function in Java. 
> This allows me to have a different implementation of a VBA function that is 
> not in a Basic derivative. Whether that works or not depends on whether I can 
> accurately code the VBA in Java. This is not easy.
>
> I think that this API may be more about "UDF" support than VBA support.
>
> To me VBA support means that I can run my MS Office VBAs in the program 
> without any trouble.
>

We have VBA support in Symphony.  It looks like the Symphony
developers are starting to add some technical documentation about the
features they added to Symphony, beyond what is in OOo.

-Rob

> Still, UDF support is useful. VBA support is a panacea.
>
> What's it all about Peng?
>
> Regards,
> Dave
>
>>
>> --
>> Andrew Pitonyak
>> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
>> Info:  http://www.pitonyak.org/oo.php
>>
>

Re: A wiki about how to support a VBA API

[Peng Chen]

When users load MS document in OpenOffice with VBA, sometimes the macro
doesn't work, because we lack the support of VBA APIs in OO.
In this wiki, what's I want to express is that you can add the unsupported
API by yourself in OO's code if you meet such situation or you have
interesting to implement unsupported VBA APIs in OO.

2012/5/3 ZuoJun Chen 

> Hi,  Andrew, I think the article is about VBA Macros interoperability
> http://wiki.services.openoffice.org/wiki/VBA . It explains the details if
> you want to hack OO for more excel macros support.  Currently there are
> still many VBA apis not supported in OO,  although the support framework
> has been implemented.
> 2012/5/3 Andrew Douglas Pitonyak 
>
> > On 05/02/2012 04:29 AM, Peng Chen wrote:
> >
> >> Hi All,
> >>  I post a wiki about how to support a VBA API in OpenOffice,
> >> http://wiki.services.**
> openoffice.org/wiki/How_to_**support_a_VBA_API_in_
> >> **OpenOffice<
> http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice
> >
> >>
> >>  Any feedback will be appreciated, thanks.
> >>
> >>  I am almost embarrassed to say this, but after having read it, I have
> no
> > idea what the article is about. I think that the problem is that I lack
> the
> > proper vocabulary. For example, when I see "VBA", I think "Visual Basic
> > Applications", which is something that MSO (Microsoft Office) supports,
> and
> > not OOo (OpenOffice.org).
> >
> > Is this an article related to the VBA compatibility mode stuff that can
> be
> > enabled using a specific Option from inside of StarBasic?
> >
> > After I have a handle on exactly what is accomplished, then I will read
> > this again, since it looks like you are probably answering some very
> > specific questions that I have in areas that I do not fully understand,
> but
> > have searched for in the past.
> >
> > Sorry for my lack of immediate understanding.
> >
> > --
> > Andrew Pitonyak
> > My Macro Document: http://www.pitonyak.org/**AndrewMacro.odt<
> http://www.pitonyak.org/AndrewMacro.odt>
> > Info:  http://www.pitonyak.org/oo.php
> >
> >
>

Re: A wiki about how to support a VBA API

[ZuoJun Chen]

Hi,  Andrew, I think the article is about VBA Macros interoperability
http://wiki.services.openoffice.org/wiki/VBA . It explains the details if
you want to hack OO for more excel macros support.  Currently there are
still many VBA apis not supported in OO,  although the support framework
has been implemented.
2012/5/3 Andrew Douglas Pitonyak 

> On 05/02/2012 04:29 AM, Peng Chen wrote:
>
>> Hi All,
>>  I post a wiki about how to support a VBA API in OpenOffice,
>> http://wiki.services.**openoffice.org/wiki/How_to_**support_a_VBA_API_in_
>> **OpenOffice<http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice>
>>
>>  Any feedback will be appreciated, thanks.
>>
>>  I am almost embarrassed to say this, but after having read it, I have no
> idea what the article is about. I think that the problem is that I lack the
> proper vocabulary. For example, when I see "VBA", I think "Visual Basic
> Applications", which is something that MSO (Microsoft Office) supports, and
> not OOo (OpenOffice.org).
>
> Is this an article related to the VBA compatibility mode stuff that can be
> enabled using a specific Option from inside of StarBasic?
>
> After I have a handle on exactly what is accomplished, then I will read
> this again, since it looks like you are probably answering some very
> specific questions that I have in areas that I do not fully understand, but
> have searched for in the past.
>
> Sorry for my lack of immediate understanding.
>
> --
> Andrew Pitonyak
> My Macro Document: 
> http://www.pitonyak.org/**AndrewMacro.odt<http://www.pitonyak.org/AndrewMacro.odt>
> Info:  http://www.pitonyak.org/oo.php
>
>

Re: A wiki about how to support a VBA API

[Dave Fisher]

On May 2, 2012, at 9:45 PM, Andrew Douglas Pitonyak wrote:

> On 05/02/2012 04:29 AM, Peng Chen wrote:
>> Hi All,
>>  I post a wiki about how to support a VBA API in OpenOffice,
>> http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice
>> 
>>  Any feedback will be appreciated, thanks.
>> 
> I am almost embarrassed to say this, but after having read it, I have no idea 
> what the article is about. I think that the problem is that I lack the proper 
> vocabulary. For example, when I see "VBA", I think "Visual Basic 
> Applications", which is something that MSO (Microsoft Office) supports, and 
> not OOo (OpenOffice.org).
> 
> Is this an article related to the VBA compatibility mode stuff that can be 
> enabled using a specific Option from inside of StarBasic?
> 
> After I have a handle on exactly what is accomplished, then I will read this 
> again, since it looks like you are probably answering some very specific 
> questions that I have in areas that I do not fully understand, but have 
> searched for in the past.
> 
> Sorry for my lack of immediate understanding.

I'm not sure what I am reading either. My reference is using Apache POI and its 
User Defined Function (UDF) capability to rewrite a VBA function in Java. This 
allows me to have a different implementation of a VBA function that is not in a 
Basic derivative. Whether that works or not depends on whether I can accurately 
code the VBA in Java. This is not easy.

I think that this API may be more about "UDF" support than VBA support.

To me VBA support means that I can run my MS Office VBAs in the program without 
any trouble.

Still, UDF support is useful. VBA support is a panacea.

What's it all about Peng?

Regards,
Dave

> 
> -- 
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
> 

Re: A wiki about how to support a VBA API

[Andrew Douglas Pitonyak]

On 05/02/2012 04:29 AM, Peng Chen wrote:

Hi All,
  I post a wiki about how to support a VBA API in OpenOffice,
http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenOffice

  Any feedback will be appreciated, thanks.

I am almost embarrassed to say this, but after having read it, I have no 
idea what the article is about. I think that the problem is that I lack 
the proper vocabulary. For example, when I see "VBA", I think "Visual 
Basic Applications", which is something that MSO (Microsoft Office) 
supports, and not OOo (OpenOffice.org).


Is this an article related to the VBA compatibility mode stuff that can 
be enabled using a specific Option from inside of StarBasic?


After I have a handle on exactly what is accomplished, then I will read 
this again, since it looks like you are probably answering some very 
specific questions that I have in areas that I do not fully understand, 
but have searched for in the past.


Sorry for my lack of immediate understanding.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

How about the status of VBA?

[Peng Chen]

Hi all,
  I am interested in VBA development, but I just found a wiki
http://wiki.services.openoffice.org/wiki/VBA, and it is long time ago.
I can't find more documentations about this area, so I have some questions:
  1, Is there any update about VBA? How can I get them?
  2, Do we have a statistics about how many VBA APIs we supported in
Open Office?
  3, How about the Export of VBA in Open Office?

  Any feedback will be appreciated, thanks.