Re: Error in macro.

2013-01-30 Thread Yessica Brinkmann
Hello,
Yes, my controls now have the same name as the one I use to call the macro.
Initially that was my mistake but I spent those mistakes. Now my problem is
that I describe in my previous mail, on the subject of the combo box and
customer_id and name.
There is a key value associated with my combo box.
On the Data tab of the Properties List, Contents List, I have the following
SQL statement: SELECT "name", "customer_id" FROM "customer"
My problem is that I do not know how to get the customer_id from the combo
box in the macro to do the update in the customers table, since using the
function getByName, I get the name of the client.
Regards,
Yessica

2013/1/31 Yessica Brinkmann 

> Hello,
> Thank you very much for your answer!
> There is a key value associated with my combo box.
> On the Data tab of the Properties List, Contents List, I have the
> following SQL statement: SELECT "name", "customer_id" FROM "customer"
> My problem is that I do not know how to get the customer_id from the combo
> box in the macro to do the update in the customers table, since using the
> function getByName, I get the name of the client.
> Regards,
> Yessica
>
> 2013/1/31 Andrew Douglas Pitonyak 
>
>>
>> Hopefully someone more in the know than I will answer, but, it is not
>> clear to me that I have sufficient information to answer your question.
>>
>> I assume that your combo box is NOT multi-valued (don't even know if that
>> is supported I have not looked at these in a very long time).
>>
>> is there something that ties your combo-box to some key value?
>>
>>
>> On 01/30/2013 07:38 PM, Yessica Brinkmann wrote:
>>
>>> Hello,
>>> Thank you very much for your answer! Now I understand what you're saying.
>>> I changed my macro, now looks like this:
>>> Sub ActualizarSaldoVentas (Evento)
>>> Dim oFrm As Object
>>> Dim oCliente As Object
>>> Dim oTotal As Object
>>> Dim oCon As Object
>>> Dim oStat As Object
>>> Dim sSQL As String
>>> Dim oRes As Object
>>> Dim sCliente as String
>>> 'Dim oIdPago As Object
>>> oFrm=Evento.Source.Model.**Parent
>>> If oFrm.hasByName("id_cliente") Then
>>>oCliente=oFrm.getByName("id_**cliente")
>>> Else
>>>Print "Cannot find id_cliente"
>>>Exit Sub
>>> End If
>>> sCliente=oCliente.**getCurrentValue()
>>> oTotal=oFrm.getByName("**fmttotal")
>>> Print sCliente
>>> End Sub
>>>
>>> They were wrong names form controls.
>>> The problem now is that when I write  Print sCliente, it prints the name
>>> of
>>> the client (because it is a combo box) and not the id of the customer,
>>> which is what I need to do my update. How I can do to get the client id?
>>> Can search by customer name obtained but this can be repeated, only the
>>> ID
>>> is unique.
>>> Much appreciate a response.
>>> regards,
>>> Yessica
>>>
>>> 2013/1/30 Andrew Douglas Pitonyak 
>>>
>>>  I think that AndrewBase.odt provides a routine that can find a control
 from its name It is not efficient, but it works.

 To get things by name, you must know where they live. You have named
 forms
 and controls, so, I think that you can use the Forms navigator (or
 something like that) to see the heirarchy.


 On 01/30/2013 10:24 AM, Yessica Brinkmann wrote:

  Hello,
>
> Thank you for the answers!
> When I replaced the lines containing "getByName" for something as
> indicated
> prints a message saying: "Can not find cod_cliente". I think this is
> because it is a field cod_cliente type drop-down list box and i should
> get
> the id of the customer through a cut chain or something, but I really
> do
> not know how to do this in OO Basic. Can you help a little with this
> please? I clarify that my formal education rather relied on the C and
> Java.
> regards,
> Yessica
>
>
> 2013/1/30 Andrew Douglas Pitonyak 
>
>   Which line gives the error?
>
>> If you change all lines containing "getByName" with something like
>>
>> If oFrm.hasByName("cod_cliente") Then
>> oCliente=oFrm.getByName("cod_**cliente")
>>
>>
>> Else
>> Print "Cannot find cod_cliente"
>> Exit Sub
>> End If
>>
>> What happens?
>>
>>
>> On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:
>>
>>   Hello,
>>
>>> I have a database of business management. I have a customer table
>>> that
>>> has
>>> a field saldo_actual.
>>> On the other hand, I have a sales form, in which I have a total
>>> field,
>>> and
>>> a button Calculate Total.
>>> I want to make a macro that when clicking on the Calculate Total
>>> button
>>> to
>>> add the total saldo_actual field.
>>> I assigned the macro to the button event: Mouse button released.
>>> Then I
>>> write my macro:
>>> Sub ActualizarSaldoVentas (Evento)
>>> Dim oFrm As Object
>>> Dim oCliente As Object
>>> Dim oTotal As Object
>>> Dim oCon As Object

Re: Error in macro.

2013-01-30 Thread Yessica Brinkmann
Hello,
Thank you very much for your answer!
There is a key value associated with my combo box.
On the Data tab of the Properties List, Contents List, I have the following
SQL statement: SELECT "name", "customer_id" FROM "customer"
My problem is that I do not know how to get the customer_id from the combo
box in the macro to do the update in the customers table, since using the
function getByName, I get the name of the client.
Regards,
Yessica

2013/1/31 Andrew Douglas Pitonyak 

>
> Hopefully someone more in the know than I will answer, but, it is not
> clear to me that I have sufficient information to answer your question.
>
> I assume that your combo box is NOT multi-valued (don't even know if that
> is supported I have not looked at these in a very long time).
>
> is there something that ties your combo-box to some key value?
>
>
> On 01/30/2013 07:38 PM, Yessica Brinkmann wrote:
>
>> Hello,
>> Thank you very much for your answer! Now I understand what you're saying.
>> I changed my macro, now looks like this:
>> Sub ActualizarSaldoVentas (Evento)
>> Dim oFrm As Object
>> Dim oCliente As Object
>> Dim oTotal As Object
>> Dim oCon As Object
>> Dim oStat As Object
>> Dim sSQL As String
>> Dim oRes As Object
>> Dim sCliente as String
>> 'Dim oIdPago As Object
>> oFrm=Evento.Source.Model.**Parent
>> If oFrm.hasByName("id_cliente") Then
>>oCliente=oFrm.getByName("id_**cliente")
>> Else
>>Print "Cannot find id_cliente"
>>Exit Sub
>> End If
>> sCliente=oCliente.**getCurrentValue()
>> oTotal=oFrm.getByName("**fmttotal")
>> Print sCliente
>> End Sub
>>
>> They were wrong names form controls.
>> The problem now is that when I write  Print sCliente, it prints the name
>> of
>> the client (because it is a combo box) and not the id of the customer,
>> which is what I need to do my update. How I can do to get the client id?
>> Can search by customer name obtained but this can be repeated, only the ID
>> is unique.
>> Much appreciate a response.
>> regards,
>> Yessica
>>
>> 2013/1/30 Andrew Douglas Pitonyak 
>>
>>  I think that AndrewBase.odt provides a routine that can find a control
>>> from its name It is not efficient, but it works.
>>>
>>> To get things by name, you must know where they live. You have named
>>> forms
>>> and controls, so, I think that you can use the Forms navigator (or
>>> something like that) to see the heirarchy.
>>>
>>>
>>> On 01/30/2013 10:24 AM, Yessica Brinkmann wrote:
>>>
>>>  Hello,

 Thank you for the answers!
 When I replaced the lines containing "getByName" for something as
 indicated
 prints a message saying: "Can not find cod_cliente". I think this is
 because it is a field cod_cliente type drop-down list box and i should
 get
 the id of the customer through a cut chain or something, but I really do
 not know how to do this in OO Basic. Can you help a little with this
 please? I clarify that my formal education rather relied on the C and
 Java.
 regards,
 Yessica


 2013/1/30 Andrew Douglas Pitonyak 

   Which line gives the error?

> If you change all lines containing "getByName" with something like
>
> If oFrm.hasByName("cod_cliente") Then
> oCliente=oFrm.getByName("cod_**cliente")
>
>
> Else
> Print "Cannot find cod_cliente"
> Exit Sub
> End If
>
> What happens?
>
>
> On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:
>
>   Hello,
>
>> I have a database of business management. I have a customer table that
>> has
>> a field saldo_actual.
>> On the other hand, I have a sales form, in which I have a total field,
>> and
>> a button Calculate Total.
>> I want to make a macro that when clicking on the Calculate Total
>> button
>> to
>> add the total saldo_actual field.
>> I assigned the macro to the button event: Mouse button released. Then
>> I
>> write my macro:
>> Sub ActualizarSaldoVentas (Evento)
>> Dim oFrm As Object
>> Dim oCliente As Object
>> Dim oTotal As Object
>> Dim oCon As Object
>> Dim oStat As Object
>> Dim sSQL As String
>> Dim oRes As Object
>> Dim sCliente as String
>> oFrm=Evento.Source.Model.**Parent
>> oCliente=oFrm.getByName("cod_**cliente")
>> sCliente=oCliente.**getCurrentValue()
>> oTotal=oFrm.getByName("total")
>> oCon=ThisDatabaseDocument.**CurrentController.**
>> ActiveConnection
>>
>>
>> oStat=oCon.CreateStatement
>> sSQL="UPDATE cliente SET cliente.saldo_actual =
>> cliente.saldo_saldo_actual
>> + "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
>> oCliente.getCurrentValue()
>> oRes=oStat.ExecuteQuery(sSQL)
>> End Sub
>> Clicking on the button Calculate total, I get the following error:
>> BASIC runtime error. There was an exception.
>> Type: com.sun.star.container.**NoSuchElementException Mes

Re: Error in macro.

2013-01-30 Thread Fernand Vanrie

 Yessica

nono , just check if the name of your controls are identical to what you 
call with "getbyname" (check uppercase, lower)


greetz

Fernand

Hello,
I think I can do this with string functions Left and Split but I do not
know which is the separator for the ComboBox, for separating the code from
the name.
Much appreciate an answer please.
regards,
Yessica

2013/1/30 Yessica Brinkmann 


Hello,
Thank you for the answers!
When I replaced the lines containing "getByName" for something as
indicated prints a message saying: "Can not find cod_cliente". I think this
is because it is a field cod_cliente type drop-down list box and i should
get the id of the customer through a cut chain or something, but I really
do not know how to do this in OO Basic. Can you help a little with this
please? I clarify that my formal education rather relied on the C and Java.
regards,
Yessica


2013/1/30 Andrew Douglas Pitonyak 


Which line gives the error?

If you change all lines containing "getByName" with something like

If oFrm.hasByName("cod_cliente") Then
   oCliente=oFrm.getByName("cod_**cliente")
Else
   Print "Cannot find cod_cliente"
   Exit Sub
End If

What happens?


On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:


Hello,
I have a database of business management. I have a customer table that
has
a field saldo_actual.
On the other hand, I have a sales form, in which I have a total field,
and
a button Calculate Total.
I want to make a macro that when clicking on the Calculate Total button
to
add the total saldo_actual field.
I assigned the macro to the button event: Mouse button released. Then I
write my macro:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
oFrm=Evento.Source.Model.**Parent
oCliente=oFrm.getByName("cod_**cliente")
sCliente=oCliente.**getCurrentValue()
oTotal=oFrm.getByName("total")
oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual =
cliente.saldo_saldo_actual
+ "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
oCliente.getCurrentValue()
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Clicking on the button Calculate total, I get the following error:
BASIC runtime error. There was an exception.
Type: com.sun.star.container.**NoSuchElementException Message:
I would appreciate very much a help please.
regards,
Yessica



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






Re: Ubuntu Build Instructions

2013-01-30 Thread jorge ivan poot diaz
Hello
Herbert Duerr,


Thank you for your help. I sorry for not write good my questions. The
number 3:
- Lack requirement to install?


Regards
Ivan Poot


2013/1/30 AlanSan 

> Le 01/29/2013 09:41 PM, jorge ivan poot diaz a écrit :
>
>  Hello
>> I have a problem: Ubuntu Build Instructions
>>
>> I did all the instructions but eventually tells me I have the following
>> code:
>>
>> sudo apt-get install python-dev ccache libgraphite-dev \
>> libwpd8-dev libxslt-dev libdb4.7-dev libhunspell libneon27-dev-dev-dev
>> libaltlinuxhyph
>>
>> Where generates me an error saying that the package libdb4.7-dev is not
>> available, but some other package refers to it. This may mean that the
>> package is missing, has been obsoleted, or is only available from another
>> source.
>>
>> 1. What should I do?
>> 2. What are the possible causes of this?
>> 3. Shortness requirements to install?
>> 4. I'm using Ubuntu 10.4
>> 5. I installed OpenJDK.
>>
>>  Hello Ivan, this error happens because canonical has been removed this
> library
> from their repositories, you can download the library from this page:
> https://launchpad.net/ubuntu/+**source/db4.7/4.7.25-10
>
> AlanSan.
>


Re: Are there still patchs from Synphony to merge?

2013-01-30 Thread Fan Zheng
Hi, Raphael:

Thank you so much!

Yes there are still items from Symphony that should be merged into AOO. But
there is one thing should be clarified anyway that, which part you want to
get in? Defect fixing? Solution reviewing? and the QA works?

2013/1/30 Raphael Bircher 

> Hi at all
>
> Are there still patchs (bugfixes) from Synphony to merge? I'm willing to
> help in this area. I have enought power to compile and test patchs here.
>
> Do we have same instructions?
>
> Greetings Raphael
>


Re: Re: Re: I want to modify the extension of the writer for test, How can I do?

2013-01-30 Thread Fan Zheng
Hi:

Now I understand what you want.

Personally, I do not like the way to change ext file name of ODF files you
want to try, but that is OK if you just want to dig deeper into the source
code.

First, you should get some knowledge about the whole data module framework
stuff. For example, the relationship between the SwDocShell,
Sd.DrawDocShell and SfxObjectShell.

Second, certain classes which involving into the document operation
executing especially the saving executing process, for example the
SfxBaseShell, SfxStoringHelper.

In general, the saving process of each application in AOO is abstracted
into a common one, with certain different implementation (e.g. the filter
part of each application) for identified saving execution. Which, maybe you
already realized, is following the design pattern 'Template Method' more or
less.

With the default setting of AOO, saving file process will use the OS
provided File Execute Dialog (response of SfxStoringHelper::GUIStoreModel),
with a series of parameters for customizing default provided
selecting/nam/path stuff, and of cause the optional filter setting
(corresponding to the ext file name) included. The available filter
properties list is provided by ModelData_Impl::GetPreselectedFilter_Impl.
And I am not sure now, that whether such list are actually defined in any
configuration file or not.

I remember that there are some introductions about said classes and design
inside the WIKI pages, which you can refer at first. And just like lots of
others open source project, AOO also need us to find out our owned sense by
the source code investigation.

Hope this could help you.

2013/1/30 2 

> Thank you for your reply.
> I guess my way is by the UI/dialog way inside AOO.
> What I want is that when I open a writer file and input something, click
> save button, there
> will be a dialog for save, I can choose "ABC" as the file type but not
> "ODT". certainly
> this "ABC" type file can be open by writer, e.g "file1.ABC".
> I don't kown how to implement these and which way is the best I can choose
>
> Yi
>
>
>
>
> At 2013-01-30 09:43:10,"Fan Zheng"  wrote:
> >Hi:
> >
> >We still need know more details.
> >
> >Which way you want to use on saving a customized extension name ODT file?
> >By the UI/dialog way inside AOO? By the UNO programming way with a running
> >AOO service? Or an via a special short cut in SW executive slot?
> >
> >In general, all of them are possible, but with huge differences on
> >implementation.
> >
> >2013/1/29 2 
> >
> >> Andrea,
> >> Sorry,thankyou for reminding me.I mean I want tomodify the writer
> >> file'sextension,for example writer's extension is "odt" , how can I
> replace
> >> it to "abc"。
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> At 2013-01-29 16:00:16,"Andrea Pescetti"  wrote:
> >> >laoyi419 wrote:
> >> >> I just wanna kown some details, which can help me to understand the
> >> >> project, I think it is the basic. Who can help me to understand in
> >> >> the shortest possible time?
> >> >
> >> >This mailing list is a good resource and several people may be able to
> >> >help you with development-related issues. But you need to be more
> >> >descriptive. For example, your previous question:
> >> >
> >> >> Hi, I have built the sw module for debug, I want to modify the
> >> >> extension of the writer for test, How can I do?
> >> >
> >> >is too concise for me to understand (what is the "extension" you need
> to
> >> >change?). If you make the effort to describe in more detail what you
> >> >need help with, you will get better help.
> >> >
> >> >Regards,
> >> >   Andrea.
> >>
>


Re: wiki still broken

2013-01-30 Thread Andrew Douglas Pitonyak


Copying the doc list, since some people have been trying to create 
accounts so that they can contribute to documentation. Without an 
account, you can't do much on a WIKI


Thanks, I was not aware that the site has been broken in this way for so 
long.


On 01/31/2013 12:35 AM, Alexandro Colorado wrote:

this has been going on for 3 weeks.

On 1/31/13, Andrew Douglas Pitonyak  wrote:

Anyone able to create accounts?

On 01/29/2013 05:40 PM, Andrew Douglas Pitonyak wrote:

Rakesh, I am sending this to the dev mailing list, perhaps they can
fix what ails the wiki.

It is not possible to create new accounts on mwiki. Is this a known
problem, and will it be fixed soon? This has been happening for at
least two days.

MWHttpRequest::factory: allow_url_fopen needs to be enabled for pure
PHP http requests to work. If possible, curl should be used instead.
See http://php.net/curl.

Backtrace:

#0 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(67):
MWHttpRequest::factory('http://challeng...', Array)
#1 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(88):
Http::request('GET', 'http://challeng...', Array)
#2 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Asirra.class.php(50):
Http::get('http://challeng...')
#3 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Captcha.php(514):
Asirra->passCaptcha()
#4
/x1/mwiki-1.20.2live/extensions/ConfirmEdit/ConfirmEditHooks.php(35):
SimpleCaptcha->confirmUserCreate(Object(User), '')
#5 [internal function]:
ConfirmEditHooks::confirmUserCreate(Object(User), '')
#6 /x1/mwiki-1.20.2live/includes/Hooks.php(216):
call_user_func_array('ConfirmEditHook...', Array)
#7 /x1/mwiki-1.20.2live/includes/GlobalFunctions.php(3823):
Hooks::run('AbortNewAccount', Array)
#8 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(397):
wfRunHooks('AbortNewAccount', Array)
#9 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(216):
LoginForm->addNewAccountInternal()
#10 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(161):
LoginForm->addNewAccount()
#11 /x1/mwiki-1.20.2live/includes/SpecialPage.php(611):
LoginForm->execute(NULL)
#12 /x1/mwiki-1.20.2live/includes/SpecialPageFactory.php(494):
SpecialPage->run(NULL)
#13 /x1/mwiki-1.20.2live/includes/Wiki.php(290):
SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#14 /x1/mwiki-1.20.2live/includes/Wiki.php(537):
MediaWiki->performRequest()
#15 /x1/mwiki-1.20.2live/includes/Wiki.php(447): MediaWiki->main()
#16 /x1/mwiki-1.20.2live/index.php(59): MediaWiki->run()
#17 {main}




--
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: wiki still broken

2013-01-30 Thread Alexandro Colorado
this has been going on for 3 weeks.

On 1/31/13, Andrew Douglas Pitonyak  wrote:
>
> Anyone able to create accounts?
>
> On 01/29/2013 05:40 PM, Andrew Douglas Pitonyak wrote:
>>
>> Rakesh, I am sending this to the dev mailing list, perhaps they can
>> fix what ails the wiki.
>>
>> It is not possible to create new accounts on mwiki. Is this a known
>> problem, and will it be fixed soon? This has been happening for at
>> least two days.
>>
>> MWHttpRequest::factory: allow_url_fopen needs to be enabled for pure
>> PHP http requests to work. If possible, curl should be used instead.
>> See http://php.net/curl.
>>
>> Backtrace:
>>
>> #0 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(67):
>> MWHttpRequest::factory('http://challeng...', Array)
>> #1 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(88):
>> Http::request('GET', 'http://challeng...', Array)
>> #2 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Asirra.class.php(50):
>> Http::get('http://challeng...')
>> #3 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Captcha.php(514):
>> Asirra->passCaptcha()
>> #4
>> /x1/mwiki-1.20.2live/extensions/ConfirmEdit/ConfirmEditHooks.php(35):
>> SimpleCaptcha->confirmUserCreate(Object(User), '')
>> #5 [internal function]:
>> ConfirmEditHooks::confirmUserCreate(Object(User), '')
>> #6 /x1/mwiki-1.20.2live/includes/Hooks.php(216):
>> call_user_func_array('ConfirmEditHook...', Array)
>> #7 /x1/mwiki-1.20.2live/includes/GlobalFunctions.php(3823):
>> Hooks::run('AbortNewAccount', Array)
>> #8 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(397):
>> wfRunHooks('AbortNewAccount', Array)
>> #9 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(216):
>> LoginForm->addNewAccountInternal()
>> #10 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(161):
>> LoginForm->addNewAccount()
>> #11 /x1/mwiki-1.20.2live/includes/SpecialPage.php(611):
>> LoginForm->execute(NULL)
>> #12 /x1/mwiki-1.20.2live/includes/SpecialPageFactory.php(494):
>> SpecialPage->run(NULL)
>> #13 /x1/mwiki-1.20.2live/includes/Wiki.php(290):
>> SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
>> #14 /x1/mwiki-1.20.2live/includes/Wiki.php(537):
>> MediaWiki->performRequest()
>> #15 /x1/mwiki-1.20.2live/includes/Wiki.php(447): MediaWiki->main()
>> #16 /x1/mwiki-1.20.2live/index.php(59): MediaWiki->run()
>> #17 {main}
>>
>>
>>
>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
>
>


-- 
Alexandro Colorado
Apache OpenOffice Contributor
http://es.openoffice.org


Re: Error Building module hsqldb - Installation Source Code in AOO

2013-01-30 Thread Alan Eduardo Puc Pech
Hi team, I could help on how to disable UTF-8 to solve the problem? or as
change the string to Knuth-Morris-Pratt to fix it, I attached the file.


2013/1/29 Alan Eduardo Puc Pech 

> Hello! thanks for your replies, I'm sorry for not giving answers, I don't
> have  internet, the sunday last. Now, I just download patches of  HSQLDB of
> Subversion, but have some type of installation?
>
>
> 2013/1/29 Alexandro Colorado 
>
>> On Sun, Jan 27, 2013 at 1:59 AM, Alan Eduardo Puc Pech <
>> alan.pucp...@gmail.com> wrote:
>>
>> > Hi team! I'm AlanSan, i have a problem with the compilation of AOO, the
>> > error shows when the module starts the Building module hsqldb. I need
>> your
>> > help to solve this problem
>> >
>>
>> It would be useful if you can join the #dev.openoffice.org IRC channel so
>> you can get more dynamic support to your questions. So far one
>> recommendation via Pavel is to unset all the LANG variables.
>>
>>
>>
>> >
>> > This is the error:
>> >
>> > =
>> > Building module hsqldb
>> > =
>> >
>> > Entering /home/alan/ooo/main/hsqldb
>> >
>> > mkdir: cannot create directory `./unxlngi6.pro/misc/build/hsqldb/':
>> File
>> > exists
>> > Buildfile: /home/alan/ooo/main/hsqldb/
>> > unxlngi6.pro/misc/build/hsqldb/build/build.xml
>> >
>> > init:
>> >
>> > javaversion6:
>> >
>> > javaversion4:
>> >
>> > javaversion2:
>> >
>> > -prepare:
>> >
>> > codeswitcher:
>> > [javac] /home/alan/ooo/main/hsqldb/
>> > unxlngi6.pro/misc/build/hsqldb/build/build.xml:135: warning:
>> > 'includeantruntime' was not set, defaulting to build.sysclasspath=last;
>> set
>> > to false for repeatable builds
>> >
>> > switches:
>> >
>> > switchtojdk14:
>> >
>> > switchtojdk16:
>> >  [java] 
>> >
>> > store:
>> > [javac] /home/alan/ooo/main/hsqldb/
>> > unxlngi6.pro/misc/build/hsqldb/build/build.xml:291: warning:
>> > 'includeantruntime' was not set, defaulting to build.sysclasspath=last;
>> set
>> > to false for repeatable builds
>> >
>> > lib:
>> > [javac] /home/alan/ooo/main/hsqldb/
>> > unxlngi6.pro/misc/build/hsqldb/build/build.xml:302: warning:
>> > 'includeantruntime' was not set, defaulting to build.sysclasspath=last;
>> set
>> > to false for repeatable builds
>> > [javac] Compiling 46 source files to /home/alan/ooo/main/hsqldb/
>> > unxlngi6.pro/misc/build/hsqldb/classes
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac]^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac] ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac]  ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac] ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac]  ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:39
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Implements the Knuth???Morris???Pratt string search
>> > algorithm for searching
>> > [javac]   ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:69
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Note that the Boyer???Moore algorithm is generally
>> > considered to be the better
>> > [javac]   ^
>> > [javac] /home/alan/ooo/main/hsqldb/
>> >
>> >
>> unxlngi6.pro/misc/build/hsqldb/src/org/hsqldb/lib/KMPSearchAlgorithm.java:69
>> > :
>> > error: unmappable character for encoding ASCII
>> > [javac]  * Note that the Boyer???Moore

Re: Blog post update on OOo4kids and OOOLight (in French)

2013-01-30 Thread Alexandro Colorado
there are people from this group also involved in aoo
not sure what you mean by your email rob?
what exactly are you doing or meaning to do with other projects?

On 1/31/13, Sylvain DENIS  wrote:
> Yes. Me :-)
>
> I'm also Educoo's administrator ;)
>
> Sylvain
> Le 31 janv. 2013 00:41, "Rob Weir"  a écrit :
>
>>
>> http://blog.educoo.org/2013/01/30/nos-outils-semblent-plebiscites-mais-nous-avons-besoin-de-retours-dusages
>>
>> It looks like these projects are still attracting a nice base of
>> users.   But I feel bad that we never found a way to work more
>> effectively with these projects.  Is anyone in contact with Eric?
>>
>> -Rob
>>
>


-- 
Alexandro Colorado
Apache OpenOffice Contributor
http://es.openoffice.org


Re: Blog post update on OOo4kids and OOOLight (in French)

2013-01-30 Thread Sylvain DENIS
Yes. Me :-)

I'm also Educoo's administrator ;)

Sylvain
Le 31 janv. 2013 00:41, "Rob Weir"  a écrit :

>
> http://blog.educoo.org/2013/01/30/nos-outils-semblent-plebiscites-mais-nous-avons-besoin-de-retours-dusages
>
> It looks like these projects are still attracting a nice base of
> users.   But I feel bad that we never found a way to work more
> effectively with these projects.  Is anyone in contact with Eric?
>
> -Rob
>


wiki still broken

2013-01-30 Thread Andrew Douglas Pitonyak


Anyone able to create accounts?

On 01/29/2013 05:40 PM, Andrew Douglas Pitonyak wrote:


Rakesh, I am sending this to the dev mailing list, perhaps they can 
fix what ails the wiki.


It is not possible to create new accounts on mwiki. Is this a known 
problem, and will it be fixed soon? This has been happening for at 
least two days.


MWHttpRequest::factory: allow_url_fopen needs to be enabled for pure 
PHP http requests to work. If possible, curl should be used instead. 
See http://php.net/curl.


Backtrace:

#0 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(67): 
MWHttpRequest::factory('http://challeng...', Array)
#1 /x1/mwiki-1.20.2live/includes/HttpFunctions.php(88): 
Http::request('GET', 'http://challeng...', Array)
#2 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Asirra.class.php(50): 
Http::get('http://challeng...')
#3 /x1/mwiki-1.20.2live/extensions/ConfirmEdit/Captcha.php(514): 
Asirra->passCaptcha()
#4 
/x1/mwiki-1.20.2live/extensions/ConfirmEdit/ConfirmEditHooks.php(35): 
SimpleCaptcha->confirmUserCreate(Object(User), '')
#5 [internal function]: 
ConfirmEditHooks::confirmUserCreate(Object(User), '')
#6 /x1/mwiki-1.20.2live/includes/Hooks.php(216): 
call_user_func_array('ConfirmEditHook...', Array)
#7 /x1/mwiki-1.20.2live/includes/GlobalFunctions.php(3823): 
Hooks::run('AbortNewAccount', Array)
#8 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(397): 
wfRunHooks('AbortNewAccount', Array)
#9 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(216): 
LoginForm->addNewAccountInternal()
#10 /x1/mwiki-1.20.2live/includes/specials/SpecialUserlogin.php(161): 
LoginForm->addNewAccount()
#11 /x1/mwiki-1.20.2live/includes/SpecialPage.php(611): 
LoginForm->execute(NULL)
#12 /x1/mwiki-1.20.2live/includes/SpecialPageFactory.php(494): 
SpecialPage->run(NULL)
#13 /x1/mwiki-1.20.2live/includes/Wiki.php(290): 
SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#14 /x1/mwiki-1.20.2live/includes/Wiki.php(537): 
MediaWiki->performRequest()

#15 /x1/mwiki-1.20.2live/includes/Wiki.php(447): MediaWiki->main()
#16 /x1/mwiki-1.20.2live/index.php(59): MediaWiki->run()
#17 {main}





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



Re: Error in macro.

2013-01-30 Thread Andrew Douglas Pitonyak


Hopefully someone more in the know than I will answer, but, it is not 
clear to me that I have sufficient information to answer your question.


I assume that your combo box is NOT multi-valued (don't even know if 
that is supported I have not looked at these in a very long time).


is there something that ties your combo-box to some key value?

On 01/30/2013 07:38 PM, Yessica Brinkmann wrote:

Hello,
Thank you very much for your answer! Now I understand what you're saying.
I changed my macro, now looks like this:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
'Dim oIdPago As Object
oFrm=Evento.Source.Model.Parent
If oFrm.hasByName("id_cliente") Then
   oCliente=oFrm.getByName("id_cliente")
Else
   Print "Cannot find id_cliente"
   Exit Sub
End If
sCliente=oCliente.getCurrentValue()
oTotal=oFrm.getByName("fmttotal")
Print sCliente
End Sub

They were wrong names form controls.
The problem now is that when I write  Print sCliente, it prints the name of
the client (because it is a combo box) and not the id of the customer,
which is what I need to do my update. How I can do to get the client id?
Can search by customer name obtained but this can be repeated, only the ID
is unique.
Much appreciate a response.
regards,
Yessica

2013/1/30 Andrew Douglas Pitonyak 


I think that AndrewBase.odt provides a routine that can find a control
from its name It is not efficient, but it works.

To get things by name, you must know where they live. You have named forms
and controls, so, I think that you can use the Forms navigator (or
something like that) to see the heirarchy.


On 01/30/2013 10:24 AM, Yessica Brinkmann wrote:


Hello,

Thank you for the answers!
When I replaced the lines containing "getByName" for something as
indicated
prints a message saying: "Can not find cod_cliente". I think this is
because it is a field cod_cliente type drop-down list box and i should get
the id of the customer through a cut chain or something, but I really do
not know how to do this in OO Basic. Can you help a little with this
please? I clarify that my formal education rather relied on the C and
Java.
regards,
Yessica


2013/1/30 Andrew Douglas Pitonyak 

  Which line gives the error?

If you change all lines containing "getByName" with something like

If oFrm.hasByName("cod_cliente") Then
oCliente=oFrm.getByName("cod_cliente")

Else
Print "Cannot find cod_cliente"
Exit Sub
End If

What happens?


On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:

  Hello,

I have a database of business management. I have a customer table that
has
a field saldo_actual.
On the other hand, I have a sales form, in which I have a total field,
and
a button Calculate Total.
I want to make a macro that when clicking on the Calculate Total button
to
add the total saldo_actual field.
I assigned the macro to the button event: Mouse button released. Then I
write my macro:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
oFrm=Evento.Source.Model.Parent
oCliente=oFrm.getByName("cod_cliente")
sCliente=oCliente.getCurrentValue()
oTotal=oFrm.getByName("total")
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection

oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual =
cliente.saldo_saldo_actual
+ "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
oCliente.getCurrentValue()
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Clicking on the button Calculate total, I get the following error:
BASIC runtime error. There was an exception.
Type: com.sun.star.container.NoSuchElementException Message:

I would appreciate very much a help please.
regards,
Yessica


  --

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




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



Re: Volunteer with Open Office documentation

2013-01-30 Thread RGB ES
Welcome on board, Jef!


2013/1/30 Jeff Scott 

> Hello!
>
> My name is Jeff Feinman, and I am interested in helping to write
> documentation for OpenOffice.org. I have a deep background in technical
> writing and journalism, and most recently served as a technical writer for
> Blackbaud, a software provider for nonprofit organizations. I am very
> skilled and experienced in writing user education content, have worked as
> part of agile scrum teams, and have recorded support videos. I take pride
> in my ability to create high quality content.
>

Great! Right now, discussion and drafting for a new user guide happens on
the doc mailing list

d...@openoffice.apache.org

you can subscribe to that list sending a mail to

doc-subscr...@openoffice.apache.org

and answering the mail you receive.

Regards
Ricardo



>
> As a technical writer with Blackbaud, I worked with authoring tools
> including MadCap Flare and Adobe FrameMaker, as well as Team Foundation
> Server for version control. In addition to improving my writing and
> information gathering abilities, I also advanced my video recording and
> social media skills with Blackbaud. I also served for three years as
> assistant editor of Software Development Times, an industry trade maga
> zine.
>
> I currently live in Charleston, South Carolina, which is a beautiful beach
> town. I grew up in the Long Island/New York City area. I am an avid
> Islanders and Giants fan, and have recently taken up disc golf, which is a
> blast.
>
> Attached is a copy of my resume if you're interested, I look forward to
> speaking with you more about how I can help out.
>
> Sincerely,
>
> Jeff Feinman
>
> --
> Jeff Scott
> jeffscottwo...@gmail.com
> 631-334-6836
>


Re: Error in macro.

2013-01-30 Thread Yessica Brinkmann
Hello,
Thank you very much for your answer! Now I understand what you're saying.
I changed my macro, now looks like this:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
'Dim oIdPago As Object
oFrm=Evento.Source.Model.Parent
If oFrm.hasByName("id_cliente") Then
  oCliente=oFrm.getByName("id_cliente")
Else
  Print "Cannot find id_cliente"
  Exit Sub
End If
sCliente=oCliente.getCurrentValue()
oTotal=oFrm.getByName("fmttotal")
Print sCliente
End Sub

They were wrong names form controls.
The problem now is that when I write  Print sCliente, it prints the name of
the client (because it is a combo box) and not the id of the customer,
which is what I need to do my update. How I can do to get the client id?
Can search by customer name obtained but this can be repeated, only the ID
is unique.
Much appreciate a response.
regards,
Yessica

2013/1/30 Andrew Douglas Pitonyak 

> I think that AndrewBase.odt provides a routine that can find a control
> from its name It is not efficient, but it works.
>
> To get things by name, you must know where they live. You have named forms
> and controls, so, I think that you can use the Forms navigator (or
> something like that) to see the heirarchy.
>
>
> On 01/30/2013 10:24 AM, Yessica Brinkmann wrote:
>
>> Hello,
>>
>> Thank you for the answers!
>> When I replaced the lines containing "getByName" for something as
>> indicated
>> prints a message saying: "Can not find cod_cliente". I think this is
>> because it is a field cod_cliente type drop-down list box and i should get
>> the id of the customer through a cut chain or something, but I really do
>> not know how to do this in OO Basic. Can you help a little with this
>> please? I clarify that my formal education rather relied on the C and
>> Java.
>> regards,
>> Yessica
>>
>>
>> 2013/1/30 Andrew Douglas Pitonyak 
>>
>>  Which line gives the error?
>>>
>>> If you change all lines containing "getByName" with something like
>>>
>>> If oFrm.hasByName("cod_cliente") Then
>>>oCliente=oFrm.getByName("cod_cliente")
>>>
>>> Else
>>>Print "Cannot find cod_cliente"
>>>Exit Sub
>>> End If
>>>
>>> What happens?
>>>
>>>
>>> On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:
>>>
>>>  Hello,
 I have a database of business management. I have a customer table that
 has
 a field saldo_actual.
 On the other hand, I have a sales form, in which I have a total field,
 and
 a button Calculate Total.
 I want to make a macro that when clicking on the Calculate Total button
 to
 add the total saldo_actual field.
 I assigned the macro to the button event: Mouse button released. Then I
 write my macro:
 Sub ActualizarSaldoVentas (Evento)
 Dim oFrm As Object
 Dim oCliente As Object
 Dim oTotal As Object
 Dim oCon As Object
 Dim oStat As Object
 Dim sSQL As String
 Dim oRes As Object
 Dim sCliente as String
 oFrm=Evento.Source.Model.Parent
 oCliente=oFrm.getByName("cod_cliente")
 sCliente=oCliente.getCurrentValue()
 oTotal=oFrm.getByName("total")
 oCon=ThisDatabaseDocument.CurrentController.ActiveConnection

 oStat=oCon.CreateStatement
 sSQL="UPDATE cliente SET cliente.saldo_actual =
 cliente.saldo_saldo_actual
 + "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
 oCliente.getCurrentValue()
 oRes=oStat.ExecuteQuery(sSQL)
 End Sub
 Clicking on the button Calculate total, I get the following error:
 BASIC runtime error. There was an exception.
 Type: com.sun.star.container.NoSuchElementException Message:

 I would appreciate very much a help please.
 regards,
 Yessica


  --
>>> 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: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Andrea Pescetti

TJ Frazier wrote:

On 1/30/2013 16:54, RGB ES wrote:

Good! The proposal was noticed by Phoronix too :)
http://www.phoronix.com/scan.php?page=news_item&px=MTI4ODI


It got more coverage than needed, probably. It is just a proposal at 
this stage, like dozens of other proposals.



Note that the article says that AOO 4.0 is scheduled for "April, 2012".
Oops.


Thanks, this is due to a typo I did in the wiki page, now fixed by 
Jaroslav Reznik, the so-called "Feature Wrangler", who manages the 
proposal lifecycle. But it probably propagated via sloppy copy-paste to 
articles before Jaroslav fixed it.


Note that Jaroslav opened a dedicated thread on the Fedora devel list
http://lists.fedoraproject.org/pipermail/devel/2013-January/thread.html
(search "OpenOffice") and that I already incorporated into
https://fedoraproject.org/wiki/Features/ApacheOpenOffice
some suggestions that came from there: using expressions more neutral 
than "leading free and open-source office suite" (I replaced it with 
"extremely popular", it was copied from our website and it is irrelevant 
to the application, since OpenOffice is well-known enough) and a 
historical remark by Caolan McNamara about the period when Fedora 
packaged ooo-build instead of the standard OpenOffice.


Regards,
  Andrea.


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Kay Schenk
On Wed, Jan 30, 2013 at 7:12 AM, Andrea Pescetti wrote:

> Right on the deadline to propose new features for Fedora 19 (it wasn't
> planned) I submitted Apache OpenOffice as a proposed new feature:
> https://fedoraproject.org/**wiki/Features/ApacheOpenOffice
>
> You can see this as a first step in getting back into the major Linux
> distributions. Timing aside, Fedora is a very good choice for a number of
> reasons.
>
> Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after all.
> The Fedora 19 release schedule, as an exception to the common Fedora
> conventions, will not be time-based but feature-based: features accepted by
> the Fedora Board will be considered before drafting the schedule. Anyway,
> optimally it would allow to package OpenOffice 4.0 (and there would be work
> to do on the OpenOffice and the Fedora side to get OpenOffice properly
> packaged).
>
> Regards,
>   Andrea.
>

Thanks for moving this forward, Andrea. I know we've had some
interest/questions from some of the Fedora folks.  Keeping my fingers
crossed on this one!

-- 

MzK

"A great deal of talent is lost to the world
  for want of a little courage."
 -- Sydney Smith


Re: CMS diff:

2013-01-30 Thread Kay Schenk
We should not  apply this one since it removes table borders for the whole
site which is not desirable in my opinion. If this is something that is
preferred for the "de" site only, please make a new tables style that
applies only to that area.

Thanks.

On Fri, Jan 25, 2013 at 12:01 AM, Piotr  wrote:

> Clone URL (Committers only):
>
> https://cms.apache.org/redirect?new=anonymous;action=diff;uri=http://ooo-site.apache.org/css%2Fooo.css
>
> Piotr
>
> Index: trunk/content/css/ooo.css
> ===
> --- trunk/content/css/ooo.css   (revision 1438272)
> +++ trunk/content/css/ooo.css   (working copy)
> @@ -197,7 +197,7 @@
>
>  td {
>vertical-align: top;
> -  border: 1px solid #a3afb6;
> +  /* border: 1px solid #a3afb6; Nimmt den Border aus dem Tabellen raus,
> die auf der Startseite zu sehen sind.*/
>padding: 0.4em 0.5em 0.4em 0.5em;
>font-size: 0.9em;
>  }
>
>


-- 

MzK

"A great deal of talent is lost to the world
  for want of a little courage."
 -- Sydney Smith


Re: problem in building AOO

2013-01-30 Thread AlanSan

Le 01/27/2013 10:41 AM, Hrishit Patel a écrit :

hi,

I've just join the project.

I started building my own AOO and stuck with following problem:

When I execute  "./bootstrap" it shows error "command not found".
I manually checked and found that there is no such file in "AOO/main/".
But there is some file with name "bootstrap.1".
And there is a file with path as "AOO/main/sal/test/bootstrap".

I am attaching both the files here, if anyone can look at it and guide 
me further.


thanks & cheers,
hrishit

Hi hrishit, you can write me, the steps you introduce than your terminal?


Blog post update on OOo4kids and OOOLight (in French)

2013-01-30 Thread Rob Weir
http://blog.educoo.org/2013/01/30/nos-outils-semblent-plebiscites-mais-nous-avons-besoin-de-retours-dusages

It looks like these projects are still attracting a nice base of
users.   But I feel bad that we never found a way to work more
effectively with these projects.  Is anyone in contact with Eric?

-Rob


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Rob Weir
On Wed, Jan 30, 2013 at 6:29 PM, David Gerard  wrote:
> On 30 January 2013 23:10, Rob Weir  wrote:
>
>> This is a great step, Andrea.  Apache OpenOffice has many Linux users.
>>  We see this in the download numbers.  But today the install
>> experience is, like many things in Linux, more complicated than the
>> average immigrant from Windows-land is accustomed to.  So making this
>> real simple will be key.
>
>
> FWIW, I found installing the download debs in Ubuntu completely 
> straightforward.
>

Congratulations, David!  It is always good to hear from a satisfied user.

-Rob

>
> - d.


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread David Gerard
On 30 January 2013 23:10, Rob Weir  wrote:

> This is a great step, Andrea.  Apache OpenOffice has many Linux users.
>  We see this in the download numbers.  But today the install
> experience is, like many things in Linux, more complicated than the
> average immigrant from Windows-land is accustomed to.  So making this
> real simple will be key.


FWIW, I found installing the download debs in Ubuntu completely straightforward.


- d.


Re: Error in macro.

2013-01-30 Thread Andrew Douglas Pitonyak
I think that AndrewBase.odt provides a routine that can find a control 
from its name It is not efficient, but it works.


To get things by name, you must know where they live. You have named 
forms and controls, so, I think that you can use the Forms navigator (or 
something like that) to see the heirarchy.


On 01/30/2013 10:24 AM, Yessica Brinkmann wrote:

Hello,
Thank you for the answers!
When I replaced the lines containing "getByName" for something as indicated
prints a message saying: "Can not find cod_cliente". I think this is
because it is a field cod_cliente type drop-down list box and i should get
the id of the customer through a cut chain or something, but I really do
not know how to do this in OO Basic. Can you help a little with this
please? I clarify that my formal education rather relied on the C and Java.
regards,
Yessica


2013/1/30 Andrew Douglas Pitonyak 


Which line gives the error?

If you change all lines containing "getByName" with something like

If oFrm.hasByName("cod_cliente") Then
   oCliente=oFrm.getByName("cod_**cliente")
Else
   Print "Cannot find cod_cliente"
   Exit Sub
End If

What happens?


On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:


Hello,
I have a database of business management. I have a customer table that has
a field saldo_actual.
On the other hand, I have a sales form, in which I have a total field, and
a button Calculate Total.
I want to make a macro that when clicking on the Calculate Total button to
add the total saldo_actual field.
I assigned the macro to the button event: Mouse button released. Then I
write my macro:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
oFrm=Evento.Source.Model.**Parent
oCliente=oFrm.getByName("cod_**cliente")
sCliente=oCliente.**getCurrentValue()
oTotal=oFrm.getByName("total")
oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual = cliente.saldo_saldo_actual
+ "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
oCliente.getCurrentValue()
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Clicking on the button Calculate total, I get the following error:
BASIC runtime error. There was an exception.
Type: com.sun.star.container.**NoSuchElementException Message:
I would appreciate very much a help please.
regards,
Yessica



--
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: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Rob Weir
On Wed, Jan 30, 2013 at 10:12 AM, Andrea Pescetti  wrote:
> Right on the deadline to propose new features for Fedora 19 (it wasn't
> planned) I submitted Apache OpenOffice as a proposed new feature:
> https://fedoraproject.org/wiki/Features/ApacheOpenOffice
>
> You can see this as a first step in getting back into the major Linux
> distributions. Timing aside, Fedora is a very good choice for a number of
> reasons.
>

This is a great step, Andrea.  Apache OpenOffice has many Linux users.
 We see this in the download numbers.  But today the install
experience is, like many things in Linux, more complicated than the
average immigrant from Windows-land is accustomed to.  So making this
real simple will be key.

Thanks again for your efforts!

-Rob


> Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after all.
> The Fedora 19 release schedule, as an exception to the common Fedora
> conventions, will not be time-based but feature-based: features accepted by
> the Fedora Board will be considered before drafting the schedule. Anyway,
> optimally it would allow to package OpenOffice 4.0 (and there would be work
> to do on the OpenOffice and the Fedora side to get OpenOffice properly
> packaged).
>
> Regards,
>   Andrea.


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread TJ Frazier

On 1/30/2013 16:54, RGB ES wrote:

2013/1/30 Andrea Pescetti 


Right on the deadline to propose new features for Fedora 19 (it wasn't
planned) I submitted Apache OpenOffice as a proposed new feature:
https://fedoraproject.org/**wiki/Features/ApacheOpenOffice

You can see this as a first step in getting back into the major Linux
distributions. Timing aside, Fedora is a very good choice for a number of
reasons.

Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after all.
The Fedora 19 release schedule, as an exception to the common Fedora
conventions, will not be time-based but feature-based: features accepted by
the Fedora Board will be considered before drafting the schedule. Anyway,
optimally it would allow to package OpenOffice 4.0 (and there would be work
to do on the OpenOffice and the Fedora side to get OpenOffice properly
packaged).

Regards,
   Andrea.




Good! The proposal was noticed by Phoronix too :)

http://www.phoronix.com/scan.php?page=news_item&px=MTI4ODI

Regards
Ricardo

Note that the article says that AOO 4.0 is scheduled for "April, 2012". 
Oops. /tj/




Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread RGB ES
2013/1/30 Andrea Pescetti 

> Right on the deadline to propose new features for Fedora 19 (it wasn't
> planned) I submitted Apache OpenOffice as a proposed new feature:
> https://fedoraproject.org/**wiki/Features/ApacheOpenOffice
>
> You can see this as a first step in getting back into the major Linux
> distributions. Timing aside, Fedora is a very good choice for a number of
> reasons.
>
> Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after all.
> The Fedora 19 release schedule, as an exception to the common Fedora
> conventions, will not be time-based but feature-based: features accepted by
> the Fedora Board will be considered before drafting the schedule. Anyway,
> optimally it would allow to package OpenOffice 4.0 (and there would be work
> to do on the OpenOffice and the Fedora side to get OpenOffice properly
> packaged).
>
> Regards,
>   Andrea.
>


Good! The proposal was noticed by Phoronix too :)

http://www.phoronix.com/scan.php?page=news_item&px=MTI4ODI

Regards
Ricardo


Re: buildbot failure in ASF Buildbot on aoo-w7snap

2013-01-30 Thread Herbert Duerr

On 01/30/2013 09:35 PM, Andrew Rist wrote:

Can anyone help with debugging the Windows snapshot build?
It dies building shell - source/win32/sysmail
with :

dmake: Error: -- `simplemapi.hxx' not found, and can't be made


The file simplemapi.hxx was removed almost four weeks ago [1]
and that resulted in a problem on the incremental build too [2], but 
that was solved by the weekly clobbering [3] then.


There must be an old dependency file somewhere on the buildbot. 
Clobbering the output of at least the shell module should help.


[1] http://svn.apache.org/viewvc?view=revision&revision=1429067
[2] 
http://ci.apache.org/builders/aoo-win7/builds/453/steps/shell_4/logs/stdio
[3] 
http://ci.apache.org/builders/aoo-win7/builds/456/steps/compile_1/logs/stdio


Hope that helps,
Herbert


Re: Need Sol8/Sol10 OpenOffice Binaries?

2013-01-30 Thread Marcus (OOo)

Am 01/30/2013 09:42 AM, schrieb Raphael Bircher:

Hi

Am 30.01.13 09:30, schrieb Abdul Rahim:

Hi Team,

I am trying to find a solaris 8 or solaris 10 binanries for OpenOffice
and
I am not able to find it on the site:
http://www.openoffice.org/download/other.html

Is there any other site where I can download it?


For Solaris 10 Sparc
https://adfinis-sygroup.ch/aoo-solaris-sparc

And for Solaris x86
https://adfinis-sygroup.ch/aoo-solaris-x86

Solaris 8 is no longer suppertet.. but since long time.

I hope this helps.

Greetings Raphael


Additionally you can also have a look at the following webpage when you 
look for officially released installation files:


http://www.openoffice.org/download/legacy/other.html

Note:
These are files from the OOo 3.3.0 release. It was the last release from 
Sun/Oracle and doesn't belong to Apache. But we are hosting them as 
legacy release.


Marcus


Re: buildbot failure in ASF Buildbot on aoo-w7snap

2013-01-30 Thread Andrew Rist

Can anyone help with debugging the Windows snapshot build?
It dies building shell - source/win32/sysmail
with :

dmake:  Error: -- `simplemapi.hxx' not found, and can't be made

http://ci.apache.org/projects/openoffice/buildlogs/winsnap/log/wntmsci12.pro.build.html


On 1/30/2013 10:39 AM, build...@apache.org wrote:

Hi! , The aoo-w7snap builder has just completed a run

STATUS: Failure

  Build revision 1439888 on branch None

  Snapshot results at: http://ci.apache.org/projects/openoffice/

  Build using the ASF buildslave: bb-win7

  Build results at: http://ci.apache.org/builders/aoo-w7snap/builds/25

  Build reason was: forced: by IRC user  on channel #asftest: should 
build as nightly built


  Yours Sincerely - The ASF Buildbot (http://ci.apache.org/)
--

  Join the bui...@apache.org mailing list for help with Buildbot








Re: Error in macro.

2013-01-30 Thread Yessica Brinkmann
Hello,
I think I can do this with string functions Left and Split but I do not
know which is the separator for the ComboBox, for separating the code from
the name.
Much appreciate an answer please.
regards,
Yessica

2013/1/30 Yessica Brinkmann 

> Hello,
> Thank you for the answers!
> When I replaced the lines containing "getByName" for something as
> indicated prints a message saying: "Can not find cod_cliente". I think this
> is because it is a field cod_cliente type drop-down list box and i should
> get the id of the customer through a cut chain or something, but I really
> do not know how to do this in OO Basic. Can you help a little with this
> please? I clarify that my formal education rather relied on the C and Java.
> regards,
> Yessica
>
>
> 2013/1/30 Andrew Douglas Pitonyak 
>
>> Which line gives the error?
>>
>> If you change all lines containing "getByName" with something like
>>
>> If oFrm.hasByName("cod_cliente") Then
>>   oCliente=oFrm.getByName("cod_**cliente")
>> Else
>>   Print "Cannot find cod_cliente"
>>   Exit Sub
>> End If
>>
>> What happens?
>>
>>
>> On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:
>>
>>> Hello,
>>> I have a database of business management. I have a customer table that
>>> has
>>> a field saldo_actual.
>>> On the other hand, I have a sales form, in which I have a total field,
>>> and
>>> a button Calculate Total.
>>> I want to make a macro that when clicking on the Calculate Total button
>>> to
>>> add the total saldo_actual field.
>>> I assigned the macro to the button event: Mouse button released. Then I
>>> write my macro:
>>> Sub ActualizarSaldoVentas (Evento)
>>> Dim oFrm As Object
>>> Dim oCliente As Object
>>> Dim oTotal As Object
>>> Dim oCon As Object
>>> Dim oStat As Object
>>> Dim sSQL As String
>>> Dim oRes As Object
>>> Dim sCliente as String
>>> oFrm=Evento.Source.Model.**Parent
>>> oCliente=oFrm.getByName("cod_**cliente")
>>> sCliente=oCliente.**getCurrentValue()
>>> oTotal=oFrm.getByName("total")
>>> oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
>>> oStat=oCon.CreateStatement
>>> sSQL="UPDATE cliente SET cliente.saldo_actual =
>>> cliente.saldo_saldo_actual
>>> + "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
>>> oCliente.getCurrentValue()
>>> oRes=oStat.ExecuteQuery(sSQL)
>>> End Sub
>>> Clicking on the button Calculate total, I get the following error:
>>> BASIC runtime error. There was an exception.
>>> Type: com.sun.star.container.**NoSuchElementException Message:
>>> I would appreciate very much a help please.
>>> regards,
>>> Yessica
>>>
>>>
>> --
>> Andrew Pitonyak
>> My Macro Document: 
>> http://www.pitonyak.org/**AndrewMacro.odt
>> Info:  http://www.pitonyak.org/oo.php
>>
>>
>


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Marcus (OOo)

Am 01/30/2013 04:12 PM, schrieb Andrea Pescetti:

Right on the deadline to propose new features for Fedora 19 (it wasn't
planned) I submitted Apache OpenOffice as a proposed new feature:
https://fedoraproject.org/wiki/Features/ApacheOpenOffice

You can see this as a first step in getting back into the major Linux
distributions. Timing aside, Fedora is a very good choice for a number
of reasons.

Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after
all. The Fedora 19 release schedule, as an exception to the common
Fedora conventions, will not be time-based but feature-based: features
accepted by the Fedora Board will be considered before drafting the
schedule. Anyway, optimally it would allow to package OpenOffice 4.0
(and there would be work to do on the OpenOffice and the Fedora side to
get OpenOffice properly packaged).


Andrea, thanks for keeping the eyes open for more integration. Let's 
cross our fingers, maybe it helps to be successful.


Marcus



Re: Como fazer cartões de visita

2013-01-30 Thread Albino Biasutti Neto
Olá

Em 29 de janeiro de 2013 00:23, CARMO RODRIGUES  escreveu:
> Gostaria de explicações de como fazer Cartões de Visita com o 
> OpenOfficeApache , mas em Portugues se possível,
> Desde já agradeço-lhes

Carmo, esse lista é em Inglês.

Inscreva-se na lista pt-br da AOO:  geral-p...@openoffice.apache.org


-- 
Albino Biasutti Neto
Software Livre | Open Source | Free Software
albino.ws
identi.ca/bino28


Re: Polish AOO 3.4.1 not available error.

2013-01-30 Thread Marcus (OOo)

Am 01/30/2013 05:40 PM, schrieb Piotr B. (pb2004):

Page http://www.openoffice.org/download/ incorrectly says:
"A release for Polski is not available. Please choose from the
alternative download webpage for another language."[1]

Please correct this error.

1. http://img593.imageshack.us/img593/7279/screenshotcnb.png


Thanks a lot for your hint. The problem should be fixed now.

Marcus


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Albino Biasutti Neto
Hi

2013/1/30 Andrea Pescetti :
> Right on the deadline to propose new features for Fedora 19 (it wasn't
> planned) I submitted Apache OpenOffice as a proposed new feature:
> https://fedoraproject.org/wiki/Features/ApacheOpenOffice

I am currently a user of Fedora. Has a good initiative.

-- 
Albino Biasutti Neto
Software Livre | Open Source | Free Software
albino.ws
identi.ca/bino28


Re: Sidebar color scheme survey

2013-01-30 Thread Jürgen Schmidt
On 1/30/13 11:33 AM, Fabrizio Marchesano wrote:
> Hello Andre,
> thanks for your quick reply.
> 
>> I will be at FOSDEM, too, so I hope that we can meet.
> 
> I'll be glad, too: I will stay in Brussels only on Saturday, I hope to have
> the chance to meet you.
> 
>>  So, if you develop such extensions then it would be very
>> helpful if you could test them with the developer build.
> 
> I'll try immediately and let you know (hopefully in person at FOSDEM).
> Thanks again and best regards,

it works already, I have tweaked a test extension with the old and the
new mechanism. Supporting an own panel as well as integrating in an
extension panel as additional dock.

Andre gave me the necessary support and I plan to include in my FOSDEM
talk. I will at least give an outlook and it open s even abetter
integration opportunity for extensions developers.

Juergen

> 
> Fabrizio
> 
> 
> On Wed, Jan 30, 2013 at 3:51 PM, Andre Fischer  wrote:
> 
>> On 30.01.2013 15:24, Fabrizio Marchesano wrote:
>>
>>> Hello Andre,
>>> I just tested the Sidebar Developer Build on a Windows XP virtual Machine
>>>
>>
>> Hm, that means that it runs on XP but not on Windows7.  Strange.
>>
>>
>>  and it looks really great, thanks for the great work by my side, too!
>>> May I ask if I can include a screenshot of the Sidebar Developer Build
>>> into
>>> my FOSDEM presentation?
>>>
>>
>> Absolutely.  I will be at FOSDEM, too, so I hope that we can meet.
>>
>>
>>  The subject of my talk is the development of custom Task Pane estensions,
>>> and I would like to show a glimpse of the future (of course, mentioning
>>> the
>>> source wiki page and specifying that the screenshot is related to a
>>> work-in-progess UI).
>>> I'm highly interested in custom sidebar extension development (I began
>>> creating custom sidebar plug-ins for clients in IBM Lotus Symphony
>>> environment) and I would like to contribute on the subject; I currently
>>> use
>>> Java and NetBeans plug-in to create my extension, is the source code for
>>> the Java extension for development and debugging of the sidebar available?
>>>
>>
>> Not yet.  I plan on making the source public when a) I find a good place
>> for it and b) the configuration and API changes/enhancements settle.
>>
>>
>>  Is there any other way I may help?
>>>
>>
>> My goal is to stay compatible with the current way of adding sidebar
>> extensions.  So, if you develop such extensions then it would be very
>> helpful if you could test them with the developer build.  Just install them
>> like you do that now and they should be visible in both the old/current and
>> the new sidebar.
>>
>> -Andre
>>
>>
>>  About the color scheme survey, my preference goes to C1, followed by B1
>>> and
>>> A1.
>>> Thanks in advance and best regards,
>>>
>>> Fabrizio
>>>
>>> On Wed, Jan 30, 2013 at 5:07 AM, Shenfeng Liu  wrote:
>>>
>>>  Andre,
Thanks for the great work!
I search out the original sidebar post on facebook:
 http://www.facebook.com/**ApacheOO/posts/395424523873910
And the result till now shows that B1 and B3 are more favorite, and
 A1 is
 following.

Here is what I counted out (some people voted for multiple options.
 And
 if some one just say "I like 3", I will +1 for A3, B3 and C3):

 A1: 4
 A2: 1
 A3: 2
 B1: 5
 B2: 1
 B3: 5
 C1: 2
 C2: 1
 C3: 3

 - Shenfeng (Simon)



 2013/1/30 Kevin Grignon 

  Andre,
>
> This is looking really great.
>
> Re: colour
> An initial goal for the sidebar is to compliment, but not compete with
> of
> distract users from the canvas. In an effort to minimize UI noise and
>
 help

> keep the focus on the editor canvas - the work - I recommend we adopt a
> hybrid of proposal 1 & 3: a grey background with suitable contrast for
>
 the

> title sections, a darker grey.
>
> Another option might be to use a gradient for the section title. Darker
>
 to

> lighter, top to bottom. This would frame the header, reinforce the
> expand/collapse affordable And reinforce the info architecture. More
> importantly, if the gradient resolved to the background colour, it would
> eliminate the line between the header text and the content. This will
> strengthen the association between the section title and content and
> mitigate the Lego effect. I can prep a sketch to illustrate my point.
>
> Re: control styles
> Again, noise reduction and consistency would be best. Flat backgrounds
>
 are

> consistent with other toolbars and reduce non-actionable pixels. I
> recommend we implement Proposal B.
>
> Again, great job.
>
> I'm looking forward to exploring new and exciting uses for the sidebar
> framework.
>
> Best regards,
> Kevin
>
>
>
> On Jan 29,

Re: Introduction [Introduction]

2013-01-30 Thread Jürgen Schmidt
On 1/30/13 8:55 AM, Marek Counts wrote:
> 
> 
> Hello, 
> 
> My name is
> Marek and I'm a masters student in computer science with dual concentrations 
> in
> Program Security and database technology. I know C/C++,C# , java, python and 
> VB
> to the extent I have written programs with each. 
> 
> I would like to
> help with the development of this project. I am currently reading through a 
> lot
> of the starters guide documents as well as some of the other information that 
> I
> can get my hands on. Anyhow, I'm here and ready to help however I can, this
> will be my first large project I have ever helped with so I apologize if I
> stumble around for a few weeks.
> 
> I have
> downloaded some of the code and will be looking though that the rest of this
> week most likely trying to at least make heads or tails of it. Anyhow, 
> anything
> simple that any of you need help on just shoot me a message and I would love 
> to
> help you out with it!
> 
> I have a few
> operating systems I can test on.
> 
> windows 7, Windows
> 8, Gentoo, and backtrack
> 

Hi Marek,

first of all welcome at OpenOffice and your interest to help us to
improve the product.

I think a good way to get started is to prepare your own build env, you
can find a building guide under
http://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO

Once you have prepared your build env you can try to debug certain code
areas and can try to analyze some issues. The best way it to get simply
started and learn by doing. Once you have picked up an issue you can
come back and ask where to get started and we can give you more detailed
tips. The code base is huge and focusing on one specific area is
probably a good idea.

The best debugging tool is of course the Microsoft debugger and I would
recommend to start debugging under windows. But it really depends on
your own preferences and gdb works as well.

Again welcome at Apache OpenOffice and please feel free to ask question.

Juergen




Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread Pedro Giffuni
Hello;


- Messaggio originale -
> Da: David Gerard
...
> 
> 
> A question I was wondering (for the Wikipedia article): is there any
> Linux distribution that presently carries AOO in its repos?
> 
> I understand it's in the FreeBSD ports tree
> http://www.freebsd.org/cgi/cvsweb.cgi/ports/editors/openoffice-3-devel/
> - which would be the BSD equivalent.
> 

I don't know about linux but for FreeBSD please use this link:

http://www.freshports.org/editors/openoffice-3/


the -devel version is only meant for ... developers :).

Pedro.



Re: Polish AOO 3.4.1 not available error.

2013-01-30 Thread Kay Schenk
On Wed, Jan 30, 2013 at 8:40 AM, Piotr B. (pb2004) <
p_borkow...@nospamgazeta.pl> wrote:

> Page 
> http://www.openoffice.org/**download/incorrectly
>  says:
> "A release for Polski is not available. Please choose from the alternative
> download webpage for another language."[1]
>
> Please correct this error.
>
> 1. 
> http://img593.imageshack.us/**img593/7279/screenshotcnb.png
> --
> Piotr Borkowski
>

Hello Piotr --

Our apologies. We will correct this problem with the script that
automatically detects language and platform as soon as possible. Meanwhile,
you should be able to get the Polish version from the full-listing page:

http://www.openoffice.org/download/other.html



-- 

MzK

"A great deal of talent is lost to the world
  for want of a little courage."
 -- Sydney Smith


Polish AOO 3.4.1 not available error.

2013-01-30 Thread Piotr B. (pb2004)

Page http://www.openoffice.org/download/ incorrectly says:
"A release for Polski is not available. Please choose from the alternative 
download webpage for another language."[1]


Please correct this error.

1. http://img593.imageshack.us/img593/7279/screenshotcnb.png
--
Piotr Borkowski 





Re: Sidebar color scheme survey

2013-01-30 Thread Fabrizio Marchesano
Hello Andre,
thanks for your quick reply.

> I will be at FOSDEM, too, so I hope that we can meet.

I'll be glad, too: I will stay in Brussels only on Saturday, I hope to have
the chance to meet you.

>  So, if you develop such extensions then it would be very
> helpful if you could test them with the developer build.

I'll try immediately and let you know (hopefully in person at FOSDEM).
Thanks again and best regards,

Fabrizio


On Wed, Jan 30, 2013 at 3:51 PM, Andre Fischer  wrote:

> On 30.01.2013 15:24, Fabrizio Marchesano wrote:
>
>> Hello Andre,
>> I just tested the Sidebar Developer Build on a Windows XP virtual Machine
>>
>
> Hm, that means that it runs on XP but not on Windows7.  Strange.
>
>
>  and it looks really great, thanks for the great work by my side, too!
>> May I ask if I can include a screenshot of the Sidebar Developer Build
>> into
>> my FOSDEM presentation?
>>
>
> Absolutely.  I will be at FOSDEM, too, so I hope that we can meet.
>
>
>  The subject of my talk is the development of custom Task Pane estensions,
>> and I would like to show a glimpse of the future (of course, mentioning
>> the
>> source wiki page and specifying that the screenshot is related to a
>> work-in-progess UI).
>> I'm highly interested in custom sidebar extension development (I began
>> creating custom sidebar plug-ins for clients in IBM Lotus Symphony
>> environment) and I would like to contribute on the subject; I currently
>> use
>> Java and NetBeans plug-in to create my extension, is the source code for
>> the Java extension for development and debugging of the sidebar available?
>>
>
> Not yet.  I plan on making the source public when a) I find a good place
> for it and b) the configuration and API changes/enhancements settle.
>
>
>  Is there any other way I may help?
>>
>
> My goal is to stay compatible with the current way of adding sidebar
> extensions.  So, if you develop such extensions then it would be very
> helpful if you could test them with the developer build.  Just install them
> like you do that now and they should be visible in both the old/current and
> the new sidebar.
>
> -Andre
>
>
>  About the color scheme survey, my preference goes to C1, followed by B1
>> and
>> A1.
>> Thanks in advance and best regards,
>>
>> Fabrizio
>>
>> On Wed, Jan 30, 2013 at 5:07 AM, Shenfeng Liu  wrote:
>>
>>  Andre,
>>>Thanks for the great work!
>>>I search out the original sidebar post on facebook:
>>> http://www.facebook.com/**ApacheOO/posts/395424523873910
>>>And the result till now shows that B1 and B3 are more favorite, and
>>> A1 is
>>> following.
>>>
>>>Here is what I counted out (some people voted for multiple options.
>>> And
>>> if some one just say "I like 3", I will +1 for A3, B3 and C3):
>>>
>>> A1: 4
>>> A2: 1
>>> A3: 2
>>> B1: 5
>>> B2: 1
>>> B3: 5
>>> C1: 2
>>> C2: 1
>>> C3: 3
>>>
>>> - Shenfeng (Simon)
>>>
>>>
>>>
>>> 2013/1/30 Kevin Grignon 
>>>
>>>  Andre,

 This is looking really great.

 Re: colour
 An initial goal for the sidebar is to compliment, but not compete with
 of
 distract users from the canvas. In an effort to minimize UI noise and

>>> help
>>>
 keep the focus on the editor canvas - the work - I recommend we adopt a
 hybrid of proposal 1 & 3: a grey background with suitable contrast for

>>> the
>>>
 title sections, a darker grey.

 Another option might be to use a gradient for the section title. Darker

>>> to
>>>
 lighter, top to bottom. This would frame the header, reinforce the
 expand/collapse affordable And reinforce the info architecture. More
 importantly, if the gradient resolved to the background colour, it would
 eliminate the line between the header text and the content. This will
 strengthen the association between the section title and content and
 mitigate the Lego effect. I can prep a sketch to illustrate my point.

 Re: control styles
 Again, noise reduction and consistency would be best. Flat backgrounds

>>> are
>>>
 consistent with other toolbars and reduce non-actionable pixels. I
 recommend we implement Proposal B.

 Again, great job.

 I'm looking forward to exploring new and exciting uses for the sidebar
 framework.

 Best regards,
 Kevin



 On Jan 29, 2013, at 11:41 PM, Andre Fischer  wrote:

  Hi,
>
> Development of the sidebar is progressing well.  It already looks a lot
>
 like the mockups posted by Xin Li on December 18th [1].  I have
 concentrated on the underlying framework, so there is only one partially
 migrated panel so far.  Nevertheless the framework is now flexible
 enough
 to think about the default color scheme to use. There are developer

>>> builds
>>>
 [2] and an extension that allow live evaluation of the nine different

>>> color
>>>
 schemes from [1].
>

Re: Ubuntu Build Instructions

2013-01-30 Thread AlanSan

Le 01/29/2013 09:41 PM, jorge ivan poot diaz a écrit :

Hello
I have a problem: Ubuntu Build Instructions

I did all the instructions but eventually tells me I have the following
code:

sudo apt-get install python-dev ccache libgraphite-dev \
libwpd8-dev libxslt-dev libdb4.7-dev libhunspell libneon27-dev-dev-dev
libaltlinuxhyph

Where generates me an error saying that the package libdb4.7-dev is not
available, but some other package refers to it. This may mean that the
package is missing, has been obsoleted, or is only available from another
source.

1. What should I do?
2. What are the possible causes of this?
3. Shortness requirements to install?
4. I'm using Ubuntu 10.4
5. I installed OpenJDK.

Hello Ivan, this error happens because canonical has been removed this 
library
from their repositories, you can download the library from this page: 
https://launchpad.net/ubuntu/+source/db4.7/4.7.25-10


AlanSan.


Re: Help with OOO project

2013-01-30 Thread Michal Hriň
Dňa Mon, 28 Jan 2013 17:49:57 +0100 Alexandro Colorado   
napísal:



On Mon, Jan 28, 2013 at 1:46 PM, Jan Vrba  wrote:


Dear Sir / Madam,

I would like to help you with Apache Open Office project. My native
language is Czech, I have an English Advanced Certificate from Cambridge
and JLPT N4 (Japanese Lang.). Therefore I can translate something for  
you.




Hi Jan,

if you are interested in translation the better mailing list for you would  
be l10n.


http://openoffice.apache.org/mailing-lists.html#localization-mailing-list-public

For the first time you can read some informations about organization

http://openoffice.apache.org/orientation/intro-contributing.html

and  here are some informations about translation

http://openoffice.apache.org/translate.html

In this time product/program is translated on 99% into Czech language.
If you are not commiter you can make suggestion to pootle or ask Juergen  
for "po files"

and finish/review translation offline.

If you have some knowledge about HTML you can translate/create Czech  
national language web page

which is now little outdated.

Welcome in project!

Regards,
Michal Hriň



Moreover I can help you with testing new version of Apache OpenOffice  
for

PC or Android (if you are planning to make Android version).

If you are interested, please feel free to contact me and I can send you
my CV.



Hi Jan, welcome!

Please make sure to read the introduction modules of the QA project,  
which

include instructions about testing and how we organized ourselves through
test cases.
http://openoffice.apache.org/orientation/intro-qa.html

Also please check the piece on Testing like, setting up virtual OS via
Virtualbox or other emulation software and getting our nightly builds and
Snapshot build:
https://cwiki.apache.org/confluence/display/OOOUSERS/Development+Snapshot+Builds






I look forward to hearing from you.

Your faithfully,
Jan Vrba








--
Táto správa bola vytvorená poštovým klientom v prehliadači Opera:  
http://www.opera.com/mail/


RE: soffice process still running

2013-01-30 Thread Steele, Raymond
Any help here would be appreciated.   xCloseable.close(true) does not kill the 
soffice process off. Also, I am using version 3.3 versus 3.2 as stated below.

Thanks!


From: Steele, Raymond
Sent: Monday, January 28, 2013 3:44 PM
To: 'ooo-...@incubator.apache.org'; 'ooo-...@incubator.apache.org'; 
'ooo-...@incubator.apache.org'
Subject: soffice process still running

After implementing the below code, the soffice process continues to run. I 
check this using ps -ef| grep soffice on Solaris 10 x86 OpenOffice 3.2.  Can 
anyone explain how to get this process to stop? I do not want to use the kill 
command because I do not want to kill any other instances of open office. 
Thanks!

  // Conditions: xDocument = m_xLoadedDocument
  // Check supported functionality of the document (model or controller).
  com.sun.star.frame.XModel xModel =
(com.sun.star.frame.XModel)UnoRuntime.queryInterface(
  com.sun.star.frame.XModel.class,xDocument);

  if(xModel!=null)
  {
// It is a full featured office document.
// Try to use close mechanism instead of a hard dispose().
// But maybe such service is not available on this model.
com.sun.star.util.XCloseable xCloseable =
  (com.sun.star.util.XCloseable)UnoRuntime.queryInterface(
com.sun.star.util.XCloseable.class,xModel);

  if(xCloseable!=null)
  {
try
  {
// use close(boolean DeliverOwnership)
// The boolean parameter DeliverOwnership tells objects vetoing the 
close process that they may
// assume ownership if they object the closure by throwing a 
CloseVetoException
// Here we give up ownership. To be on the safe side, catch possible 
veto exception anyway.
xCloseable.close(true);
  }
  catch(com.sun.star.util.CloseVetoException exCloseVeto)
  {
  }
  }
  // If close is not supported by this model - try to dispose it.
  // But if the model disagree with a reset request for the modify state
  // we shouldn't do so. Otherwhise some strange things can happen.
  else
  {
  com.sun.star.lang.XComponent xDisposeable =
(com.sun.star.lang.XComponent)UnoRuntime.queryInterface(
 com.sun.star.lang.XComponent.class,xModel);
 xDisposeable.dispose();
   }
   catch(com.sun.star.beans.PropertyVetoException exModifyVeto)
   {
   }
  }
}
  }


Raymond Steele



Re: Error in macro.

2013-01-30 Thread Yessica Brinkmann
Hello,
Thank you for the answers!
When I replaced the lines containing "getByName" for something as indicated
prints a message saying: "Can not find cod_cliente". I think this is
because it is a field cod_cliente type drop-down list box and i should get
the id of the customer through a cut chain or something, but I really do
not know how to do this in OO Basic. Can you help a little with this
please? I clarify that my formal education rather relied on the C and Java.
regards,
Yessica


2013/1/30 Andrew Douglas Pitonyak 

> Which line gives the error?
>
> If you change all lines containing "getByName" with something like
>
> If oFrm.hasByName("cod_cliente") Then
>   oCliente=oFrm.getByName("cod_**cliente")
> Else
>   Print "Cannot find cod_cliente"
>   Exit Sub
> End If
>
> What happens?
>
>
> On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:
>
>> Hello,
>> I have a database of business management. I have a customer table that has
>> a field saldo_actual.
>> On the other hand, I have a sales form, in which I have a total field, and
>> a button Calculate Total.
>> I want to make a macro that when clicking on the Calculate Total button to
>> add the total saldo_actual field.
>> I assigned the macro to the button event: Mouse button released. Then I
>> write my macro:
>> Sub ActualizarSaldoVentas (Evento)
>> Dim oFrm As Object
>> Dim oCliente As Object
>> Dim oTotal As Object
>> Dim oCon As Object
>> Dim oStat As Object
>> Dim sSQL As String
>> Dim oRes As Object
>> Dim sCliente as String
>> oFrm=Evento.Source.Model.**Parent
>> oCliente=oFrm.getByName("cod_**cliente")
>> sCliente=oCliente.**getCurrentValue()
>> oTotal=oFrm.getByName("total")
>> oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
>> oStat=oCon.CreateStatement
>> sSQL="UPDATE cliente SET cliente.saldo_actual = cliente.saldo_saldo_actual
>> + "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
>> oCliente.getCurrentValue()
>> oRes=oStat.ExecuteQuery(sSQL)
>> End Sub
>> Clicking on the button Calculate total, I get the following error:
>> BASIC runtime error. There was an exception.
>> Type: com.sun.star.container.**NoSuchElementException Message:
>> I would appreciate very much a help please.
>> regards,
>> Yessica
>>
>>
> --
> Andrew Pitonyak
> My Macro Document: 
> http://www.pitonyak.org/**AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
>
>


Re: Apache OpenOffice in Fedora 19?

2013-01-30 Thread David Gerard
On 30 January 2013 15:12, Andrea Pescetti  wrote:

> You can see this as a first step in getting back into the major Linux
> distributions. Timing aside, Fedora is a very good choice for a number of
> reasons.


A question I was wondering (for the Wikipedia article): is there any
Linux distribution that presently carries AOO in its repos?

I understand it's in the FreeBSD ports tree
http://www.freebsd.org/cgi/cvsweb.cgi/ports/editors/openoffice-3-devel/
- which would be the BSD equivalent.


- d.


Apache OpenOffice in Fedora 19?

2013-01-30 Thread Andrea Pescetti
Right on the deadline to propose new features for Fedora 19 (it wasn't 
planned) I submitted Apache OpenOffice as a proposed new feature:

https://fedoraproject.org/wiki/Features/ApacheOpenOffice

You can see this as a first step in getting back into the major Linux 
distributions. Timing aside, Fedora is a very good choice for a number 
of reasons.


Let's wait and see; Fedora 19 is nicknamed "Schroedinger's cat" after 
all. The Fedora 19 release schedule, as an exception to the common 
Fedora conventions, will not be time-based but feature-based: features 
accepted by the Fedora Board will be considered before drafting the 
schedule. Anyway, optimally it would allow to package OpenOffice 4.0 
(and there would be work to do on the OpenOffice and the Fedora side to 
get OpenOffice properly packaged).


Regards,
  Andrea.


Re: Sidebar color scheme survey

2013-01-30 Thread Andre Fischer

On 30.01.2013 15:24, Fabrizio Marchesano wrote:

Hello Andre,
I just tested the Sidebar Developer Build on a Windows XP virtual Machine


Hm, that means that it runs on XP but not on Windows7.  Strange.


and it looks really great, thanks for the great work by my side, too!
May I ask if I can include a screenshot of the Sidebar Developer Build into
my FOSDEM presentation?


Absolutely.  I will be at FOSDEM, too, so I hope that we can meet.


The subject of my talk is the development of custom Task Pane estensions,
and I would like to show a glimpse of the future (of course, mentioning the
source wiki page and specifying that the screenshot is related to a
work-in-progess UI).
I'm highly interested in custom sidebar extension development (I began
creating custom sidebar plug-ins for clients in IBM Lotus Symphony
environment) and I would like to contribute on the subject; I currently use
Java and NetBeans plug-in to create my extension, is the source code for
the Java extension for development and debugging of the sidebar available?


Not yet.  I plan on making the source public when a) I find a good place 
for it and b) the configuration and API changes/enhancements settle.



Is there any other way I may help?


My goal is to stay compatible with the current way of adding sidebar 
extensions.  So, if you develop such extensions then it would be very 
helpful if you could test them with the developer build.  Just install 
them like you do that now and they should be visible in both the 
old/current and the new sidebar.


-Andre


About the color scheme survey, my preference goes to C1, followed by B1 and
A1.
Thanks in advance and best regards,

Fabrizio

On Wed, Jan 30, 2013 at 5:07 AM, Shenfeng Liu  wrote:


Andre,
   Thanks for the great work!
   I search out the original sidebar post on facebook:
http://www.facebook.com/ApacheOO/posts/395424523873910
   And the result till now shows that B1 and B3 are more favorite, and A1 is
following.

   Here is what I counted out (some people voted for multiple options. And
if some one just say "I like 3", I will +1 for A3, B3 and C3):

A1: 4
A2: 1
A3: 2
B1: 5
B2: 1
B3: 5
C1: 2
C2: 1
C3: 3

- Shenfeng (Simon)



2013/1/30 Kevin Grignon 


Andre,

This is looking really great.

Re: colour
An initial goal for the sidebar is to compliment, but not compete with of
distract users from the canvas. In an effort to minimize UI noise and

help

keep the focus on the editor canvas - the work - I recommend we adopt a
hybrid of proposal 1 & 3: a grey background with suitable contrast for

the

title sections, a darker grey.

Another option might be to use a gradient for the section title. Darker

to

lighter, top to bottom. This would frame the header, reinforce the
expand/collapse affordable And reinforce the info architecture. More
importantly, if the gradient resolved to the background colour, it would
eliminate the line between the header text and the content. This will
strengthen the association between the section title and content and
mitigate the Lego effect. I can prep a sketch to illustrate my point.

Re: control styles
Again, noise reduction and consistency would be best. Flat backgrounds

are

consistent with other toolbars and reduce non-actionable pixels. I
recommend we implement Proposal B.

Again, great job.

I'm looking forward to exploring new and exciting uses for the sidebar
framework.

Best regards,
Kevin



On Jan 29, 2013, at 11:41 PM, Andre Fischer  wrote:


Hi,

Development of the sidebar is progressing well.  It already looks a lot

like the mockups posted by Xin Li on December 18th [1].  I have
concentrated on the underlying framework, so there is only one partially
migrated panel so far.  Nevertheless the framework is now flexible enough
to think about the default color scheme to use. There are developer

builds

[2] and an extension that allow live evaluation of the nine different

color

schemes from [1].

I would like to ask you to either look at the mockups at [1] or try the

developer builds [2] and tell me what color scheme you like best.

General information about the sidebar, the current state of development

and how to help can be found in the wiki [3].

Thanks in advance for you help,
Andre


[1]

http://wiki.openoffice.org/wiki/AOO_UX_Design_Exploration_-_Task_Pane_Content_Panel_-_User_Interface_Design_Proposals#Task_Pane_Content_Panel_-_UX_Design_propoals

[2] http://wiki.openoffice.org/wiki/Sidebar#Developer_Builds
[3] http://wiki.openoffice.org/wiki/Sidebar

PS: I remember Rob having asked the same question on our Facebook site

but can not find the email anymore.  I also remember that the feedback

was

somewhat inconclusive.  Does anybody know the details?




Re: refresh Update Service for our AOO 3.4.1 respin release

2013-01-30 Thread Rob Weir
On Wed, Jan 30, 2013 at 5:23 AM, Oliver-Rainer Wittmann
 wrote:
> Hi,
>
> I will refresh our Update Service for OOo 3.2, OOo 3.2.1, OOo 3.3 and AOO
> 3.4 to consider the new available languages.
>
> Per default users of these former versions having the corresponding language
> installation will the directed to the general download page [1].
> If somebody knows a better page for one of the new languages Danish,
> Norwegian, Swedish, Korean, Polish, Basque, Asturian and Scottish
> Gaelic, please let me know.
>

We do have NL pages for some of these languages, but they are not yet
updated for the new release, so I would recommend sending the users to
the default download page for now.  We can always change this later.

Thanks!

-Rob

> [1] http://www.openoffice.org/download
>
>
> Best regards, Oliver.


Re: Sidebar color scheme survey

2013-01-30 Thread Fabrizio Marchesano
Hello Andre,
I just tested the Sidebar Developer Build on a Windows XP virtual Machine
and it looks really great, thanks for the great work by my side, too!
May I ask if I can include a screenshot of the Sidebar Developer Build into
my FOSDEM presentation?
The subject of my talk is the development of custom Task Pane estensions,
and I would like to show a glimpse of the future (of course, mentioning the
source wiki page and specifying that the screenshot is related to a
work-in-progess UI).
I'm highly interested in custom sidebar extension development (I began
creating custom sidebar plug-ins for clients in IBM Lotus Symphony
environment) and I would like to contribute on the subject; I currently use
Java and NetBeans plug-in to create my extension, is the source code for
the Java extension for development and debugging of the sidebar available?
Is there any other way I may help?
About the color scheme survey, my preference goes to C1, followed by B1 and
A1.
Thanks in advance and best regards,

Fabrizio

On Wed, Jan 30, 2013 at 5:07 AM, Shenfeng Liu  wrote:

> Andre,
>   Thanks for the great work!
>   I search out the original sidebar post on facebook:
> http://www.facebook.com/ApacheOO/posts/395424523873910
>   And the result till now shows that B1 and B3 are more favorite, and A1 is
> following.
>
>   Here is what I counted out (some people voted for multiple options. And
> if some one just say "I like 3", I will +1 for A3, B3 and C3):
>
> A1: 4
> A2: 1
> A3: 2
> B1: 5
> B2: 1
> B3: 5
> C1: 2
> C2: 1
> C3: 3
>
> - Shenfeng (Simon)
>
>
>
> 2013/1/30 Kevin Grignon 
>
> > Andre,
> >
> > This is looking really great.
> >
> > Re: colour
> > An initial goal for the sidebar is to compliment, but not compete with of
> > distract users from the canvas. In an effort to minimize UI noise and
> help
> > keep the focus on the editor canvas - the work - I recommend we adopt a
> > hybrid of proposal 1 & 3: a grey background with suitable contrast for
> the
> > title sections, a darker grey.
> >
> > Another option might be to use a gradient for the section title. Darker
> to
> > lighter, top to bottom. This would frame the header, reinforce the
> > expand/collapse affordable And reinforce the info architecture. More
> > importantly, if the gradient resolved to the background colour, it would
> > eliminate the line between the header text and the content. This will
> > strengthen the association between the section title and content and
> > mitigate the Lego effect. I can prep a sketch to illustrate my point.
> >
> > Re: control styles
> > Again, noise reduction and consistency would be best. Flat backgrounds
> are
> > consistent with other toolbars and reduce non-actionable pixels. I
> > recommend we implement Proposal B.
> >
> > Again, great job.
> >
> > I'm looking forward to exploring new and exciting uses for the sidebar
> > framework.
> >
> > Best regards,
> > Kevin
> >
> >
> >
> > On Jan 29, 2013, at 11:41 PM, Andre Fischer  wrote:
> >
> > > Hi,
> > >
> > > Development of the sidebar is progressing well.  It already looks a lot
> > like the mockups posted by Xin Li on December 18th [1].  I have
> > concentrated on the underlying framework, so there is only one partially
> > migrated panel so far.  Nevertheless the framework is now flexible enough
> > to think about the default color scheme to use. There are developer
> builds
> > [2] and an extension that allow live evaluation of the nine different
> color
> > schemes from [1].
> > >
> > > I would like to ask you to either look at the mockups at [1] or try the
> > developer builds [2] and tell me what color scheme you like best.
> > >
> > > General information about the sidebar, the current state of development
> > and how to help can be found in the wiki [3].
> > >
> > > Thanks in advance for you help,
> > > Andre
> > >
> > >
> > > [1]
> >
> http://wiki.openoffice.org/wiki/AOO_UX_Design_Exploration_-_Task_Pane_Content_Panel_-_User_Interface_Design_Proposals#Task_Pane_Content_Panel_-_UX_Design_propoals
> > > [2] http://wiki.openoffice.org/wiki/Sidebar#Developer_Builds
> > > [3] http://wiki.openoffice.org/wiki/Sidebar
> > >
> > > PS: I remember Rob having asked the same question on our Facebook site
> > but can not find the email anymore.  I also remember that the feedback
> was
> > somewhat inconclusive.  Does anybody know the details?
> > >
> >
>


Re: Error in macro.

2013-01-30 Thread Andrew Douglas Pitonyak

Which line gives the error?

If you change all lines containing "getByName" with something like

If oFrm.hasByName("cod_cliente") Then
  oCliente=oFrm.getByName("cod_cliente")
Else
  Print "Cannot find cod_cliente"
  Exit Sub
End If

What happens?

On 01/30/2013 04:56 AM, Yessica Brinkmann wrote:

Hello,
I have a database of business management. I have a customer table that has
a field saldo_actual.
On the other hand, I have a sales form, in which I have a total field, and
a button Calculate Total.
I want to make a macro that when clicking on the Calculate Total button to
add the total saldo_actual field.
I assigned the macro to the button event: Mouse button released. Then I
write my macro:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
oFrm=Evento.Source.Model.Parent
oCliente=oFrm.getByName("cod_cliente")
sCliente=oCliente.getCurrentValue()
oTotal=oFrm.getByName("total")
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual = cliente.saldo_saldo_actual
+ "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
oCliente.getCurrentValue()
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Clicking on the button Calculate total, I get the following error:
BASIC runtime error. There was an exception.
Type: com.sun.star.container.NoSuchElementException Message:
I would appreciate very much a help please.
regards,
Yessica



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



Re: refresh Update Service for our AOO 3.4.1 respin release

2013-01-30 Thread Oliver-Rainer Wittmann

Hi,

On 30.01.2013 11:23, Oliver-Rainer Wittmann wrote:

Hi,

I will refresh our Update Service for OOo 3.2, OOo 3.2.1, OOo 3.3 and
AOO 3.4 to consider the new available languages.



Update Service for OOo 3.2 has been refreshed.

Refreshments for the other versions will follow.

Best regards, Oliver.


Per default users of these former versions having the corresponding
language installation will the directed to the general download page [1].
If somebody knows a better page for one of the new languages Danish,
Norwegian, Swedish, Korean, Polish, Basque, Asturian and Scottish
Gaelic, please let me know.

[1] http://www.openoffice.org/download


Best regards, Oliver.




Are there still patchs from Synphony to merge?

2013-01-30 Thread Raphael Bircher

Hi at all

Are there still patchs (bugfixes) from Synphony to merge? I'm willing to 
help in this area. I have enought power to compile and test patchs here.


Do we have same instructions?

Greetings Raphael


Re: Error in macro.

2013-01-30 Thread Fernand Vanrie

Yessica ,

hard to sea, but the error must open the basic ID and higlight the place 
off the error,


"container.NoSuchElementException" >> probably a typo in the name of one 
of the fieldnames ?

called by the "getbyname"

hope it helps

Fernand



Hello,
I have a database of business management. I have a customer table that has
a field saldo_actual.
On the other hand, I have a sales form, in which I have a total field, and
a button Calculate Total.
I want to make a macro that when clicking on the Calculate Total button to
add the total saldo_actual field.
I assigned the macro to the button event: Mouse button released. Then I
write my macro:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim sCliente as String
oFrm=Evento.Source.Model.Parent
oCliente=oFrm.getByName("cod_cliente")
sCliente=oCliente.getCurrentValue()
oTotal=oFrm.getByName("total")
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual = cliente.saldo_saldo_actual
+ "& oTotal.getCurrentValue()& " WHERE id_cliente=" &
oCliente.getCurrentValue()
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Clicking on the button Calculate total, I get the following error:
BASIC runtime error. There was an exception.
Type: com.sun.star.container.NoSuchElementException Message:
I would appreciate very much a help please.
regards,
Yessica





Re: Ubuntu Build Instructions

2013-01-30 Thread Herbert Duerr

Hi Jorge,

On 30.01.2013 04:41, jorge ivan poot diaz wrote:

I have a problem: Ubuntu Build Instructions

I did all the instructions but eventually tells me I have the following
code:

sudo apt-get install python-dev ccache libgraphite-dev \
libwpd8-dev libxslt-dev libdb4.7-dev libhunspell libneon27-dev-dev-dev
libaltlinuxhyph

Where generates me an error saying that the package libdb4.7-dev is not
available, but some other package refers to it. This may mean that the
package is missing, has been obsoleted, or is only available from another
source.

1. What should I do?


Adjust the package names to what the system can provide:
According to [1] the name of the libdb development package for Ubuntu 
10.4 (aka "Lucid Lynx") seems to be "libdb4.3-dev".


[1] http://packages.ubuntu.com/cgi-bin/search_packages.pl?keywords=libdb


2. What are the possible causes of this?


Package names change depending on the Ubuntu/Debian/etc. release. IMHO 
it would have been better if the build instructions were written in a 
more generic way, e.g.

apt-get install libdb-dev
works too. I'm not sure when this apt-get feature was introduced though. 
On the other hand

apt-get install libneon-dev
requires an interaction with the generic package name because it is a 
virtual package backed by several real packages. Anyway, I changed the 
wiki page [2] for more independence from the Ubuntu version.


[2] http://wiki.openoffice.org/wiki/Ubuntu_Build_Instructions


3. Shortness requirements to install?


I don't understand this question. Could you rephrase it?

Hope that helps,
Herbert


refresh Update Service for our AOO 3.4.1 respin release

2013-01-30 Thread Oliver-Rainer Wittmann

Hi,

I will refresh our Update Service for OOo 3.2, OOo 3.2.1, OOo 3.3 and 
AOO 3.4 to consider the new available languages.


Per default users of these former versions having the corresponding 
language installation will the directed to the general download page [1].

If somebody knows a better page for one of the new languages Danish,
Norwegian, Swedish, Korean, Polish, Basque, Asturian and Scottish
Gaelic, please let me know.

[1] http://www.openoffice.org/download


Best regards, Oliver.


Re: Sidebar

2013-01-30 Thread Raphael Bircher

Hi Andre

Am 30.01.13 10:48, schrieb Andre Fischer:

On 30.01.2013 08:42, Raphael Bircher wrote:

Hi at all

Exist samwhere a build with a preview of the sidebar? or is it in the 
source samewhere aviable? I ask because I will make a small demo 
Video about Apache OpenOffice for the FOSDEM.


Hi Raphael,

you probably have missed my mail the other day.  Have a look at the 
sidebar wiki page [1].  There is a section for developer builds. But 
there seems a problem with the Windows build.  I am working on that.
Thanks for the answare. I started now a build from this branch on my 
Mac, hopefuly he complete.


Greetings Raphael




Re: Sidebar

2013-01-30 Thread Andre Fischer

On 30.01.2013 08:42, Raphael Bircher wrote:

Hi at all

Exist samwhere a build with a preview of the sidebar? or is it in the 
source samewhere aviable? I ask because I will make a small demo Video 
about Apache OpenOffice for the FOSDEM.


Hi Raphael,

you probably have missed my mail the other day.  Have a look at the 
sidebar wiki page [1].  There is a section for developer builds. But 
there seems a problem with the Windows build.  I am working on that.


The source code can found in branch "sidebar" [2]

-Andre


[1] http://wiki.openoffice.org/wiki/Sidebar
[2] https://svn.apache.org/repos/asf/openoffice/branches/sidebar/



Thanks for the Answare

Greetings Raphael




Re: Need Sol8/Sol10 OpenOffice Binaries?

2013-01-30 Thread Raphael Bircher

Hi

Am 30.01.13 09:30, schrieb Abdul Rahim:

Hi Team,

I am trying to find a solaris 8 or solaris 10 binanries for OpenOffice and
I am not able to find it on the site:
http://www.openoffice.org/download/other.html

Is there any other site where I can download it?


For Solaris 10 Sparc
https://adfinis-sygroup.ch/aoo-solaris-sparc

And for Solaris x86
https://adfinis-sygroup.ch/aoo-solaris-x86

Solaris 8 is no longer suppertet.. but since long time.

I hope this helps.

Greetings Raphael



Need Sol8/Sol10 OpenOffice Binaries?

2013-01-30 Thread Abdul Rahim
Hi Team,

I am trying to find a solaris 8 or solaris 10 binanries for OpenOffice and
I am not able to find it on the site:
http://www.openoffice.org/download/other.html

Is there any other site where I can download it?

-- 
Regards,
Abdul


Re: New volunteers from Mexico

2013-01-30 Thread Andrea Pescetti

On 29/01/2013 Henry Tiquet Leyva wrote:

We are IT's students. we are at your disposition to work in some project
that you will give us and we are at your service.


Thank you! In general, feel free to get involved in the area you prefer 
(and I see most of you are doing it; don't forget to subscribe to the 
appropriate mailing lists, see 
http://openoffice.apache.org/mailing-lists.html ).


For those interested in development, this one (dev) is the mailing lists 
to be used for all discussions. Once you have managed to build 
OpenOffice on your system, you may want to proceed with one of the 
"Easy" or "Simple" development tasks: you find links to them in 
http://openoffice.apache.org/orientation/intro-development.html


Just pick one and don't be afraid to ask here if you need more information.

Regards,
  Andrea.