date:20120703

On Tue, 2012-07-03 at 20:11 -0700, Dennis E. Hamilton wrote:
> @Rob,
> 
> Yes, I am seeing what you are seeing.
> 
> Concerning the ToU for the forums, it is the same as what was previously on 
> the web site.  While there is a license grant for non-code and other places 
> where no other license is applied, the license is also to "all Users".
> 
> @Rob, @Drew, @Kay
> 
> I created an issue that proposed a new terms of use that was consistent with 
> the Oracle ones for ASF and would have not made this problem worse, as far as 
> I can tell.  That was long ago and it went nowhere.  The JIRA issue is here: 
> .  Here's the connected 
> issue on our Bugzilla: 
> .  I came to our 
> Bugzilla because LEGAL-104 can't have attachments.  The attachment on the 
> Bugzilla provides a red-lined transformation of the Oracle ToU into one that 
> could work for the forums, wikis, and web pages now under ASF custodianship.
>  
> It addresses some of the cases that Rob also mentions.  I stand by my 
> analysis.  You might want to see how to carve out what you want from that, 
> since it is at least a start and the places where further customization may 
> be called for are all identified.
> 
>  - Dennis

Hi Dennis,

You did a good job on it then too.

I just took the time to go back and read over the exchange on the legal
JIRA entry and a quick read, again, of your markup to the original TOU
text. 

For a TOU link in the website, wiki and forum footer I think it is a
good think to just finish this up and use it.

The website no longer offers account creation so with the new TOU and
the current  http://www.openoffice.org/privacy.html , I suppose it would
be done (for today :) 

where one does still have a difference between registered and
non-registered users:

- the media wiki already has
http://wiki.services.openoffice.org/wiki/OpenOffice.org_Wiki:Copyrights
 so I suppose that would be done (for today) also.

- the forums, just add a requirement that everything new is ALv2 in
http://user.services.openoffice.org/en/forum/ucp.php?mode=terms (and
it's translations)

At least it seems this simple to me, does it really need to be thought
out a lot further then that?

//drew

> 
> Some months ago it was discussed with the ASF Board whether a privacy 
> condition and safe-harbor setup was desired.  That apparently didn't get 
> anywhere.
> 
> 
>

Re: [QA AUTOMATION] Build Verification Test(BVT) test results

Lin Yi,

  You can put the report in wiki page[1]. I just made a sample with your
Mac platform report, you could continue post result for other platform
[1]http://wiki.services.openoffice.org/wiki/QA/Report/BVT

2012/7/3 Linyi Li 

> Hi,
>
> I setup some machines to perform Build Verification Test(BVT). Here is the
> test result.
>
>- Platform:
>
> windows 8
> mac 10.7.4
> redhat 6.1
> ubuntu 10.04
> windows 7 x64
>
>- Build version: trunk build r1355288.
>- Total cases: 41.
>- Found defects: 1.
>https://issues.apache.org/ooo/show_bug.cgi?id=120171
>
> Liu Zhe helped me to put the detailed result to his spac. You can get them
> from here: http://people.apache.org/~liuzhe/test/
> Thanks Zhe!
>
> About the test results.
> logs/Logs of BVT. Recording the executed test cases and
> error messages.
> report/  Summary of test results. How many test cases were
> executed. How many passed, how many failed. Execution time. You can click
> on the number in the page to see the relevant test cases.
> result/  A .xml file. Recording the whold test process.
> screenshot/  If any case is failed, there will be a screenshot to
> record failing scenario.
>
> Any comments are welcomed!
>
> --
> Best wishes.
> Linyi Li
>



-- 


Thanks & Best Regards, Yan Ji

Re: [UPDATE SERVICE] proposal to activate the update service for OOo 3.2 and OOo 3.2.1

2012-07-03 Thread Ariel Constenla-Haile

Hi Hagar,

On Thu, Jun 28, 2012 at 5:07 PM, Hagar Delest  wrote:
> I'm rather confident it will work.
> But the problem is with the user profile. Since AOO 3.4, we have many topics
> in the forums where the fix is to reset the profile. The problem is that it
> can lead to frustration because of the loss of customization.
> Worse, when users want to downgrade, the new profile is sometimes no more
> compatible and definitively wrecked for them.
> Could something be added during install to make a copy of the user profile
> (at least silently)?

There is obviously a bug with the registrymodifications.xcu that
should be fixed somehow.

https://issues.apache.org/ooo/show_bug.cgi?id=120086
https://issues.apache.org/ooo/show_bug.cgi?id=120068
https://issues.apache.org/ooo/show_bug.cgi?id=119733
https://issues.apache.org/ooo/show_bug.cgi?id=119804
https://issues.apache.org/ooo/show_bug.cgi?id=120154

http://markmail.org/message/qcpwpb2yjisuiggx

etc etc

Regards

RE: reset my password

2012-07-03 Thread Dennis E. Hamilton

I believe an additional difficulty for Hongyun An is that he no longer has the 
use of the e-mail address that his hyan@ apache.org e-mail account forwards to.

(I also note that mail I send to hongyun...@cs2c.com.cn always bounces.)

 - Dennis

-Original Message-
From: hongyun.an [mailto:hongyun...@cs2c.com.cn] 
Sent: Tuesday, July 03, 2012 19:27
To: Tony Stevenson
Cc: root; ooo-dev
Subject: Re: reset my password

Dear Tony:

I have carefully reviewed the "people.apache.org".I have clicked the "Managing 
Your Details".
Following the instructions,I have made a FOAF file.However,I could not commit 
the FOAF file to the https://svn.apache.org/repos/private/committers/info 
because I forget my password and have no access right.
So I could not place a new file in my homedir.
Could you please help me to solve the problem?

Thank you very much.
Best wishes.


--
hongyun.an



thanks,Tony.

I am not sure that I get your meaning.I opened the "people.apache.org",then 
went to the "http://people.apache.org/foaf/index.html";
and "http://people.apache.org/foaf/foafamatic.html".I created a file named 
"hyan.rdf",with the content:

http://www.w3.org/1999/02/22-rdf-syntax-ns#";
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#";
  xmlns:foaf="http://xmlns.com/foaf/0.1/";
  xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#";
  xmlns:pm="http://www.web-semantics.org/ns/pm#";
  xmlns:wot="http://xmlns.com/wot/0.1/";
  xmlns:rss="http://purl.org/rss/1.0/";
  xmlns:dc="http://purl.org/dc/elements/1.1/";
  xmlns:ical="http://www.w3.org/2002/12/cal/ical#";
  xmlns:doap="http://usefulinc.com/ns/doap#";>

Hong Yun An
Hong Yun
An
mailto:hongyun...@cs2c.com.cn"/>
mailto:an_hong...@hotmail.com"/>


But I cound not creat a foat file.
Could you please give me some direction?
thank you very much.
best wishes.

--
hongyun.an
>Can you still login to people.apache.org ? If so can you place a new
>file in your homedir, with your new email address and then let us know
>what that is. 
>
>
>
>hongyun.an wrote on Fri, Jun 29, 2012 at 03:07:38PM +0800:
>> 
>> Dear Tony:
>> Unluckly it is.I have changed email address without updating my records.
>> My ID id hyan.The invalid email address is "anhong...@redoffice.com.cn".
>> Could you tell me how to verify my identity in detail?
>> 
>> Thank you very much. 
>> 
>> Best wishes.
>> 
>> --
>> hongyun.an
>> >Hi, 
>> >
>> >Please use httpsd://id.apache.org  - 
>> >
>> >If you have changed your email address without updating your records  
>> >here, then you will not be able to complete the password reset steps.
>> >
>> >If this is the case, we will need to try and verify your identity
>> >another way.
>> >
>> > 
>> >hongyun.an wrote on Fri, Jun 29, 2012 at 09:42:20AM +0800:
>> >> hello:
>> >>  I am the Apache committer,my ID is hyan.Now I have forgotten my password.
>> >> Could you help me to reset the password?
>> >> Now my email is :hongyun...@cs2c.com.cn
>> >> 
>> >> thank you very much!
>> >> best wishes. 
>> >> 
>> >> 
>> >> 
>> >> 
>> >> --
>> >> hongyun.an
>> >
>> >-- 
>> >Cheers,
>> >Tony
>> >
>> >---
>> >Tony Stevenson
>> >
>> >t...@pc-tony.com // pct...@apache.org // t...@caret.cam.ac.uk
>> >GPG: 1024D/51047D66
>> >http://www.pc-tony.com
>> >---
>> >
>> >
>
>-- 
>Cheers,
>Tony
>
>---
>Tony Stevenson
>
>t...@pc-tony.com // pct...@apache.org // t...@caret.cam.ac.uk
>GPG: 1024D/51047D66
>http://www.pc-tony.com
>---
>
>

RE: Terms of Service on Forums

2012-07-03 Thread Dennis E. Hamilton

@Rob,

Yes, I am seeing what you are seeing.

Concerning the ToU for the forums, it is the same as what was previously on the 
web site.  While there is a license grant for non-code and other places where 
no other license is applied, the license is also to "all Users".

@Rob, @Drew, @Kay

I created an issue that proposed a new terms of use that was consistent with 
the Oracle ones for ASF and would have not made this problem worse, as far as I 
can tell.  That was long ago and it went nowhere.  The JIRA issue is here: 
.  Here's the connected issue 
on our Bugzilla: .  I 
came to our Bugzilla because LEGAL-104 can't have attachments.  The attachment 
on the Bugzilla provides a red-lined transformation of the Oracle ToU into one 
that could work for the forums, wikis, and web pages now under ASF 
custodianship.
 
It addresses some of the cases that Rob also mentions.  I stand by my analysis. 
 You might want to see how to carve out what you want from that, since it is at 
least a start and the places where further customization may be called for are 
all identified.

 - Dennis

Some months ago it was discussed with the ASF Board whether a privacy condition 
and safe-harbor setup was desired.  That apparently didn't get anywhere.

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

Hi Rob,

On Tue, Jul 3, 2012 at 7:15 PM, Rob Weir  wrote:

> On Mon, Jul 2, 2012 at 4:33 AM, Chen Peng  wrote:
> > Hi All,
> >   My name is Chen Peng, I am a developer from Symphony. My special
> > areas are VBA and sw.
> >   Now I found an issue about macros lost:
> >  I saved an excel file with VBA to spreadsheet, the VBA can work
> > well in spreadsheet, then I wanted to save this spreadsheet back to
> excel,
> > but all the macros are lost.
>
> How common is this scenario?   Wouldn't the more typical user action
> be to re-save the document back to XLS format?


a)It is a good question about the scenario,common or not..But I think Peng
wants to ask for comments about the technical solution.


> Isn't that what
> happens by default when they do a save when editing an XLS file? If
> the user does this, will the macro be saved correctly?
>
> b)When AOO Spreadsheet launches an xls file with VBA macros, the VBA
streams will have a copy in memory and simultaneously the VBA macros are
parsed into Spreadsheet VBA model, and end users can see and edit the VBA
macros in IDE. Be aware, the modifications will only be kept in Spreadsheet
VBA model, and will be lost when end users do saving[to xls], instead, the
copy of the VBA Streams in memory will be saved back.So,if end users open
the saved xls file in MS Excel,they will only see the original VBA macros.


> >   I propose to save the binary data of excel VBA to spreadsheet, when
> > saving excel to spreadsheet, then we can get the binary data from
> > spreadsheet if need to save the spreadsheet to excel again.
> >   The binary data will not impact the open/save... of the ODF format
> > application, it will not be touched when we operate the ODF formant
> > applications. The binary data will be just used when we want to save the
> > spreadsheet to excel, it is just a data prestore about saving spreadsheet
> > macros to excel.
> >Can you give some advice about the solution?
> >Any feedback will be preciated, thanks.
>



-- 

Best Regards,Jianhong Cheng

Re: AOO 3.4 Impress not recognising Dual monitors?

2012-07-03 Thread Ariel Constenla-Haile

Hi Rory,

On Tue, Jul 3, 2012 at 3:47 PM, Rory O'Farrell  wrote:
> I'm not yet in a position to raise a formal bug, but I would appreciate input 
> from other users who may have occasion to use AOO 3.4 to give a presentation.
>
> I have not been able to get AOO 3:4 Impress to successfully recognise the 
> second monitor on later *ubuntu systems (say 11:10 and later).
>
> I have requested information from others on the Forum in thread
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=10&t=54875
>
> I would welcome input from users from the Apache lists; I bring it to the 
> attention of the ooo-dev list as some developer working on Impress may test 
> this in passing.

this is a known bug: https://issues.apache.org/ooo/show_bug.cgi?id=119327

Regards

Re: Terms of Service on Forums


On Tue, 2012-07-03 at 22:32 -0400, Rob Weir wrote:
> On Tue, Jul 3, 2012 at 10:18 PM, drew jensen  
> wrote:
> > On Tue, 2012-07-03 at 19:44 -0400, Rob Weir wrote:
> >> Can someone take ownership of this issue?
> >>
> >> https://issues.apache.org/ooo/show_bug.cgi?id=118939
> >>
> >> Look at http://user.services.openoffice.org/en/forum/index.php
> >>
> >> Then to the footer and the "Policies and Terms of Use".
> >>
> >> This links to this page:  http://www.openoffice.org/terms_of_use
> >>
> >> That starts with "This Site and its contents are made available by
> >> Oracle America, Inc. for and on behalf of itself and its subsidiaries
> >> and affiliates under common control ("Oracle")"
> >>
> >> It is nearly all wrong.  I consider a graduation issue that we get
> >> this remedied.
> >>
> >> Would it make sense to harmonize the terms with the wiki?  Both allow
> >> user/non-committer contributions.
> >>
> >>
> >> -Rob
> >
> > Perhaps I'm mistaken - but - I thought it was rather decided to just let
> > the TOU continue pointing to the main website page, the idea being fix
> > it and cover the OO.o website site, forums and media wiki also.
> >
> 
> Are you not seeing what I'm seeing?  The TOU does not currently point
> to the main website page.
> 
> Go to the forum and look at the bottom of the page where it says "By
> any use of this Website, you agree to be bound by these Policies and
> Terms of Use".  Then click the link and read.
> 
> Continuing with what is there is entirely out of the question, right?
> It is Oracle's terms of use, assigning rights of the content to
> Oracle.
> 
> Please someone tell me that they are also seeing this.

Yes - it goes to the page on the website - a page I tried to get people
to look at for fixup months ago - but there was no interest in doing so
at the time, and yes as it stands it is just wrong.

So fix that page and the problem is gone isn't it.

I'm agreeing with you - it's time to fix it.

//drew

> 
> -Rob
> 
> 
> 
> > I suppose it's simply time now to actually re-write the TOU page on the
> > main website and reap the rewards for all three services.
> >
> > //drew
> >
> >
> >
> >
> >
>

Re: AOO 3.4 Impress not recognising Dual monitors?

Hi Rory,

  Could you please tell us how did you set the two monitors? I test Windows
XP and Mac on my laptop with projector connected, there is no problem and
will try Ubuntu later.

2012/7/4 Rory O'Farrell 

> I'm not yet in a position to raise a formal bug, but I would appreciate
> input from other users who may have occasion to use AOO 3.4 to give a
> presentation.
>
> I have not been able to get AOO 3:4 Impress to successfully recognise the
> second monitor on later *ubuntu systems (say 11:10 and later).
>
> I have requested information from others on the Forum in thread
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=10&t=54875
>
> I would welcome input from users from the Apache lists; I bring it to the
> attention of the ooo-dev list as some developer working on Impress may test
> this in passing.
>
>
> --
> Rory O'Farrell 
>



-- 


Thanks & Best Regards, Yan Ji

Re: [Review|Discussion]For Ideas and Comments on the Vision of Writer's Track Changes Improvement

Hi Dennis,I appreciate your questions,they are significant areas we have to
take carefully.Thanks.

On Wed, Jul 4, 2012 at 12:36 AM, Dennis E. Hamilton  wrote:

> I have questions about the way that the improvements are intended to be
> extensions to the ODF format.
>
> I understand from what is said that improvements are introduced into the
> ODF document in a way that they will be ignored by older implementations
> and other implementations that are unaware of them.  The intention is to
> map to and from .doc in a reliable manner.
>

 1. How are the extensions introduced such that conforming ODF consumers
> will ignore them properly?  Will users be able to turn off the improvements
> in order to produce conforming ODF documents?
>
> a)That's a good question.Because current ODF formats on Track Changes are
limited,that means only limited capabilities are able to be supported. In
order to achieve our goal to improve the fidelity with MS Word, we have to
extend Track Changes ODF formats and propose to OASIS ODF to become
standard at the end.Thus,the compatibility with previous releases will be a
challenging job.Our strategy is that the current import/export code logic
on Track Changes will be kept to ensure the same supported change records
defined in ODF 1.1/1.2 as before in our improved solution.If
possible,the extended
parts will be implemented with another code logic,not mixed, to ensure
these parts will not be recognized by previous releases.

b)And also,it seems a good idea to provide an option item in
"Tools->Options...->Writer->Compatibility" to turn on/off the
improvements.Thanks.


>  2. Will ignoring the extensions result in an usable conforming ODF
> document and will round-trip return to the producer of the extensions be
> tolerable.  Should there be warning when an user makes changes that rely on
> the improvements in a document that was not produced by an
> improvement-aware implementation?
>

c) We should avoid to generate un-usable ODF document,otherwise,the design
should have problem..
d) I don't think it necessary to give warning message to end users when
saving changes records with our improvements..I think it better for an
application to enable a mechanism to provide warning message to end users
when identifying un-recognized info.

>
>  3. How are the improvement extensions to the ODF format being made known
> so that other consumers of ODF can support them either partially or
> completely to provide a smoother experience in support of their users and
> in providing interoperability?
>

e)Finally,our improvements on the ODF formats on Track Changes will be
proposed and taken as OASIS ODF standards.


>
> -Original Message-
> From: chengjh [mailto:chen...@apache.org]
> Sent: Tuesday, July 03, 2012 00:25
> To: ooo-dev@incubator.apache.org; dennis.hamil...@acm.org
> Subject: Re: [Review|Discussion]For Ideas and Comments on the Vision of
> Writer's Track Changes Improvement
>
> Hi Dennis,
>
> Thanks for your feedback.Please say my a),b),c) and d).
>
> On Tue, Jul 3, 2012 at 12:16 PM, Dennis E. Hamilton <
> dennis.hamil...@acm.org
> > wrote:
>
> [ ... ]
>
> > Because of this, it is important to understand how your proposed Track
> > Changes Improvement will be reflect in the ODF 1.2 documents consumed and
> > produced by Apache OpenOffice at this time.  That is, what needs to be
> done
> > in the format, if anything, and how is interoperable communication of
> that
> > handled in the persistent document?
> >
>
> b) One of the significant principles of the improvement is to keep
> compatibility
>
> http://wiki.services.openoffice.org/wiki/Writer/ToDo/TrackChanges#Design_Principles
> with
> previous releases of AOO/Symphony in order to ensure the persistent
> document. The new formats saved in the improvement will be lost when being
> launched into old versions' AOO/Symphony.
>
> [ ... ]
>
>


-- 

Best Regards,Jianhong Cheng

Re: Terms of Service on Forums

On Tue, Jul 3, 2012 at 10:18 PM, drew jensen  wrote:
> On Tue, 2012-07-03 at 19:44 -0400, Rob Weir wrote:
>> Can someone take ownership of this issue?
>>
>> https://issues.apache.org/ooo/show_bug.cgi?id=118939
>>
>> Look at http://user.services.openoffice.org/en/forum/index.php
>>
>> Then to the footer and the "Policies and Terms of Use".
>>
>> This links to this page:  http://www.openoffice.org/terms_of_use
>>
>> That starts with "This Site and its contents are made available by
>> Oracle America, Inc. for and on behalf of itself and its subsidiaries
>> and affiliates under common control ("Oracle")"
>>
>> It is nearly all wrong.  I consider a graduation issue that we get
>> this remedied.
>>
>> Would it make sense to harmonize the terms with the wiki?  Both allow
>> user/non-committer contributions.
>>
>>
>> -Rob
>
> Perhaps I'm mistaken - but - I thought it was rather decided to just let
> the TOU continue pointing to the main website page, the idea being fix
> it and cover the OO.o website site, forums and media wiki also.
>

Are you not seeing what I'm seeing?  The TOU does not currently point
to the main website page.

Go to the forum and look at the bottom of the page where it says "By
any use of this Website, you agree to be bound by these Policies and
Terms of Use".  Then click the link and read.

Continuing with what is there is entirely out of the question, right?
It is Oracle's terms of use, assigning rights of the content to
Oracle.

Please someone tell me that they are also seeing this.

-Rob



> I suppose it's simply time now to actually re-write the TOU page on the
> main website and reap the rewards for all three services.
>
> //drew
>
>
>
>
>

Re: VBA

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

Hi Peng,

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

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

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

1 - Be sure to create dynamic reports.

2 - Base your report on a query.

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

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

//drew

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

Re: reset my password

2012-07-03 Thread hongyun . an

Dear Tony:

I have carefully reviewed the "people.apache.org".I have clicked the "Managing 
Your Details".
Following the instructions,I have made a FOAF file.However,I could not commit 
the FOAF file to the https://svn.apache.org/repos/private/committers/info 
because I forget my password and have no access right.
So I could not place a new file in my homedir.
Could you please help me to solve the problem?

Thank you very much.
Best wishes.


--
hongyun.an



thanks,Tony.

I am not sure that I get your meaning.I opened the "people.apache.org",then 
went to the "http://people.apache.org/foaf/index.html";
and "http://people.apache.org/foaf/foafamatic.html".I created a file named 
"hyan.rdf",with the content:

http://www.w3.org/1999/02/22-rdf-syntax-ns#";
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#";
  xmlns:foaf="http://xmlns.com/foaf/0.1/";
  xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#";
  xmlns:pm="http://www.web-semantics.org/ns/pm#";
  xmlns:wot="http://xmlns.com/wot/0.1/";
  xmlns:rss="http://purl.org/rss/1.0/";
  xmlns:dc="http://purl.org/dc/elements/1.1/";
  xmlns:ical="http://www.w3.org/2002/12/cal/ical#";
  xmlns:doap="http://usefulinc.com/ns/doap#";>

Hong Yun An
Hong Yun
An
mailto:hongyun...@cs2c.com.cn"/>
mailto:an_hong...@hotmail.com"/>


But I cound not creat a foat file.
Could you please give me some direction?
thank you very much.
best wishes.

--
hongyun.an
>Can you still login to people.apache.org ? If so can you place a new
>file in your homedir, with your new email address and then let us know
>what that is. 
>
>
>
>hongyun.an wrote on Fri, Jun 29, 2012 at 03:07:38PM +0800:
>> 
>> Dear Tony:
>> Unluckly it is.I have changed email address without updating my records.
>> My ID id hyan.The invalid email address is "anhong...@redoffice.com.cn".
>> Could you tell me how to verify my identity in detail?
>> 
>> Thank you very much. 
>> 
>> Best wishes.
>> 
>> --
>> hongyun.an
>> >Hi, 
>> >
>> >Please use httpsd://id.apache.org  - 
>> >
>> >If you have changed your email address without updating your records  
>> >here, then you will not be able to complete the password reset steps.
>> >
>> >If this is the case, we will need to try and verify your identity
>> >another way.
>> >
>> > 
>> >hongyun.an wrote on Fri, Jun 29, 2012 at 09:42:20AM +0800:
>> >> hello:
>> >>  I am the Apache committer,my ID is hyan.Now I have forgotten my password.
>> >> Could you help me to reset the password?
>> >> Now my email is :hongyun...@cs2c.com.cn
>> >> 
>> >> thank you very much!
>> >> best wishes. 
>> >> 
>> >> 
>> >> 
>> >> 
>> >> --
>> >> hongyun.an
>> >
>> >-- 
>> >Cheers,
>> >Tony
>> >
>> >---
>> >Tony Stevenson
>> >
>> >t...@pc-tony.com // pct...@apache.org // t...@caret.cam.ac.uk
>> >GPG: 1024D/51047D66
>> >http://www.pc-tony.com
>> >---
>> >
>> >
>
>-- 
>Cheers,
>Tony
>
>---
>Tony Stevenson
>
>t...@pc-tony.com // pct...@apache.org // t...@caret.cam.ac.uk
>GPG: 1024D/51047D66
>http://www.pc-tony.com
>---
>
>

Re: Terms of Service on Forums

2012-07-03 Thread drew jensen

On Tue, 2012-07-03 at 19:44 -0400, Rob Weir wrote:
> Can someone take ownership of this issue?
> 
> https://issues.apache.org/ooo/show_bug.cgi?id=118939
> 
> Look at http://user.services.openoffice.org/en/forum/index.php
> 
> Then to the footer and the "Policies and Terms of Use".
> 
> This links to this page:  http://www.openoffice.org/terms_of_use
> 
> That starts with "This Site and its contents are made available by
> Oracle America, Inc. for and on behalf of itself and its subsidiaries
> and affiliates under common control ("Oracle")"
> 
> It is nearly all wrong.  I consider a graduation issue that we get
> this remedied.
> 
> Would it make sense to harmonize the terms with the wiki?  Both allow
> user/non-committer contributions.
> 
> 
> -Rob

Perhaps I'm mistaken - but - I thought it was rather decided to just let
the TOU continue pointing to the main website page, the idea being fix
it and cover the OO.o website site, forums and media wiki also.

I suppose it's simply time now to actually re-write the TOU page on the
main website and reap the rewards for all three services.

//drew

Re: Terms of Service on Forums

On Tue, Jul 3, 2012 at 8:23 PM, Kay Schenk  wrote:
> On Tue, Jul 3, 2012 at 4:44 PM, Rob Weir  wrote:
>
>> Can someone take ownership of this issue?
>>
>> https://issues.apache.org/ooo/show_bug.cgi?id=118939
>>
>> Look at http://user.services.openoffice.org/en/forum/index.php
>>
>> Then to the footer and the "Policies and Terms of Use".
>>
>> This links to this page:  http://www.openoffice.org/terms_of_use
>>
>> That starts with "This Site and its contents are made available by
>> Oracle America, Inc. for and on behalf of itself and its subsidiaries
>> and affiliates under common control ("Oracle")"
>>
>> It is nearly all wrong.  I consider a graduation issue that we get
>> this remedied.
>>
>> Would it make sense to harmonize the terms with the wiki?  Both allow
>> user/non-committer contributions.
>>
>>
>> -Rob
>>
>
> Yes, when Dave pointed this out the other day, I saw this as well.
>
> We need to correct this page at least, and it would make perfect sense to
> me to use these  terms for the wiki, the forums, and our main web site,
> www.openoffice.org, as well.
>
> I brought this up a few days ago but no reply to that.
>
> Re the web site -- these terms seemed to be adequate for Sun and for Oracle
> so why not us? But, it would probably be best to continue the web site
> discussion on the previous thread --
> [DISCUSSION] (Re)use of Website Content
>

I'd keep the reuse issue separate.  We're here to publish software.
Creating a reusable website is nice, but not our primary purpose.  We
just need a basic terms of service that covers things like:


1) Privacy policy, including required notices for our use of Google Analytics

2) Statement that the user agrees to post only content that they own

3) Statement that user agrees to have their content hosted on the website

We can go beyond that in terms of an outgoing license if we really
wanted to, but it is not strictly necessary.  And the fact we haven't
managed to do that in over a year makes me think that keeping it
basic, but accurate, is the most direct approach.

Suggested quick fix:

1) Remove the Oracle terms from the Forum

2) Make the current link in the forum footer point to this page:
http://user.services.openoffice.org/en/forum/ucp.php?mode=terms

3) Make this page also include the content from the privacy policy
here:  http://www.openoffice.org/privacy.html  (or link to it)

4) Ensure that the other NL forums either point to the same terms, or
an accurate translation.

5) (Future) If someone wants to have an outgoing license then they
should make a proposal and start a discussion on the forums about
that.

My two cents.

-Rob

> --
> 
> MzK
>
> "I would rather have a donkey that takes me there
>  than a horse that will not fare."
>   -- Portuguese proverb

Re: VBA

2012-07-03 Thread Chen Peng

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



2012/7/4 Stefan Lindel 

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

Re: Terms of Service on Forums

On Tue, Jul 3, 2012 at 8:09 PM, imacat  wrote:
> The terms of usage on forum is actually at:
>
> http://user.services.openoffice.org/en/forum/ucp.php?mode=terms
>

So we are pointing to two different terms of use pages on the same
forum?  Even the page you point to has the other terms page linked in
its header.

> There seems to be no terms of usage o wiki.
>
> It is outdated, but it does not contain any "Oracle" blah blah blah.
>
> Do we need lawer review for our updated forum term of usage?
>

I think any lawyer would first tell us to pick a single terms of use
statement ;-)

> On 2012/07/04 07:44, Rob Weir said:
>> Can someone take ownership of this issue?
>>
>> https://issues.apache.org/ooo/show_bug.cgi?id=118939
>>
>> Look at http://user.services.openoffice.org/en/forum/index.php
>>
>> Then to the footer and the "Policies and Terms of Use".
>>
>> This links to this page:  http://www.openoffice.org/terms_of_use
>>
>> That starts with "This Site and its contents are made available by
>> Oracle America, Inc. for and on behalf of itself and its subsidiaries
>> and affiliates under common control ("Oracle")"
>>
>> It is nearly all wrong.  I consider a graduation issue that we get
>> this remedied.
>>
>> Would it make sense to harmonize the terms with the wiki?  Both allow
>> user/non-committer contributions.
>>
>>
>> -Rob
>
>
> --
> Best regards,
> imacat ^_*' 
> PGP Key http://www.imacat.idv.tw/me/pgpkey.asc
>
> <> News: http://www.wov.idv.tw/
> Tavern IMACAT's http://www.imacat.idv.tw/
> Woman in FOSS in Taiwan http://wofoss.blogspot.com/
> Apache OpenOffice http://www.openoffice.org/
> EducOO/OOo4Kids Taiwan http://www.educoo.tw/
>

回复: Re: Open the UOF2.0 source codes

2012-07-03 Thread hongyun . an

Thank you ,Donald.
Sorry for my delay because my short vacation.
I am very glad to contribute my effort on the project.

best wishes. 

--
hongyun.an
>On Thu, Jun 28, 2012 at 7:49 PM, hongyun.an  wrote:
>
>> Dear everyone:
>>
>> Thanks to all your help,so far I have finished merging the UOF v2.0 source
>> code to the Aoo3.4(svn version1354914) both on the Windows and Linux.
>>
>
>This is great news! Thank you Hongyun.  (Forgive the delay, I am a little
>slow catching up on emails due to travels)
>
>Today, I delivered a presentation on Apache OpenOffice here in Beijing at
>the Open Source China Open Source World Summit conference where I made a
>special point to recognize the achievements of CS2C and your work. I was
>fortunate to meet your colleagues Michael Lee and Shi Zhoubo. We discussed
>a variety of topics concerning the project and how we can improve
>participation and awareness of Apache OpenOffice in China. I hope that
>Michael introduces himself soon on this list.
>
>
>
>> The source code is 33 files and about 2M，mainly in
>> filter/source/config,filter/source/xmlfilterdetect,
>> filter/source/xsltfilter，scp2/source/ooo.
>> Now it can work very well in sw,sc,sd. It could load as the uof v2.0
>> format files(uot,uos,uop),also could open them.
>>
>> thank you,Dennis.
>> But I have forgotten my password.
>> I go to the  and enter my ID number,then click the
>> "Forgot your password".
>> In the new window I enter my ID in the frame which is like this "Apache
>> User ID:___...@apache.org",
>> With that I get the message "Email sent,Message-ID=<
>> 20120628100728.462c...@id.apache.org".
>> I don't know whether I have the apache.org email and I could not log in
>> this email.
>> Could you tell me how to reset my password?
>>
>> Another question: could I commit the source code to the Aoo3.4 trunk?
>>
>> best wishes!
>> --
>> hongyun.an
>> >@hongyun.an
>> >
>> >Yes, you are Apache committer hyan@ a.o.
>> >
>> >You may be required to reset your password in order to make commits to
>> SVN.  There was a general requirement to change passwords as the result of
>> a recent security issue.  Simply go to  and follow
>> the change-password procedure.
>> >
>> >You may want to update your e-mail forwarding for hyan@ at the same time
>> if you have not already done so.
>> >
>> >+1 for how you propose to account for the approach and then carry it out.
>> >
>> > - Dennis
>> >
>> >PS: Ensure that the SVN-client configuration options specify UTF-8
>> encoding on the committed files, assuming that is needed for the
>> Chinese-language characters included in XML NCNames and their counterparts
>> in the UOF source code.  There may also need to be some experimentation to
>> ensure that any use of Chinese-language characters in source code work
>> through all of the build cases.  I recommend subversion configuration file
>> entries along the following lines:
>> >
>> >   *.html = svn:mime-type=text/html;;charset=UTF-8
>> >   *.htm = svn:mime-type=text/html;;charset=UTF-8
>> >   *.xml = svn:mime-type=application/xml;;charset=UTF-8
>> >   *.c = svn:mime-type=text/plain;;charset=UTF-8;svn:eol-style=native
>> >   *.cpp = svn:mime-type=text/plain;;charset=UTF-8;svn:eol-style=native
>> >
>> >(I have not tried the combination of svn:mime-type and svn:eol-style.
>>  Experiment is required.)
>> >
>> >
>> >
>> >-Original Message-
>> >From: hongyun.an [mailto:hongyun...@cs2c.com.cn]
>> >Sent: Monday, June 11, 2012 05:38
>> >To: ooo-dev
>> >Subject: Re: Re: Open the UOF2.0 source codes
>> >
>> >
>> >The size of the source code is about 2M,30 files.
>> >As far as I know, I have the  the commit right in  incubator ooo Project.
>> >According to your suggestions,I think we should do two things firstly:
>> >1:Check whether  the code could work in Aoo3.4 based on the Windows and
>> Linux.
>> >2:Introduce the work we have done on wiki
>> http://wiki.services.openoffice.org/wiki/Documentation.
>> >As soon as I complete these works ,I will message to the mail list.
>> >
>> >Thank you.
>> >best wishes.
>> >
>> >--
>> >hongyun.an
>> >>On Mon, Jun 11, 2012 at 1:44 AM, Pedro Giffuni  wrote:
>> >>>
>> >>>
>> >>> --- Lun 11/6/12, hongyun.an  ha scritto:
>> >>> ...
>>  Data: Lunedì 11 giugno 2012, 00:20
>>  You are welcome.We hope it will be
>>  more compatible between the ODF and UOF2.0.
>>  Could anybody tell me how submit the code?
>>  --
>> >>>
>> >>> I guess it depends on the size. One option
>> >>> would be to put up a tarball somewhere, but
>> >>> perhaps its better to create a branch in SVN.
>> >>>
>> >>
>> >>The UOF support is in 30 files, mainly in filter/source/config,
>> >>filter/source/xmlfilterdetect, filter/source/xsltfilter
>> >>
>> >>If a committer can verify that it works, it should be small enough to
>> >>check into the trunk.
>> >>
>> >>Some test documents would help as well.
>> >>
>> >>-Rob
>> >>
>> >>> It would be

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

2012-07-03 Thread Chen Peng

Comparing with xls-file, we lost VBA attributes when importing.
In xls-file, VBA macro is comprised by the source in IDE and related VBA
attributes.
We can't get the attributes from IDE in ods-file, we just can get the
source from IDE in ods-file.
Without those attributes we can't write the macro back to xls-file.

2012/7/3 Regina Henschel 

> Hi,
>
> chengjh schrieb:
>
> Hi Peng,
>>
>> Let me use a scenario to confirm your problem,solution and
>> question..Anything misunderstood,please correct me.thanks.
>>
>> Problem:
>> When AOO launches an excel document with VBA,saves to ods and then saves
>> to
>> excel again,the VBA info will be lost.
>>
>> Solution:
>> a)The VBA streams of an excel document will be saved into the ods document
>> with binary format when converting an excel document to an ods document in
>> AOO Spreadsheet with certain controller.
>> b)Once the ods document containing the binary VBA streams is launched into
>> AOO or previous releases,with certain controller,the binary VBA steams
>> will
>> be loaded[still binary stream in memory] or rejected..There is no any
>> impact on the application,the application can still work well.
>> c)Based on b),if the ods document is saved to an excel document,the binary
>> VBA streams will be exported, thus, the VBA info will not be lost.
>>
>
> I do not like the idea, that a binary code which I do not know what it
> does, will be shipped together with an ods-file. Because the source it
> editable in the IDE, the source and the binary might differ. The binary can
> be dangerous although the source looks harmless. I consider this a security
> problem.
>
> Currently the macro is lost, although the source is in the ods-file and
> commented as VBA macro. Isn't it possible, to write the macro back to
> xsl-file from this source?
>
> Kind regards
> Regina
>
>
>
>> Question:
>> You are not sure whether this solution is reasonable. So, you want to know
>> the comments about your solution. If no comments, you will do so to
>> implement it.
>>
>> On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng  wrote:
>>
>> Hi All,
>>>My name is Chen Peng, I am a developer from Symphony. My special
>>> areas are VBA and sw.
>>>Now I found an issue about macros lost:
>>>   I saved an excel file with VBA to spreadsheet, the VBA can work
>>> well in spreadsheet, then I wanted to save this spreadsheet back to
>>> excel,
>>> but all the macros are lost.
>>>I propose to save the binary data of excel VBA to spreadsheet,
>>> when
>>> saving excel to spreadsheet, then we can get the binary data from
>>> spreadsheet if need to save the spreadsheet to excel again.
>>>The binary data will not impact the open/save... of the ODF format
>>> application, it will not be touched when we operate the ODF formant
>>> applications. The binary data will be just used when we want to save the
>>> spreadsheet to excel, it is just a data prestore about saving spreadsheet
>>> macros to excel.
>>> Can you give some advice about the solution?
>>> Any feedback will be preciated, thanks.
>>>
>>>
>>
>>
>>
>
>

Re: Terms of Service on Forums

On Tue, Jul 3, 2012 at 4:44 PM, Rob Weir  wrote:

> Can someone take ownership of this issue?
>
> https://issues.apache.org/ooo/show_bug.cgi?id=118939
>
> Look at http://user.services.openoffice.org/en/forum/index.php
>
> Then to the footer and the "Policies and Terms of Use".
>
> This links to this page:  http://www.openoffice.org/terms_of_use
>
> That starts with "This Site and its contents are made available by
> Oracle America, Inc. for and on behalf of itself and its subsidiaries
> and affiliates under common control ("Oracle")"
>
> It is nearly all wrong.  I consider a graduation issue that we get
> this remedied.
>
> Would it make sense to harmonize the terms with the wiki?  Both allow
> user/non-committer contributions.
>
>
> -Rob
>

Yes, when Dave pointed this out the other day, I saw this as well.

We need to correct this page at least, and it would make perfect sense to
me to use these  terms for the wiki, the forums, and our main web site,
www.openoffice.org, as well.

I brought this up a few days ago but no reply to that.

Re the web site -- these terms seemed to be adequate for Sun and for Oracle
so why not us? But, it would probably be best to continue the web site
discussion on the previous thread --
[DISCUSSION] (Re)use of Website Content

-- 

MzK

"I would rather have a donkey that takes me there
 than a horse that will not fare."
  -- Portuguese proverb

Re: Terms of Service on Forums

2012-07-03 Thread imacat

The terms of usage on forum is actually at:

http://user.services.openoffice.org/en/forum/ucp.php?mode=terms

There seems to be no terms of usage o wiki.

It is outdated, but it does not contain any "Oracle" blah blah blah.

Do we need lawer review for our updated forum term of usage?

On 2012/07/04 07:44, Rob Weir said:
> Can someone take ownership of this issue?
> 
> https://issues.apache.org/ooo/show_bug.cgi?id=118939
> 
> Look at http://user.services.openoffice.org/en/forum/index.php
> 
> Then to the footer and the "Policies and Terms of Use".
> 
> This links to this page:  http://www.openoffice.org/terms_of_use
> 
> That starts with "This Site and its contents are made available by
> Oracle America, Inc. for and on behalf of itself and its subsidiaries
> and affiliates under common control ("Oracle")"
> 
> It is nearly all wrong.  I consider a graduation issue that we get
> this remedied.
> 
> Would it make sense to harmonize the terms with the wiki?  Both allow
> user/non-committer contributions.
> 
> 
> -Rob


-- 
Best regards,
imacat ^_*' 
PGP Key http://www.imacat.idv.tw/me/pgpkey.asc

<> News: http://www.wov.idv.tw/
Tavern IMACAT's http://www.imacat.idv.tw/
Woman in FOSS in Taiwan http://wofoss.blogspot.com/
Apache OpenOffice http://www.openoffice.org/
EducOO/OOo4Kids Taiwan http://www.educoo.tw/



signature.asc
Description: OpenPGP digital signature

Terms of Service on Forums

Can someone take ownership of this issue?

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

Look at http://user.services.openoffice.org/en/forum/index.php

Then to the footer and the "Policies and Terms of Use".

This links to this page:  http://www.openoffice.org/terms_of_use

That starts with "This Site and its contents are made available by
Oracle America, Inc. for and on behalf of itself and its subsidiaries
and affiliates under common control ("Oracle")"

It is nearly all wrong.  I consider a graduation issue that we get
this remedied.

Would it make sense to harmonize the terms with the wiki?  Both allow
user/non-committer contributions.


-Rob

Re: problem

2012-07-03 Thread imacat

On 2012/07/04 02:11, Annmarie Schroden said:
> hello, I have a little problem went I shut down my computer and I bring it up 
> again
> open office open with out me clicking on the icon how do I get it to stop 
> open up.
> did I install it wrongplease help 

This issue will be fixed when you upgraded to OpenOffice 3.4.1.

-- 
Best regards,
imacat ^_*' 
PGP Key http://www.imacat.idv.tw/me/pgpkey.asc

<> News: http://www.wov.idv.tw/
Tavern IMACAT's http://www.imacat.idv.tw/
Woman in FOSS in Taiwan http://wofoss.blogspot.com/
Apache OpenOffice http://www.openoffice.org/
EducOO/OOo4Kids Taiwan http://www.educoo.tw/



signature.asc
Description: OpenPGP digital signature

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Dave Fisher


On Jul 3, 2012, at 10:19 AM, Simon Phipps wrote:

> On Tue, Jul 3, 2012 at 4:22 PM, Pedro Giffuni  wrote:
> 
>> 
>> 
>> --- Mar 3/7/12, Simon Phipps  ha scritto:
>> ...
>>> 
>>> On 3 Jul 2012, at 15:29, Pedro Giffuni wrote:
>>> 
 
 --- Mar 3/7/12, Simon Phipps 
>>> ha scritto:
 ...
> 
> Please can we have an update on that effort to get
>>> all the
> CWS made available then? It seems a perfectly
>>> reasonable
> request, one I and others have been making here
>>> since the
> inception of the project and one I am not able to
>>> go
> negotiate personally so need to keep asking about
>>> here.
> 
 
 What effort?
>>> 
>>> Mentioned in an e-mail linked from the OP, dated June 7,
>>> 2011 - those of us inside the project have been raising this
>>> topic from very early on, as you can see. Making it easy for
>>> outside developers to meet their needs is a great way to
>>> have them begin to join in and become insiders like you.
>>> 
>>> The message is at
>> http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3c4dee6c86.5070...@oracle.com%3E
>>> 
>>> S.
>> 
>> OK. I think that in that mail message "we" stands for Oracle,
>> not for Apache, so you'd have to ask Andrew Rist with his
>> Oracle hat.
>> 
> 
> OK, thanks.
> 
> Andrew, do you have an update on the outcome of your assertion "We are
> trying to provide all of the Oracle owned content in the OOo repositories"
> (this was in the context of the CWSs) please?

Please do be patient when waiting for a response, tomorrow is a holiday you may 
remember - US Independence Day. It's on a Wednesday and many people are taking 
time off this week. While the weather in most of the US is atrociously hot, it 
is absolutely perfect here on the Pacific Coast.

Regards,
Dave


> 
> Cheers!
> 
> S.

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Roberto Salomon

Suggestions for pt_BR made on pootle.

-- 
Roberto Salomon
http://rfsalomon.blogspot.com.br/

Re: Crazy idea: Use Google to translate website

2012-07-03 Thread Andrea Pescetti


Dave Fisher wrote:

(A) Apache CMS - Web Content is Edited  / Website's built. ...
(B) CMS to Pootle process ...
(C) Pootle Apache Instance ...
(D) Pootle to CMS process


Note that there exists a tool named GNUN
http://www.gnu.org/software/gnun/
which does a nice job in keeping website translations up-to-date through 
PO files (or Pootle), even though it relies on several server-side 
assumptions and it would have problems in handling the current diversity 
of NL pages.


You guessed it, it's GPL, which can be a feature or a bug according to 
one's individual philosophy... but it's free software anyway, and at 
least it's worth a look before implementing something similar.


Regards,
  Andrea.

Re: [RELEASE][3.4.1]: Preparing release notes

Am Dienstag, 3. Juli 2012 um 20:25 schrieb Kay Schenk:
> On Mon, Jul 2, 2012 at 1:09 AM, Jürgen Schmidt
> wrote:
>  
> > Hi,
> >  
> > ok AOO 3.4.1 won't be a feature release but nevertheless I think we
> > should prepare release notes to give a user friendly overview of what is
> > going into our upcoming 3.4.1 release.
> >  
> > I have created a new (more or less empty) wiki page to start working on
> > the release notes for 3.4.1.
> >  
> >  
> > https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+3.4.1+Release+Notes
> >  
> > The following query list all fixed blocker issues for 3.4.1 and can be
> > used as input for the release notes.
> >  
> > Any volunteers who are interested to start working on it?
> >  
> > Juergen
>  
> I can help with this after next week -- after Jul 14. Hopefully that's not
> too late.
>  
>  

Perfect and no it is not too late, we plan to release at the end of July. We 
should try to find a way to create release notes in the future in parallel to 
our development work and have them more or less ready automatically ;-)

Juergen  
>  
> --  
> 
> MzK
>  
> "I would rather have a donkey that takes me there
> than a horse that will not fare."
> -- Portuguese proverb
>  
>

Re: Crazy idea: Use Google to translate website

On Tue, Jul 3, 2012 at 1:23 PM, Dave Fisher  wrote:

>
> On Jul 2, 2012, at 5:49 PM, Rob Weir wrote:
>
> > On Mon, Jul 2, 2012 at 7:18 PM, Dave Fisher 
> wrote:
> >> Sorry for the top post. I like where this is going. A lot of
> interesting ideas.
> >>
> >> I have one major concern. How do we manage the human created content as
> people replace and/or edit the translations. What happens when the original
> English (or French) page is changed? To me we are really discussing
> managing Markdown text. If the names of files are like:
> >>
> >> index.mdtext
> >> index.en-GB.mdtext
> >> index.fr.mdtext
> >>
>
> Prefacing my remarks with a general agreement to your ideas, but with
> exceptions that we should consider.
>
> >
> > Wouldn't you say that 99% of the website is HTML and Wiki Text today?
> > There is very little Markdown in use outside of the Podling project
> > pages.
>
> Yes, that is true. However all the markdown created will be AL2 licensed
> while the html is mostly something from the TermsOfUse that was discussed
> in a different thread.
>
> If you are concerned with a clear IP trail, and I know you are, then we
> should proceed with Markdown and select HTML.
>
> >
> > In any case, it should be possible to use Pootle for this, just as we
> > manage changing product strings and updating those.
> >
> > There are a good number of convertors for getting to/from Pootle
> > format:  http://translate.sourceforge.net/wiki/toolkit/index
> >
> > Note html2po.
> >
> > I bet writing mdtext2po (and the inverse) would be possible.
> >
> > If we used Pootle for this, we'd need to define some sort of schedule,
> > since it is not really a "release" in the traditional sense.  But you
> > could imagine every month or so, doing a cycle of:
> >
> > 1) html2po and mdtext2po
> >
> > 2) Load into Pootle
> >
> > 3) Volunteers translate
> >
> > 4) At specified time run po2html and po2mdtext
> >
> > 5) check in the new website files
>
> This can work for content that does not a quick response. Other files like
> announcements and various news sources require a more immediate approach.
> This same goal is the initial goal of the Apache CMS. It is to eliminate
> extraneous process.
>
> I think that process for translations is good and you provide one that
> will work for most content.
>
> I would add that the branding and navigation (but not the footer) markdown
> / ssi's would benefit from this approach.
>
> >
> >> We'll have some type of Apache CMS magic that can handle translated SSI
> elements. I need to write Joe / infra-dev an email...
> >>
> >> Then if we can tie together the CMS to take translations and somehow
> inform either or both the human and/or the tool translators when changes
> occur in other languages ... svn diff can be used... assuming that...
> >>
> >
> > The issue is the average translator is not an markup (or markdown)
> > person.  They use Pootle or similar tools that facilitate translation.
> > What do we need to be translator-friendly?  Consistency between how
> > we translate UI and webpages might help.
>
> What we are targeting here is the NL user who notices a problem with a
> translation and wants to help. These people may find Pootle to be any more
> usual than HTML.
>
> Let's not let a Pootle "all encompassing" process break the ability of
> committers and contributors to make ad hoc contributions. If the tool you
> describe is built then it should certainly carry some svn tags so that
> merges of updated content from pootle don't overwrite any CMS based
> contributions that have been made in the interim. These will be merge
> conflicts.
>
> As long as your process includes (1) every time then there isn't a problem
> with that. However that won't work because the translations in Pootle are
> where the bulk of the work occurs.
>
> I think there are benefits to both the CMS and the Pootle approaches, more
> thought will need to go into the timeline and how to fully leverage the
> human element between the project's base content, NL users and L10N
> Translators. As always our goal is to allow more and more of the community
> to be able to easily contribute.
>
> Let's divide up the process as follows. I'm adding the notion of a string
> table which could be implemented as a file for each language with:
>
> string.mdtext
> homepage: home
>
> string.fr.mdtext
> homepage: maison
>
> string.en-GB.mdtext
> homepage: home
>
> string.it.mdtext
> homepage: casa
>
> (A) Apache CMS - Web Content is Edited  / Website's built.
> Some changes will be via string (sledgehammer ... ) and others by
> content page.
>
> (My outline)
>
> (B) CMS to Pootle process
>
> > 1) html2po and mdtext2po
>
> Keep an index of the files included in this set. Perhaps use an
> attribute (mdtext) or metatag (html) to self identify translatable files.
> (footer.mdtext must remain in English since it has legal
> implications and translators are unlikely to be IP lawyers.)
>
> > 2) Load into Pootle
>
>
>

VBA

2012-07-03 Thread Stefan Lindel


I want open a Report and change the filter dynamicly

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


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

mfg

Stefan

Re: Crazy idea: Use Google to translate website

2012-07-03 Thread Dave Fisher

On Jul 2, 2012, at 5:49 PM, Rob Weir wrote:

> On Mon, Jul 2, 2012 at 7:18 PM, Dave Fisher  wrote:
>> Sorry for the top post. I like where this is going. A lot of interesting 
>> ideas.
>> 
>> I have one major concern. How do we manage the human created content as 
>> people replace and/or edit the translations. What happens when the original 
>> English (or French) page is changed? To me we are really discussing managing 
>> Markdown text. If the names of files are like:
>> 
>> index.mdtext
>> index.en-GB.mdtext
>> index.fr.mdtext
>> 

Prefacing my remarks with a general agreement to your ideas, but with 
exceptions that we should consider.

> 
> Wouldn't you say that 99% of the website is HTML and Wiki Text today?
> There is very little Markdown in use outside of the Podling project
> pages.

Yes, that is true. However all the markdown created will be AL2 licensed while 
the html is mostly something from the TermsOfUse that was discussed in a 
different thread.

If you are concerned with a clear IP trail, and I know you are, then we should 
proceed with Markdown and select HTML.

> 
> In any case, it should be possible to use Pootle for this, just as we
> manage changing product strings and updating those.
> 
> There are a good number of convertors for getting to/from Pootle
> format:  http://translate.sourceforge.net/wiki/toolkit/index
> 
> Note html2po.
> 
> I bet writing mdtext2po (and the inverse) would be possible.
> 
> If we used Pootle for this, we'd need to define some sort of schedule,
> since it is not really a "release" in the traditional sense.  But you
> could imagine every month or so, doing a cycle of:
> 
> 1) html2po and mdtext2po
> 
> 2) Load into Pootle
> 
> 3) Volunteers translate
> 
> 4) At specified time run po2html and po2mdtext
> 
> 5) check in the new website files

This can work for content that does not a quick response. Other files like 
announcements and various news sources require a more immediate approach. This 
same goal is the initial goal of the Apache CMS. It is to eliminate extraneous 
process.

I think that process for translations is good and you provide one that will 
work for most content.

I would add that the branding and navigation (but not the footer) markdown / 
ssi's would benefit from this approach.

> 
>> We'll have some type of Apache CMS magic that can handle translated SSI 
>> elements. I need to write Joe / infra-dev an email...
>> 
>> Then if we can tie together the CMS to take translations and somehow inform 
>> either or both the human and/or the tool translators when changes occur in 
>> other languages ... svn diff can be used... assuming that...
>> 
> 
> The issue is the average translator is not an markup (or markdown)
> person.  They use Pootle or similar tools that facilitate translation.
> What do we need to be translator-friendly?  Consistency between how
> we translate UI and webpages might help.

What we are targeting here is the NL user who notices a problem with a 
translation and wants to help. These people may find Pootle to be any more 
usual than HTML.

Let's not let a Pootle "all encompassing" process break the ability of 
committers and contributors to make ad hoc contributions. If the tool you 
describe is built then it should certainly carry some svn tags so that merges 
of updated content from pootle don't overwrite any CMS based contributions that 
have been made in the interim. These will be merge conflicts.

As long as your process includes (1) every time then there isn't a problem with 
that. However that won't work because the translations in Pootle are where the 
bulk of the work occurs.

I think there are benefits to both the CMS and the Pootle approaches, more 
thought will need to go into the timeline and how to fully leverage the human 
element between the project's base content, NL users and L10N Translators. As 
always our goal is to allow more and more of the community to be able to easily 
contribute.

Let's divide up the process as follows. I'm adding the notion of a string table 
which could be implemented as a file for each language with:

string.mdtext
homepage: home

string.fr.mdtext
homepage: maison

string.en-GB.mdtext
homepage: home

string.it.mdtext
homepage: casa

(A) Apache CMS - Web Content is Edited  / Website's built.
Some changes will be via string (sledgehammer ... ) and others by 
content page.

(My outline)

(B) CMS to Pootle process

> 1) html2po and mdtext2po

Keep an index of the files included in this set. Perhaps use an 
attribute (mdtext) or metatag (html) to self identify translatable files.
(footer.mdtext must remain in English since it has legal implications 
and translators are unlikely to be IP lawyers.)

> 2) Load into Pootle

Include string table changes made through CMS.
During load handle any differences caused by conflicts between changes 
made in (C) since the last (D)

(C) Pootle Apache Instance

> 3) Volunteers translate

Committe

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Serg Bormant

Hi,

2012/7/3 Jürgen Schmidt :
>
> I have updated the Pootle server already with the new string (17 words
> only) and I would like to ask our translators to focus on this new
> string as soon as possible (ideally this week).
>
> To simplify the update I would prefer if the string get translated on
> the Pootle server.
>
> Please send me a short note when an updated or better a translation of
> the string is available. I will take care of the integration.

I left suggestion for Russian on Pootle:
You have another instance running in a different terminal session.
Close that instance and then try again.
В другом терминальном сеансе запущена копия приложения. Закройте её и
повторите попытку.

> If anybody have problems doing it on Pootle please let me know.
I have no login on Pootle (ICLA was signed, sent, and filed).

-- 
wbr, sb

Re: problem

2012-07-03 Thread Andrea Pescetti


Rob Weir wrote:

On Tue, Jul 3, 2012 at 2:11 PM, Annmarie Schroden

hello, I have a little problem went I shut down my computer and I bring it up 
again
open office open with out me clicking on the icon how do I get it to stop open 
up.
did I install it wrongplease help

Any idea what is going on here?  This seems to be something more than
the QuickStarter icon in the task bar.


I'd say it is one of the many ways to describe this bug, already fixed 
for OpenOffice 3.4.1:

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

A possible workaround, in the meantime, is described in comment 15 in 
that issue (option 3, disable Quickstart).


Regards,
  Andrea.

Re: problem

On Tue, Jul 3, 2012 at 2:11 PM, Annmarie Schroden
 wrote:
> hello, I have a little problem went I shut down my computer and I bring it up 
> again
> open office open with out me clicking on the icon how do I get it to stop 
> open up.
> did I install it wrongplease help

Any idea what is going on here?  This seems to be something more than
the QuickStarter icon in the task bar.

Although I have not seen this in any clean install or any upgrade
install under controlled conditions, I did see this once in a "dirty"
upgrade of a pre-RC version of 3.4.0.  At boot time (this was on
Windows XP) the full OpenOffice launcher would load and display, not
just QuickStart.

Has anyone able to reproduce this kind of error?

-Rob

Re: CMS anonymous user improvements

On Tue, Jul 3, 2012 at 7:08 AM, Rob Weir  wrote:

> On Mon, Jul 2, 2012 at 6:53 PM, Kay Schenk  wrote:
> > On Mon, Jul 2, 2012 at 2:41 PM, Rob Weir  wrote:
> >
> >> On Sun, Jun 24, 2012 at 8:47 AM, Joe Schaefer 
> >> wrote:
> >> > This weekend David Blevins and I worked on streamlining
> >> > the anonymous user support in the CMS.  Two major improvements
> >> > are the introduction of "Quick Mail" and anonymous clones.
> >> >
> >> > Quick Mail is the analog of Quick Commit but for anonymous
> >> > users- it is enabled by default and makes submitting patches
> >> > to the mailing list much easier to execute.  The mailout will
> >> > contain a url for committers to use that permits a committer
> >> > to clone the working copy of the anonymous user, so all you'd
> >> > need to do is review the change in the CMS and commit it.
> >> >
> >> > Would be nice if Rob or someone created a video tutorial for this
> >> > that's geared toward anon users and showed off these new features.
> >>
> >> http://www.youtube.com/watch?v=7fvg1pfHLhE
> >>
> >> >
> >>
> >
> > Hi Rob --
> >
> > I couldn't read this one as clearly as your first. You used some sort of
> > zoom mechanism on the first one I think, and also there seemed to be some
> > text annotations on the first one with actual bookmarlet URL that this
> one
> > doesn't have.
> >
>
> I'm still learning the tool (Camtasia)  It looks like if you do the
> original recording at a higher resolution than the output resolution
> then you can tell it to automatically zoom in to area where your mouse
> is.  But in this case my recording resolution is the same as the
> output resolution, so no zooming is possible.
>
> But I can add text annotations, arrows, etc.
>
> -Rob
>

Text annotations would help I think. This video is really quite a different
experience for me than your first -- I can't say why.

I enjoyed your humorous account of searching for "CMS" in wikipedia by the
way. That "Certificate in Master Safecracking" might bear some research! :)

Thanks for shedding more light on this at any rate. I know folks will
appreciate these.


> > So good information, but difficult to see. Sorry.
> >
> > --
> >
> 
> > MzK
> >
> > "I would rather have a donkey that takes me there
> >  than a horse that will not fare."
> >   -- Portuguese proverb
>



-- 

MzK

"I would rather have a donkey that takes me there
 than a horse that will not fare."
  -- Portuguese proverb

problem

2012-07-03 Thread Annmarie Schroden

hello, I have a little problem went I shut down my computer and I bring it up 
again
open office open with out me clicking on the icon how do I get it to stop open 
up.
did I install it wrongplease help

AOO 3.4 Impress not recognising Dual monitors?

2012-07-03 Thread Rory O'Farrell

I'm not yet in a position to raise a formal bug, but I would appreciate input 
from other users who may have occasion to use AOO 3.4 to give a presentation.  

I have not been able to get AOO 3:4 Impress to successfully recognise the 
second monitor on later *ubuntu systems (say 11:10 and later).  

I have requested information from others on the Forum in thread
http://user.services.openoffice.org/en/forum/viewtopic.php?f=10&t=54875

I would welcome input from users from the Apache lists; I bring it to the 
attention of the ooo-dev list as some developer working on Impress may test 
this in passing.


-- 
Rory O'Farrell

Re: [RELEASE][3.4.1]: Preparing release notes

On Mon, Jul 2, 2012 at 1:09 AM, Jürgen Schmidt
wrote:

> Hi,
>
> ok AOO 3.4.1 won't be a feature release but nevertheless I think we
> should prepare release notes to give a user friendly overview of what is
> going into our upcoming 3.4.1 release.
>
> I have created a new (more or less empty) wiki page to start working on
> the release notes for 3.4.1.
>
>
> https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+3.4.1+Release+Notes
>
> The following query list all fixed blocker issues for 3.4.1 and can be
> used as input for the release notes.
>
> Any volunteers who are interested to start working on it?
>
> Juergen
>

I can help with this after next week -- after Jul 14. Hopefully that's not
too late.

-- 

MzK

"I would rather have a donkey that takes me there
 than a horse that will not fare."
  -- Portuguese proverb

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Anton Meixome

2012/7/3 Stuart Swales :
> On 03/07/2012 16:17, FR web forum wrote:
>> String has been translated in french.
>> I make it in anonymous, could you commit it?
>> Thanks
>>
>> - Mail original -
 Most important are the languages that we want release:

 en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW

 and potentially "sk" where I have to update Pootle with the latest
 available updates from Michal Hriň

 The new string is in desktop - source - app.po

 See for example for French"

 desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text

 https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated

>
> Please commit for en-GB too (no translation changes needed in this case)
>
> Cheers
>
> Stuart
> --
> Stuart Swales
>
>

Galician done

(@Michal) Slovak approved, too.


-- 
Antón Méixome - Galician Native Lang Coordination
Galician community LibO & AOO

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Simon Phipps

On Tue, Jul 3, 2012 at 4:22 PM, Pedro Giffuni  wrote:

>
>
> --- Mar 3/7/12, Simon Phipps  ha scritto:
> ...
> >
> > On 3 Jul 2012, at 15:29, Pedro Giffuni wrote:
> >
> > >
> > > --- Mar 3/7/12, Simon Phipps 
> > ha scritto:
> > > ...
> > >>
> > >> Please can we have an update on that effort to get
> > all the
> > >> CWS made available then? It seems a perfectly
> > reasonable
> > >> request, one I and others have been making here
> > since the
> > >> inception of the project and one I am not able to
> > go
> > >> negotiate personally so need to keep asking about
> > here.
> > >>
> > >
> > > What effort?
> >
> > Mentioned in an e-mail linked from the OP, dated June 7,
> > 2011 - those of us inside the project have been raising this
> > topic from very early on, as you can see. Making it easy for
> > outside developers to meet their needs is a great way to
> > have them begin to join in and become insiders like you.
> >
> > The message is at
> http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3c4dee6c86.5070...@oracle.com%3E
> >
> > S.
>
> OK. I think that in that mail message "we" stands for Oracle,
> not for Apache, so you'd have to ask Andrew Rist with his
> Oracle hat.
>

OK, thanks.

Andrew, do you have an update on the outcome of your assertion "We are
trying to provide all of the Oracle owned content in the OOo repositories"
(this was in the context of the CWSs) please?

Cheers!

S.

Re: CWS swbookmarkfixes01 rebasing and licensing

On Tue, Jul 3, 2012 at 11:44 AM, Bjoern Michaelsen
 wrote:
> Hi Ross,
>
> Thanks for the constructive reply!
>
> On Tue, Jul 03, 2012 at 03:58:54PM +0100, Ross Gardler wrote:
>> If the CWS was included in the original SGA then it is available under
>> the AL2.
>
> How can I check that? It was not integrated in m106 at OOo, if that is the
> criteria, but I assume there is more to that ;)
>
>> If it was not included in that original SGA, you want to bring it here and
>> the OpenOffice project want to see the work committed then Oracle will, in
>> all likelihood, make it available to us.
>
> Great!
>
>> Therefore, I suggest the following order of execution:
>> - determine whether the OpenOffice committers want the work
>
> Where would that be done?
>
>> - confirm that Oracle have already or will make the code available
>> under the AL2 at our request
>
> Are there established workflows for that, or should I just go about that 
> ad-hoc?
>
>> - submit patches against AOO trunk
>
> Are the patches already released AL2 by Apache when they are published on the
> list then? Given that AOO might switch to the Symphony codebase and fail to
> even release a version with the patches against the original OOo, I would need
> that assureance that the effort to rebase the work is not in vain.
>

The particular circumstances you are in, and the task you are trying
to accomplish, is not necessarily covered by a specific single
process.  So rather than focusing on process, I'd recommend
considering the overall forces at play and the known patterns for
resolving these forces.

If someone wants to contribute code to the project, then they need to
deal with three basic things:

a) Does the project want the code?

b) Technical integration

c) Getting the code under ALv2 or a compatible license.

This is true for committers as well.  We all need to be concerned with
these questions.  The main difference is that a committer operates
under Commit Then Review (CTR) rules.

#1 and #2 above are relatively easy.  It is social and code.  #3 is
not so much about a single process, but a logical argument.  Someone
contributing code should have a logical argument for why the code is
properly licensed.   There are several well-known conventions for
making this kind of argument, using procedures like an SGA.  Even
committers implicitly make this argument whenever they check in code,
based on their iCLA obligations.

However, these procedures are neither necessary nor sufficient.  But
they are well-known and following these conventions helps us all avoid
a lot of extra analysis.   Of course, if necessary we'd be open to
considering other forms of argument aimed at proving the suitability
of license for a code contribution.

Back to your original question:  An author posting original work to
the list, with an intent of contributing it to the project would
typically be accepted as an ALv2 contribution.  An iCLA for the author
would be preferred for larger contributions, but an unambiguous
statement on the list (or in Bugzilla) is a good start.

But posting 3rd party code to the list, i.e., not original work, that
would probably raise a red flag.

Hope this helps.

-Rob

> Looking forward to hopefully some constructive cooperation.
>
> Best,
>
> Bjoern

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Ariel Constenla-Haile

On Tue, Jul 03, 2012 at 05:44:30PM +0200, Bjoern Michaelsen wrote:
> Hi Ross,
> 
> Thanks for the constructive reply!
> 
> On Tue, Jul 03, 2012 at 03:58:54PM +0100, Ross Gardler wrote:
> > If the CWS was included in the original SGA then it is available under
> > the AL2.
> 
> How can I check that? It was not integrated in m106 at OOo, if that is the
> criteria, but I assume there is more to that ;)

besides the files listed on the SGA
https://svn.apache.org/repos/asf/incubator/ooo/pmc/ip-review/ Eike
Rathke, Mathias Bauer and Michael Stahl integrated some CWS last year,
their work got "documented" on the svn logs and this mailing list, see
for example this thread: http://markmail.org/message/3lqichu77wg3pfyu
I don't find swbookmarkfixes01 on the mail archive nor on the svn log.
So that CWS was not included on the original SGA nor in the code
integrated from CWSs.

> Given that AOO might switch to the Symphony codebase

This is a misinterpretation of the general outcome of this discussion:
http://markmail.org/message/wkcosra4s3wugtua

Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina

pgpY0B1hxqXph.pgp
Description: PGP signature

Re: [PROPOSAL] Create ooo-l...@incubator.apache.org

2012-07-03 Thread Paolo Pozzan


Il 02/07/2012 23:19, Andrea Pescetti ha scritto:

Rob Weir wrote:

I suggested this on the list a few weeks ago.  I'd like to now move
forward with it.
I'll volunteer to be one of the list moderators.  But I need 2-3 other
committers to volunteer as well.  Let me know if you can help.


I can help (with my usual Apache alias, pescetti), unless Paolo Pozzan,
who is more into localization than I am, prefers to be involved; in that
case I'll leave this task to him. As for the timezone, I'm usually in
Europe.


+1!

I will go for aoo-l10n. One don't need to guess the mailing list 
address, it is simply written, ready to be copy-pasted or clicked on it.


I am also offering myself as a moderator. paolopoz is my Apache alias.
CE(S)T timezone.

Paolo

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Stuart Swales

On 03/07/2012 16:17, FR web forum wrote:
> String has been translated in french.
> I make it in anonymous, could you commit it?
> Thanks
> 
> - Mail original -
>>> Most important are the languages that we want release:
>>>
>>> en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
>>>
>>> and potentially "sk" where I have to update Pootle with the latest
>>> available updates from Michal Hriň
>>>
>>> The new string is in desktop - source - app.po
>>>
>>> See for example for French"
>>>
>>> desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
>>>
>>> https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
>>>

Please commit for en-GB too (no translation changes needed in this case)

Cheers

Stuart
-- 
Stuart Swales

RE: [Review|Discussion]For Ideas and Comments on the Vision of Writer's Track Changes Improvement

2012-07-03 Thread Dennis E. Hamilton

I have questions about the way that the improvements are intended to be 
extensions to the ODF format.

I understand from what is said that improvements are introduced into the ODF 
document in a way that they will be ignored by older implementations and other 
implementations that are unaware of them.  The intention is to map to and from 
.doc in a reliable manner.

 1. How are the extensions introduced such that conforming ODF consumers will 
ignore them properly?  Will users be able to turn off the improvements in order 
to produce conforming ODF documents?

 2. Will ignoring the extensions result in an usable conforming ODF document 
and will round-trip return to the producer of the extensions be tolerable.  
Should there be warning when an user makes changes that rely on the 
improvements in a document that was not produced by an improvement-aware 
implementation?

 3. How are the improvement extensions to the ODF format being made known so 
that other consumers of ODF can support them either partially or completely to 
provide a smoother experience in support of their users and in providing 
interoperability?

-Original Message-
From: chengjh [mailto:chen...@apache.org] 
Sent: Tuesday, July 03, 2012 00:25
To: ooo-dev@incubator.apache.org; dennis.hamil...@acm.org
Subject: Re: [Review|Discussion]For Ideas and Comments on the Vision of 
Writer's Track Changes Improvement

Hi Dennis,

Thanks for your feedback.Please say my a),b),c) and d).

On Tue, Jul 3, 2012 at 12:16 PM, Dennis E. Hamilton  wrote:

[ ... ]

> Because of this, it is important to understand how your proposed Track
> Changes Improvement will be reflect in the ODF 1.2 documents consumed and
> produced by Apache OpenOffice at this time.  That is, what needs to be done
> in the format, if anything, and how is interoperable communication of that
> handled in the persistent document?
>

b) One of the significant principles of the improvement is to keep
compatibility
http://wiki.services.openoffice.org/wiki/Writer/ToDo/TrackChanges#Design_Principles
with
previous releases of AOO/Symphony in order to ensure the persistent
document. The new formats saved in the improvement will be lost when being
launched into old versions' AOO/Symphony.

[ ... ]

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Pedro Giffuni

--- Mar 3/7/12, Bjoern Michaelsen ha scritto:

> Hi Ross,
> 
> Thanks for the constructive reply!
> 
> On Tue, Jul 03, 2012 at 03:58:54PM +0100, Ross Gardler
> wrote:
> > If the CWS was included in the original SGA then it is
> > available under the AL2.
> 
> How can I check that? It was not integrated in m106 at OOo,
> if that is the criteria, but I assume there is more to that ;)
> 

I don't think we committed it. You can review the SVN history
in fisheye, but it's probably easier to look at the code and
recognize it.

> > If it was not included in that original SGA, you want
> to bring it here and
> > the OpenOffice project want to see the work committed
> then Oracle will, in
> > all likelihood, make it available to us.
> 
> Great!
> 
> > Therefore, I suggest the following order of execution:
> 
> > - determine whether the OpenOffice committers want the
> work
> 
> Where would that be done?
> 

Here. You may want to send us a description. If you prefer
you can handle it through a bugzilla issue.

> > - confirm that Oracle have already or will make the
> code available
> > under the AL2 at our request
> 
> Are there established workflows for that, or should I just
> go about that ad-hoc?
> 

ad-hoc. They are very cooperative.

> > - submit patches against AOO trunk
> 
> Are the patches already released AL2 by Apache when they are
> published on the list then?

Unfortunately it's not that easy. The code is strictly under
ALv2 only when the code has been released by the ASF.
We are under incubation still so being strict that means
that you can only count with code officially reviewed by
the ASF IPMC and released.

> Given that AOO might switch to the Symphony codebase and fail to
> even release a version with the patches against the original
> OOo, I would need that assureance that the effort to rebase
> the work is not in vain.
> 

I think the "effort to rebase" is actually pretty small as
we have avoided wild changes (precisely to ease code
merging). If we do rebase on Symphony (which is only
an option and not the most popular ATM), merging changes
from AOO is still relatively easy (I tried this myself
already).

I am going to be pretty honest with you (as with everyone).

We welcome new contributions, especially from people that
have experience with the codebase, but if the idea is simply
getting "your" code relicensed on the short term and leave
us with the problem of maintaining it or even worse, fixing
it, this is not going to work.

best regards,

Pedro.

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Michal Hriň

in slovak is translated anonymously online, too.
approve it someone.

 

 

 

-Original Message-
From: Reizinger Zoltán 
To: ooo-dev 
Sent: Tue, Jul 3, 2012 5:49 pm
Subject: Re: [TRANSLATION][3.4.1]: update Pootle server to include new string 
for a new warning box


2012.07.03. 15:25 keltezéssel, Jürgen Schmidt írta:
> Hi,
>
> based on the discussion relating Windows 8 readiness etc. we have
> identified 5 critical issues. And we have already started to work on
> these issues and my plan is to have them all ready for a 3.4.1 that we
> can decide at any time later if we want to move forward with the W8
> support when we have everything in place in time.
>
> For solving one of these issues we have to introduce a new warning box
> which means that we have to translate a new string for 3.4.1.
>
> I have updated the Pootle server already with the new string (17 words
> only) and I would like to ask our translators to focus on this new
> string as soon as possible (ideally this week).
>
> Most important are the languages that we want release:
>
> en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
>
> and potentially "sk" where I have to update Pootle with the latest
> available updates from Michal Hriň
>
> The new string is in desktop - source - app.po
>
> See for example for French"
>
> desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
>
> https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
>
> "de" will be covered by myself ;-) because there is currently a problem
> that I don't understand and that I have to solve.
>
> To simplify the update I would prefer if the string get translated on
> the Pootle server.
>
> Please send me a short note when an updated or better a translation of
> the string is available. I will take care of the integration.
>
> If anybody have problems doing it on Pootle please let me know.
>
>
> Juergen
>
>
The HU translation is ready.
Zoltan

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread Reizinger Zoltán


2012.07.03. 15:25 keltezéssel, Jürgen Schmidt írta:

Hi,

based on the discussion relating Windows 8 readiness etc. we have
identified 5 critical issues. And we have already started to work on
these issues and my plan is to have them all ready for a 3.4.1 that we
can decide at any time later if we want to move forward with the W8
support when we have everything in place in time.

For solving one of these issues we have to introduce a new warning box
which means that we have to translate a new string for 3.4.1.

I have updated the Pootle server already with the new string (17 words
only) and I would like to ask our translators to focus on this new
string as soon as possible (ideally this week).

Most important are the languages that we want release:

en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW

and potentially "sk" where I have to update Pootle with the latest
available updates from Michal Hriň

The new string is in desktop - source - app.po

See for example for French"

desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text

https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated

"de" will be covered by myself ;-) because there is currently a problem
that I don't understand and that I have to solve.

To simplify the update I would prefer if the string get translated on
the Pootle server.

Please send me a short note when an updated or better a translation of
the string is available. I will take care of the integration.

If anybody have problems doing it on Pootle please let me know.


Juergen



The HU translation is ready.
Zoltan

Re: CWS swbookmarkfixes01 rebasing and licensing

Hi Ross,

Thanks for the constructive reply!

On Tue, Jul 03, 2012 at 03:58:54PM +0100, Ross Gardler wrote:
> If the CWS was included in the original SGA then it is available under
> the AL2.

How can I check that? It was not integrated in m106 at OOo, if that is the
criteria, but I assume there is more to that ;)

> If it was not included in that original SGA, you want to bring it here and
> the OpenOffice project want to see the work committed then Oracle will, in
> all likelihood, make it available to us.

Great!

> Therefore, I suggest the following order of execution: 
> - determine whether the OpenOffice committers want the work

Where would that be done?

> - confirm that Oracle have already or will make the code available
> under the AL2 at our request

Are there established workflows for that, or should I just go about that ad-hoc?

> - submit patches against AOO trunk

Are the patches already released AL2 by Apache when they are published on the
list then? Given that AOO might switch to the Symphony codebase and fail to
even release a version with the patches against the original OOo, I would need
that assureance that the effort to rebase the work is not in vain.

Looking forward to hopefully some constructive cooperation.

Best,

Bjoern

Re: [OT] playing video native on windows (Re: CMS anonymous user improvements)

On Tue, Jul 3, 2012 at 11:06 AM, drew  wrote:
> Hi Rob,
>
> Nice video, good quality it looks good

Thanks.

> Have a couple of questions for you if you don't mind.
>
> Will the files generated directly from Camtasia run in the MS supplied
> media player directly?
>

I did not try.  I can check when I'm home.  It was 1280x768.
Camtasia has s bunch of export options, including one for YouTube HD,
which I was I picked.   I never had to touch or upload the files.  It
had a dialog for logging into YouTube, picking title, tags, etc..  It
then encoding the video and uploaded it automatically.

> I did a quick read on their web site but didn't see that directly
> answered.
>
> I suppose should start just by asking what format files you are
> producing?
>
> Last - the video on youtube now, how large a file is the original you
> uploaded?
>

I don't know, since I never saw it. The upload happens behind the
scenes.  But I can check at home to see whether the intermediate files
are still there.

-Rob

> Thanks,
>
> //drew
>
> On Tue, 2012-07-03 at 10:08 -0400, Rob Weir wrote:
>> On Mon, Jul 2, 2012 at 6:53 PM, Kay Schenk  wrote:
>> > On Mon, Jul 2, 2012 at 2:41 PM, Rob Weir  wrote:
>> >
>> >> On Sun, Jun 24, 2012 at 8:47 AM, Joe Schaefer 
>> >> wrote:
>> >> > This weekend David Blevins and I worked on streamlining
>> >> > the anonymous user support in the CMS.  Two major improvements
>> >> > are the introduction of "Quick Mail" and anonymous clones.
>> >> >
>> >> > Quick Mail is the analog of Quick Commit but for anonymous
>> >> > users- it is enabled by default and makes submitting patches
>> >> > to the mailing list much easier to execute.  The mailout will
>> >> > contain a url for committers to use that permits a committer
>> >> > to clone the working copy of the anonymous user, so all you'd
>> >> > need to do is review the change in the CMS and commit it.
>> >> >
>> >> > Would be nice if Rob or someone created a video tutorial for this
>> >> > that's geared toward anon users and showed off these new features.
>> >>
>> >> http://www.youtube.com/watch?v=7fvg1pfHLhE
>> >>
>> >> >
>> >>
>> >
>> > Hi Rob --
>> >
>> > I couldn't read this one as clearly as your first. You used some sort of
>> > zoom mechanism on the first one I think, and also there seemed to be some
>> > text annotations on the first one with actual bookmarlet URL that this one
>> > doesn't have.
>> >
>>
>> I'm still learning the tool (Camtasia)  It looks like if you do the
>> original recording at a higher resolution than the output resolution
>> then you can tell it to automatically zoom in to area where your mouse
>> is.  But in this case my recording resolution is the same as the
>> output resolution, so no zooming is possible.
>>
>> But I can add text annotations, arrows, etc.
>>
>> -Rob
>>
>> > So good information, but difficult to see. Sorry.
>> >
>> > --
>> > 
>> > MzK
>> >
>> > "I would rather have a donkey that takes me there
>> >  than a horse that will not fare."
>> >   -- Portuguese proverb
>>
>
>

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

Am Dienstag, 3. Juli 2012 um 17:17 schrieb FR web forum:
> String has been translated in french.
> I make it in anonymous, could you commit it?
>  
>  
>  

Perfect and yes I will take care of it, thanks

Jürgen
>   
>  
> - Mail original -
> > > Most important are the languages that we want release:
> > >  
> > > en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
> > >  
> > > and potentially "sk" where I have to update Pootle with the latest
> > > available updates from Michal Hriň
> > >  
> > > The new string is in desktop - source - app.po
> > >  
> > > See for example for French"
> > >  
> > > desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
> > >  
> > > https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
> > >

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Pedro Giffuni

--- Mar 3/7/12, Simon Phipps  ha scritto:
...
> 
> On 3 Jul 2012, at 15:29, Pedro Giffuni wrote:
> 
> > 
> > --- Mar 3/7/12, Simon Phipps 
> ha scritto:
> > ...
> >> 
> >> Please can we have an update on that effort to get
> all the
> >> CWS made available then? It seems a perfectly
> reasonable
> >> request, one I and others have been making here
> since the
> >> inception of the project and one I am not able to
> go
> >> negotiate personally so need to keep asking about
> here. 
> >> 
> > 
> > What effort?
> 
> Mentioned in an e-mail linked from the OP, dated June 7,
> 2011 - those of us inside the project have been raising this
> topic from very early on, as you can see. Making it easy for
> outside developers to meet their needs is a great way to
> have them begin to join in and become insiders like you.
> 
> The message is at 
> http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3c4dee6c86.5070...@oracle.com%3E
> 
> S.

OK. I think that in that mail message "we" stands for Oracle,
not for Apache, so you'd have to ask Andrew Rist with his
Oracle hat.

We do have a nice relationship with Oracle and they have
always been very receptive with our requests so I certainly
recommend other communities to solve your issues and approach
them constructively.

FWIW, other ex-oracle employees have gotten CWSs successfully
included in our 3.4 release. AFAICT, all of them signed iCLAs
and were actively involved in the community getting their
patches cleaned up and working.

Pedro.

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread FR web forum

String has been translated in french.
I make it in anonymous, could you commit it?
Thanks

- Mail original -
>> Most important are the languages that we want release:
>>
>> en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
>>
>> and potentially "sk" where I have to update Pootle with the latest
>> available updates from Michal Hriň
>>
>> The new string is in desktop - source - app.po
>>
>> See for example for French"
>>
>> desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
>>
>> https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
>>

[OT] playing video native on windows (Re: CMS anonymous user improvements)

Hi Rob,

Nice video, good quality it looks good 

Have a couple of questions for you if you don't mind.

Will the files generated directly from Camtasia run in the MS supplied
media player directly?

I did a quick read on their web site but didn't see that directly
answered.

I suppose should start just by asking what format files you are
producing?

Last - the video on youtube now, how large a file is the original you
uploaded?

Thanks,

//drew

On Tue, 2012-07-03 at 10:08 -0400, Rob Weir wrote:
> On Mon, Jul 2, 2012 at 6:53 PM, Kay Schenk  wrote:
> > On Mon, Jul 2, 2012 at 2:41 PM, Rob Weir  wrote:
> >
> >> On Sun, Jun 24, 2012 at 8:47 AM, Joe Schaefer 
> >> wrote:
> >> > This weekend David Blevins and I worked on streamlining
> >> > the anonymous user support in the CMS.  Two major improvements
> >> > are the introduction of "Quick Mail" and anonymous clones.
> >> >
> >> > Quick Mail is the analog of Quick Commit but for anonymous
> >> > users- it is enabled by default and makes submitting patches
> >> > to the mailing list much easier to execute.  The mailout will
> >> > contain a url for committers to use that permits a committer
> >> > to clone the working copy of the anonymous user, so all you'd
> >> > need to do is review the change in the CMS and commit it.
> >> >
> >> > Would be nice if Rob or someone created a video tutorial for this
> >> > that's geared toward anon users and showed off these new features.
> >>
> >> http://www.youtube.com/watch?v=7fvg1pfHLhE
> >>
> >> >
> >>
> >
> > Hi Rob --
> >
> > I couldn't read this one as clearly as your first. You used some sort of
> > zoom mechanism on the first one I think, and also there seemed to be some
> > text annotations on the first one with actual bookmarlet URL that this one
> > doesn't have.
> >
> 
> I'm still learning the tool (Camtasia)  It looks like if you do the
> original recording at a higher resolution than the output resolution
> then you can tell it to automatically zoom in to area where your mouse
> is.  But in this case my recording resolution is the same as the
> output resolution, so no zooming is possible.
> 
> But I can add text annotations, arrows, etc.
> 
> -Rob
> 
> > So good information, but difficult to see. Sorry.
> >
> > --
> > 
> > MzK
> >
> > "I would rather have a donkey that takes me there
> >  than a horse that will not fare."
> >   -- Portuguese proverb
>

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Simon Phipps

On 3 Jul 2012, at 15:29, Pedro Giffuni wrote:

> 
> --- Mar 3/7/12, Simon Phipps  ha scritto:
> ...
>> 
>> Please can we have an update on that effort to get all the
>> CWS made available then? It seems a perfectly reasonable
>> request, one I and others have been making here since the
>> inception of the project and one I am not able to go
>> negotiate personally so need to keep asking about here. 
>> 
> 
> What effort?

Mentioned in an e-mail linked from the OP, dated June 7, 2011 - those of us 
inside the project have been raising this topic from very early on, as you can 
see. Making it easy for outside developers to meet their needs is a great way 
to have them begin to join in and become insiders like you.

The message is at 
http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3c4dee6c86.5070...@oracle.com%3E

S.

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Ross Gardler

Hi Bjoern,

If the CWS was included in the original SGA then it is available under
the AL2. If it was not included in that original SGA, you want to
bring it here and the OpenOffice project want to see the work
committed then Oracle will, in all likelihood, make it available to
us.

Therefore, I suggest the following order of execution:

- determine whether the OpenOffice committers want the work
- confirm that Oracle have already or will make the code available
under the AL2 at our request
- submit patches against AOO trunk

Ross

On 3 July 2012 12:17, Bjoern Michaelsen  wrote:
> Hi all,
>
> back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
> be convenient not having to recreate. According to:
>
>  
> http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E
>
> ownership of the CWS is now at ASF. So two simple questions:
>
> - Is this (my) work in this CWS released under AL2 to the public already with
>   this?
> - If not and I do the work to re-base this CWS against master, and have it
>   checked into an Apache SVN branch will the work then be immediately
>   available under the ALv2 license?
>
> Best,
>
> Bjoern



-- 
Ross Gardler (@rgardler)
Programme Leader (Open Development)
OpenDirective http://opendirective.com

Re: New committer: Liu Zhe

I've updated the podling status file to include Liu Zhe and Kevin Grignon.

http://incubator.apache.org/projects/openofficeorg.html

-Rob

On Mon, Jul 2, 2012 at 8:17 AM, Dennis E. Hamilton  wrote:
> The Apache OpenOffice PPMC announces the addition of committer
> Liu Zhe, liuzhe@ apache.org
>
> The list of all current podling committers is at:
> .
>
> Committers have a defined role in the workings of the Apache Software
> Foundation: .
>
> For new committers:
>
> First, please read through the "Guide for New Committers":
> http://www.apache.org/dev/new-committers-guide.html   There is some
> useful information there related to email, security, etc.
>
> Secondly, you can control your profile and settings by using your
> Apache User ID and password, supplied for your Apache account,
> to log on to .  There you can change your
> password to one of your choosing.  In addition, please add the
> other e-mail addresses that you want to be known by.  If you want
> to change the forwarding of e-mail in the future, use
> the profile to accomplish that.
>
> Next, please add an entry for yourself on this project page:
> http://incubator.apache.org/openofficeorg/people.html
>
> Now that you are a committer, this is a good opportunity for you to
> make your first commit, editing that page.  The simplest way is to use
> the Apache CMS to edit this page via the web:
>
> http://incubator.apache.org/openofficeorg/website-local.html#using-the-apache-cms-bookmarklet-simpler-method
>
> Finally, you are now authorized to make commits to the Apache
> OpenOffice SVN repository and other repositories established
> for committers.  Use the https: version of the SVN URL.  Your
> Apache ID and password will be required on your first commit.
> Use options to retain your credentials for future commits if
> appropriate.
>
>  - the Apache OpenOffice PPMC
>

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

On Tue, Jul 3, 2012 at 9:54 AM, Yi Xuan Liu  wrote:
> The reason of removing the first round result is that we found that the
> first round result is much different from other rounds. It is usually
> slower to open the sample file at the first time. So, we could view the
> first round result as an outlier and removed it when computing the average
> and standard deviation.  However, the first round is also important for
> user experience. Maybe, we could list the first round performance
> separately.
>

That's what I was wondering as well.  If the first run is slow because
you are loading additional software needed to measure the test runs,
then it is fair to discard the first run.  But if the first run is
slow because of I/O related to loading the AOO code or the document,
then that is real and part of the real user experience.

> As for the second value, t-test is a good suggestion and I'll research on
> it and use it in the following test. Thanks!
>

Here is a spreadsheet demonstrating the approach I use when doing
performance comparisons:

http://people.apache.org/~robweir/perf/perf-compare.ods

It uses the chart to give a visual indication of whether the measured
differences are within the range of expected variability, or whether
they are are "real".

-Rob

>
> On Tue, Jul 3, 2012 at 7:41 PM, Rob Weir  wrote:
>
>> On Tue, Jul 3, 2012 at 6:39 AM, Linyi Li  wrote:
>> > From Xuan Xuan's introduction in the beginning, I think the first data is
>> > average value of the test results and the second data is the standard
>> > deviation.
>> >
>>
>> So why skip the numbers for the first round test?  Isn't that what
>> real users see, the first round?  Sure, it will be slower as code is
>> loaded into memory, files read from disk, etc.  But the same thing
>> happens for users.
>>
>> Also, I think the interesting 2nd number is the "standard error of the
>> mean", which == std deviation / sqrt(count of measurements).  That is
>> what gives the error bars (confidence interval) on the measurement.
>> For example, 95% confidence limits on a measurement would be:
>>
>> lower bound = mean - 1.96*standard_error
>> upper bound = mean + 1.96*standard_error
>>
>> And easy "rule of thumb" is to compare the "before" and "after"
>> measures and see if there is overlap in the intervals.
>>
>> For example:
>>
>> Before interval: (1.0, 2.0)
>> After interval: (1.5, 2.5)
>>
>> Because the intervals overlap, there might not be a significant
>> difference between the two.
>>
>> But:
>>
>> Before interval: (1.0, 2.0)
>> After interval: (2.5, 3.5)
>>
>> In this case there is a clear difference, because the confidence
>> intervals do not overlap.
>>
>> A t-test could also be used here, but the above approach works well in
>> Calc if you use the "stock 2" type chart.  This has series for
>> high/low/close/open.  So you could do something where the high and low
>> values are 95% confidence intervals.  This makes it easy to tell what
>> is important from a glance.
>>
>> -Rob
>>
>> >
>> > On Tue, Jul 3, 2012 at 5:36 PM, Ji Yan  wrote:
>> >
>> >> I'm sure Yi Xuan will update her wiki page with detail test case and the
>> >> meaning of report data
>> >>
>> >> 2012/7/3 Andre Fischer 
>> >>
>> >> > On 03.07.2012 09:02, Herbert Duerr wrote:
>> >> >
>> >> >> |-|---**|---|-**
>> >> >>> |
>> >> >>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
>> >> >>> | |   | Complex | 1.13/ 0.03  |
>> >> >>> |-|---**|---|-**
>> >> >>> |
>> >> >>> [...]
>> >> >>>   Any comment is welcomed!
>> >> >>>
>> >> >>
>> >> >> Thanks for sharing this interesting data.
>> >> >> I haven't found an explanation what these numbers mean though, so I
>> have
>> >> >> to guess: The first number is the average value and the second is the
>> >> >> sigma value for running the test, right?
>> >> >>
>> >> >
>> >> > It would be good to put any explanation/documentation on the wiki
>> page or
>> >> > else the information about the test parameters from the first mail --
>> (8
>> >> > runs, average over 5), what is plain or complex -- would be lost.
>> >> >
>> >> > -Andre
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >>
>> >> Thanks & Best Regards, Yan Ji
>> >>
>> >
>> >
>> >
>> > --
>> > Best wishes.
>> > Linyi Li
>>

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

2012-07-03 Thread Regina Henschel


Hi,

chengjh schrieb:

Hi Peng,

Let me use a scenario to confirm your problem,solution and
question..Anything misunderstood,please correct me.thanks.

Problem:
When AOO launches an excel document with VBA,saves to ods and then saves to
excel again,the VBA info will be lost.

Solution:
a)The VBA streams of an excel document will be saved into the ods document
with binary format when converting an excel document to an ods document in
AOO Spreadsheet with certain controller.
b)Once the ods document containing the binary VBA streams is launched into
AOO or previous releases,with certain controller,the binary VBA steams will
be loaded[still binary stream in memory] or rejected..There is no any
impact on the application,the application can still work well.
c)Based on b),if the ods document is saved to an excel document,the binary
VBA streams will be exported, thus, the VBA info will not be lost.


I do not like the idea, that a binary code which I do not know what it 
does, will be shipped together with an ods-file. Because the source it 
editable in the IDE, the source and the binary might differ. The binary 
can be dangerous although the source looks harmless. I consider this a 
security problem.


Currently the macro is lost, although the source is in the ods-file and 
commented as VBA macro. Isn't it possible, to write the macro back to 
xsl-file from this source?


Kind regards
Regina



Question:
You are not sure whether this solution is reasonable. So, you want to know
the comments about your solution. If no comments, you will do so to
implement it.

On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng  wrote:


Hi All,
   My name is Chen Peng, I am a developer from Symphony. My special
areas are VBA and sw.
   Now I found an issue about macros lost:
  I saved an excel file with VBA to spreadsheet, the VBA can work
well in spreadsheet, then I wanted to save this spreadsheet back to excel,
but all the macros are lost.
   I propose to save the binary data of excel VBA to spreadsheet, when
saving excel to spreadsheet, then we can get the binary data from
spreadsheet if need to save the spreadsheet to excel again.
   The binary data will not impact the open/save... of the ODF format
application, it will not be touched when we operate the ODF formant
applications. The binary data will be just used when we want to save the
spreadsheet to excel, it is just a data prestore about saving spreadsheet
macros to excel.
Can you give some advice about the solution?
Any feedback will be preciated, thanks.

Re: CWS swbookmarkfixes01 rebasing and licensing

Hi Olli,

On Tue, Jul 03, 2012 at 03:50:10PM +0200, Oliver-Rainer Wittmann wrote:
> I did not see any aggressive tone in Rob's reply.

Nitpicking on irrelevant sideissues might be acceptable, if the main topics of
the mail were answered -- otherwise its just unconstructive passive aggreesion.
Nothing in Robs first email allowed help to get this CWS into AOO or clarify
the situation, so why bother with it at all?

Anyway. I feel I have better chances to get things done by dealing with Oracle
directly.

Best,

Bjoern

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Pedro Giffuni


--- Mar 3/7/12, Simon Phipps  ha scritto:
...
> 
> Please can we have an update on that effort to get all the
> CWS made available then? It seems a perfectly reasonable
> request, one I and others have been making here since the
> inception of the project and one I am not able to go
> negotiate personally so need to keep asking about here. 
> 

What effort?

I think we have been pretty consistent here every time the
subject is brought up by someone external to the project.

I am not a lawyer and neither is Rob or most of the people
doing development here and even if we were lawyers we have
no power to relicense code that isn't ours. In general we
don't release patches or CWSs other than what you see in
our releases (at this time 3.4 only).

Pedro.

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

2012-07-03 Thread Lei Wang

As I know, VBA code can be related with specific sheet. When end user open
the ods file and remove this sheet, then save it as xls file.  According to
your solution, all VBA codes will be restored in xls file. Is this xls file
valid?

Another concern is does your solution conform to ODF1.2 standard?

On Tue, Jul 3, 2012 at 6:32 PM, chengjh  wrote:

> That doesn't matter that you think they are VBA or Star Basic when saving a
> xls with VBA as ods file..To some APIs with behavior difference,they will
> be distinguished with the line "Option VBASupport 1" at the beginning..End
> users can modify the Star Basic codes in AOO Spreadsheet,but all Star Basic
> contents including original and modified will be lost when exporting to xls
> file..Here,if the ods file is converted from a xls file based on Peng's
> solution,the behavior is still kept unchanged...The only difference is that
> the saved binary VBA streams within the ods file will be exported to the
> xls file at that time.Thus,when end users launch the xls file in MS
> Excel,the original VBA will be there.That's the expected result.thanks.
>
> On Tue, Jul 3, 2012 at 5:02 PM, Lei Wang  wrote:
>
> > Jian Hong,
> >
> > Will AOO save VBA as Star Basic in ods file when saving a xls file with
> VBA
> > as ods file? If it is true, can user modify the Star Basic in the new ods
> > file? What happened if user change the Star Basic in the ods file then
> save
> > as a xls file?
> >
> > On Tue, Jul 3, 2012 at 3:57 PM, chengjh  wrote:
> >
> > > Hi Peng,
> > >
> > > Let me use a scenario to confirm your problem,solution and
> > > question..Anything misunderstood,please correct me.thanks.
> > >
> > > Problem:
> > > When AOO launches an excel document with VBA,saves to ods and then
> saves
> > to
> > > excel again,the VBA info will be lost.
> > >
> > > Solution:
> > > a)The VBA streams of an excel document will be saved into the ods
> > document
> > > with binary format when converting an excel document to an ods document
> > in
> > > AOO Spreadsheet with certain controller.
> > > b)Once the ods document containing the binary VBA streams is launched
> > into
> > > AOO or previous releases,with certain controller,the binary VBA steams
> > will
> > > be loaded[still binary stream in memory] or rejected..There is no any
> > > impact on the application,the application can still work well.
> > > c)Based on b),if the ods document is saved to an excel document,the
> > binary
> > > VBA streams will be exported, thus, the VBA info will not be lost.
> > >
> > > Question:
> > > You are not sure whether this solution is reasonable. So, you want to
> > know
> > > the comments about your solution. If no comments, you will do so to
> > > implement it.
> > >
> > > On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng 
> > wrote:
> > >
> > > > Hi All,
> > > >   My name is Chen Peng, I am a developer from Symphony. My
> special
> > > > areas are VBA and sw.
> > > >   Now I found an issue about macros lost:
> > > >  I saved an excel file with VBA to spreadsheet, the VBA can
> > work
> > > > well in spreadsheet, then I wanted to save this spreadsheet back to
> > > excel,
> > > > but all the macros are lost.
> > > >   I propose to save the binary data of excel VBA to spreadsheet,
> > when
> > > > saving excel to spreadsheet, then we can get the binary data from
> > > > spreadsheet if need to save the spreadsheet to excel again.
> > > >   The binary data will not impact the open/save... of the ODF
> > format
> > > > application, it will not be touched when we operate the ODF formant
> > > > applications. The binary data will be just used when we want to save
> > the
> > > > spreadsheet to excel, it is just a data prestore about saving
> > spreadsheet
> > > > macros to excel.
> > > >Can you give some advice about the solution?
> > > >Any feedback will be preciated, thanks.
> > > >
> > >
> > >
> > >
> > > --
> > >
> > > Best Regards,Jianhong Cheng
> > >
> >
>
>
>
> --
>
> Best Regards,Jianhong Cheng
>

[Call-for-Review] Issue 119567 - WMF graphic size changed too small to see if saved by AOO

2012-07-03 Thread ZuoJun Chen

Hi all,

 I have a fix to for bug 119567,  please review the patch attached to:

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


Regards - Zuojun

Re: [PROPOSAL] Create ooo-l...@incubator.apache.org

2012-07-03 Thread Graham Lauder

> I suggested this on the list a few weeks ago.  I'd like to now move
> forward with it.

+1 to the list and +1 to L10n that is recognised as the dimunition of 
localisation amongst translators  


> 
> I'll volunteer to be one of the list moderators.  But I need 2-3 other
> committers to volunteer as well.  Let me know if you can help.

I can help moderate that or at least I can handle the english garbage. For  
the rest I'll need a bit of help fom google translate if no native speaker of 
the language in question is moderating. 

Cheers
GL


> 
> l10n = localization or localisation, depending on where you went to school.
> 
> The purpose of the list would be coordination of the localization
> efforts, including translation, for AOO.  Another purpose would be for
> coaching new translators on the project., helping them to get started
> and productive with our tools.
> 
> In other words, rather than ooo-dev's "drink from the fire hose"
> approach, where power-user email filtering skills are necessary to
> preserve sanity, let's offer a more focused collaboration environment
> for translators
> 
> -Rob

Re: CMS anonymous user improvements

On Mon, Jul 2, 2012 at 6:53 PM, Kay Schenk  wrote:
> On Mon, Jul 2, 2012 at 2:41 PM, Rob Weir  wrote:
>
>> On Sun, Jun 24, 2012 at 8:47 AM, Joe Schaefer 
>> wrote:
>> > This weekend David Blevins and I worked on streamlining
>> > the anonymous user support in the CMS.  Two major improvements
>> > are the introduction of "Quick Mail" and anonymous clones.
>> >
>> > Quick Mail is the analog of Quick Commit but for anonymous
>> > users- it is enabled by default and makes submitting patches
>> > to the mailing list much easier to execute.  The mailout will
>> > contain a url for committers to use that permits a committer
>> > to clone the working copy of the anonymous user, so all you'd
>> > need to do is review the change in the CMS and commit it.
>> >
>> > Would be nice if Rob or someone created a video tutorial for this
>> > that's geared toward anon users and showed off these new features.
>>
>> http://www.youtube.com/watch?v=7fvg1pfHLhE
>>
>> >
>>
>
> Hi Rob --
>
> I couldn't read this one as clearly as your first. You used some sort of
> zoom mechanism on the first one I think, and also there seemed to be some
> text annotations on the first one with actual bookmarlet URL that this one
> doesn't have.
>

I'm still learning the tool (Camtasia)  It looks like if you do the
original recording at a higher resolution than the output resolution
then you can tell it to automatically zoom in to area where your mouse
is.  But in this case my recording resolution is the same as the
output resolution, so no zooming is possible.

But I can add text annotations, arrows, etc.

-Rob

> So good information, but difficult to see. Sorry.
>
> --
> 
> MzK
>
> "I would rather have a donkey that takes me there
>  than a horse that will not fare."
>   -- Portuguese proverb

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Simon Phipps

On 3 Jul 2012, at 14:19, Rob Weir wrote:

> On Tue, Jul 3, 2012 at 8:58 AM, Bjoern Michaelsen
>  wrote:
>> Hi Rob,
>> 
>> On Tue, Jul 03, 2012 at 07:53:25AM -0400, Rob Weir wrote:
>>> On Tue, Jul 3, 2012 at 7:17 AM, Bjoern Michaelsen
>>>  wrote:
 Hi all,

 back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
 be convenient not having to recreate. According to:

 http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E

 ownership of the CWS is now at ASF. So two simple questions:

>>> 
>>> Where do you read that?  I don't see that statement.  I see Andrew
>>> saying, "We are trying to provide all of the Oracle owned content in
>>> the OOo repositories."  "Trying" is not the same as an SGA.  I'm
>>> trying to lose weight.  But I can assure you my doctor will trust what
>>> the scale says more than my stated intentions.

Please can we have an update on that effort to get all the CWS made available 
then? It seems a perfectly reasonable request, one I and others have been 
making here since the inception of the project and one I am not able to go 
negotiate personally so need to keep asking about here. 

S.

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

2012-07-03 Thread Yi Xuan Liu

Yes, I'll write a wiki to explain PVT in detail. And send the wiki link
later.

On Tue, Jul 3, 2012 at 5:29 PM, Andre Fischer  wrote:

> On 03.07.2012 09:02, Herbert Duerr wrote:
>
>> |-|---**|---|-**
>>> |
>>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
>>> | |   | Complex | 1.13/ 0.03  |
>>> |-|---**|---|-**
>>> |
>>> [...]
>>>   Any comment is welcomed!
>>>
>>
>> Thanks for sharing this interesting data.
>> I haven't found an explanation what these numbers mean though, so I have
>> to guess: The first number is the average value and the second is the
>> sigma value for running the test, right?
>>
>
> It would be good to put any explanation/documentation on the wiki page or
> else the information about the test parameters from the first mail -- (8
> runs, average over 5), what is plain or complex -- would be lost.
>
> -Andre
>

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

2012-07-03 Thread Yi Xuan Liu

The reason of removing the first round result is that we found that the
first round result is much different from other rounds. It is usually
slower to open the sample file at the first time. So, we could view the
first round result as an outlier and removed it when computing the average
and standard deviation.  However, the first round is also important for
user experience. Maybe, we could list the first round performance
separately.

As for the second value, t-test is a good suggestion and I'll research on
it and use it in the following test. Thanks!


On Tue, Jul 3, 2012 at 7:41 PM, Rob Weir  wrote:

> On Tue, Jul 3, 2012 at 6:39 AM, Linyi Li  wrote:
> > From Xuan Xuan's introduction in the beginning, I think the first data is
> > average value of the test results and the second data is the standard
> > deviation.
> >
>
> So why skip the numbers for the first round test?  Isn't that what
> real users see, the first round?  Sure, it will be slower as code is
> loaded into memory, files read from disk, etc.  But the same thing
> happens for users.
>
> Also, I think the interesting 2nd number is the "standard error of the
> mean", which == std deviation / sqrt(count of measurements).  That is
> what gives the error bars (confidence interval) on the measurement.
> For example, 95% confidence limits on a measurement would be:
>
> lower bound = mean - 1.96*standard_error
> upper bound = mean + 1.96*standard_error
>
> And easy "rule of thumb" is to compare the "before" and "after"
> measures and see if there is overlap in the intervals.
>
> For example:
>
> Before interval: (1.0, 2.0)
> After interval: (1.5, 2.5)
>
> Because the intervals overlap, there might not be a significant
> difference between the two.
>
> But:
>
> Before interval: (1.0, 2.0)
> After interval: (2.5, 3.5)
>
> In this case there is a clear difference, because the confidence
> intervals do not overlap.
>
> A t-test could also be used here, but the above approach works well in
> Calc if you use the "stock 2" type chart.  This has series for
> high/low/close/open.  So you could do something where the high and low
> values are 95% confidence intervals.  This makes it easy to tell what
> is important from a glance.
>
> -Rob
>
> >
> > On Tue, Jul 3, 2012 at 5:36 PM, Ji Yan  wrote:
> >
> >> I'm sure Yi Xuan will update her wiki page with detail test case and the
> >> meaning of report data
> >>
> >> 2012/7/3 Andre Fischer 
> >>
> >> > On 03.07.2012 09:02, Herbert Duerr wrote:
> >> >
> >> >> |-|---**|---|-**
> >> >>> |
> >> >>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
> >> >>> | |   | Complex | 1.13/ 0.03  |
> >> >>> |-|---**|---|-**
> >> >>> |
> >> >>> [...]
> >> >>>   Any comment is welcomed!
> >> >>>
> >> >>
> >> >> Thanks for sharing this interesting data.
> >> >> I haven't found an explanation what these numbers mean though, so I
> have
> >> >> to guess: The first number is the average value and the second is the
> >> >> sigma value for running the test, right?
> >> >>
> >> >
> >> > It would be good to put any explanation/documentation on the wiki
> page or
> >> > else the information about the test parameters from the first mail --
> (8
> >> > runs, average over 5), what is plain or complex -- would be lost.
> >> >
> >> > -Andre
> >> >
> >>
> >>
> >>
> >> --
> >>
> >>
> >> Thanks & Best Regards, Yan Ji
> >>
> >
> >
> >
> > --
> > Best wishes.
> > Linyi Li
>

Re: CWS swbookmarkfixes01 rebasing and licensing

2012-07-03 Thread Oliver-Rainer Wittmann

Hi Björn,

On 03.07.2012 14:58, Bjoern Michaelsen wrote:

Hi Rob,

On Tue, Jul 03, 2012 at 07:53:25AM -0400, Rob Weir wrote:

On Tue, Jul 3, 2012 at 7:17 AM, Bjoern Michaelsen
wrote:

Hi all,

back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
be convenient not having to recreate. According to:

http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E

ownership of the CWS is now at ASF. So two simple questions:

Where do you read that? I don't see that statement. I see Andrew
saying, "We are trying to provide all of the Oracle owned content in
the OOo repositories." "Trying" is not the same as an SGA. I'm
trying to lose weight. But I can assure you my doctor will trust what
the scale says more than my stated intentions.

Your aggressive tone isnt helpful here, but if you want it like that -- fine:
If you are "trying" to clarify the situation, you fail badly. You can easily
correct that: Just state what exactly is covered by a SGA -- I can then ask
Oracle directly to grant the rights for the stuff that is missing. As it, you
make it appear as if the AOO project has no clue what parts of the old OOo code
it actually owns.

Come down a little bit.

I did not see any aggressive tone in Rob's reply.
He asked a question. Gives his view on the topic - more or less the facts he is
seeing. Then he uses a little story from his own life regarding term "Trying" in
order to express that measured numbers respectively contracts "count more" than
humans expressing their "Trying". I did not see any agressive words used by Rob
in the reply.

Best regards, Oliver.

- Is this (my) work in this CWS released under AL2 to the public already with
this?
- If not and I do the work to re-base this CWS against master, and have it
checked into an Apache SVN branch will the work then be immediately
available under the ALv2 license?

You say "(my) work". If it is indeed your IP, then you can do with it
as you wish, right?

No. If you nitpick, get your facts right. The work was created as I was a
german employee of Oracle. IANAL, but as Urheberrecht (copyright, the claim to
authorship) is inalienable in Germany. At that point in time, Oracle had the
exclusive right of use for the work, but AFAIK it is still _my_ work.

You could make it ALv2 with or without checking
it into SVN. But if it is not your IP, and your right to contribute
the code is questionable, then checking it into SVN would just provoke
someone to delete the code.

How about, instead of wasting posts with sentences with way to many
conditionals, you simply answer if this was covered by the SGA, so I know if I
should hassle Oracle with that again (which I might or might not do as the CWS
is hardly mission critcial). If I ask Oracle about this and it turns out Oracle
already handed over code to AOO, but they had to burn ressources on that
because AOO does not seem to be able to come clear with what it owns, that
would throw a rather bad light on AOO, dont you think?

But given the unconstructive reply here, I have to conclude AOO not even
slighty interested in my casual contribution.

Also, isn't this essentially the same question that was raised by
Michael Meeks a couple of months ago? At that point I think the
recommendation was for RedHat or SUSE or TDF to talk to Oracle about
this, since they are the rights owner.

Indeed this seem to be the way to go, I expect to receive a clear "yes" or "no"
from that big corporation sooner that from AOO. Kinda sad and disillusional
actually.

Best,

Bjoern

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

On 7/3/12 3:39 PM, RGB ES wrote:
> 2012/7/3 Jürgen Schmidt :
>> Hi,
>>
>> based on the discussion relating Windows 8 readiness etc. we have
>> identified 5 critical issues. And we have already started to work on
>> these issues and my plan is to have them all ready for a 3.4.1 that we
>> can decide at any time later if we want to move forward with the W8
>> support when we have everything in place in time.
>>
>> For solving one of these issues we have to introduce a new warning box
>> which means that we have to translate a new string for 3.4.1.
>>
>> I have updated the Pootle server already with the new string (17 words
>> only) and I would like to ask our translators to focus on this new
>> string as soon as possible (ideally this week).
>>
>> Most important are the languages that we want release:
>>
>> en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
>>
>> and potentially "sk" where I have to update Pootle with the latest
>> available updates from Michal Hriň
>>
>> The new string is in desktop - source - app.po
>>
>> See for example for French"
>>
>> desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
>>
>> https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
>>
>> "de" will be covered by myself ;-) because there is currently a problem
>> that I don't understand and that I have to solve.
>>
>> To simplify the update I would prefer if the string get translated on
>> the Pootle server.
>>
>> Please send me a short note when an updated or better a translation of
>> the string is available. I will take care of the integration.
>>
>> If anybody have problems doing it on Pootle please let me know.
>>
>>
>> Juergen
>>
> 
> The ES translation is ready.
> 
> A particular thing I've seen is that when I translated that string and
> click "send", two more strings were offered to translate, but both, on
> the original English version were empty with only a space on it. I did
> not take note about the "string" location, sorry.

thanks for the info, I noticed similar behavior that I don't understand
yet. Will keep you informed when I know more.

Juergen

> 
> Regards
> Ricardo
>

Re: [TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

2012-07-03 Thread RGB ES

2012/7/3 Jürgen Schmidt :
> Hi,
>
> based on the discussion relating Windows 8 readiness etc. we have
> identified 5 critical issues. And we have already started to work on
> these issues and my plan is to have them all ready for a 3.4.1 that we
> can decide at any time later if we want to move forward with the W8
> support when we have everything in place in time.
>
> For solving one of these issues we have to introduce a new warning box
> which means that we have to translate a new string for 3.4.1.
>
> I have updated the Pootle server already with the new string (17 words
> only) and I would like to ask our translators to focus on this new
> string as soon as possible (ideally this week).
>
> Most important are the languages that we want release:
>
> en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW
>
> and potentially "sk" where I have to update Pootle with the latest
> available updates from Michal Hriň
>
> The new string is in desktop - source - app.po
>
> See for example for French"
>
> desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text
>
> https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated
>
> "de" will be covered by myself ;-) because there is currently a problem
> that I don't understand and that I have to solve.
>
> To simplify the update I would prefer if the string get translated on
> the Pootle server.
>
> Please send me a short note when an updated or better a translation of
> the string is available. I will take care of the integration.
>
> If anybody have problems doing it on Pootle please let me know.
>
>
> Juergen
>

The ES translation is ready.

A particular thing I've seen is that when I translated that string and
click "send", two more strings were offered to translate, but both, on
the original English version were empty with only a space on it. I did
not take note about the "string" location, sorry.

Regards
Ricardo

Re: Updated Slovak translations

On 7/3/12 2:31 PM, Michal Hriň wrote:
> 
> 
> 
> 
> -Original Message-
> From: Jürgen Schmidt 
> To: ooo-dev 
> Sent: Tue, Jul 3, 2012 12:55 pm
> Subject: Re: Updated Slovak translations
> 
> 
> On 6/30/12 7:17 PM, Michal Hriň wrote:
>>
>> Hi everyone,
>>
>> Here is checked and updated Slovak translations for UI of AOO 3.4.
>>
>> http://st.fri.uniza.sk/~hrin/aoo34_sk_po.tar.gz
>>
>> I overseen the help files in the package, but we never had it translated at 
> time of Oracle/Sun.
>> (translating of help files took more time)
>>
>> I ll be glad if you create a Slovakian build of AOO, or a separated language 
> pack.
>>
>> Regards,
>> Michal Hriň (solo translator - all people works for Libre I think)
> 
> I will update Pootle with your changes and the merge it with the new
> templates that introduce 1 further warning message (17 words) that you
> hopefully can translate as well when it is available.
> 
> We appreciate your contribution and hope that other will join you to
> translate AOO into Slovak.
> 
> I hope our download numbers motivate some people to join ;-) We should
> promote our project even more and should convince people that we are
> open to anybody and to any contribution.
> 
> 
> Juergen
> 
> 
> Thanks Juergen,
> I see updates on Pootle now. 
> 
> Is there some option how can I download or update translations myself?
> Cause, I haven't got mentioned new words in my computer.
> 

Pootle is updated with the files you have send to me + the new string.

Do you have further updates? If yes how many and can you put them in Pootle?

Juergen

[TRANSLATION][3.4.1]: update Pootle server to include new string for a new warning box

Hi,

based on the discussion relating Windows 8 readiness etc. we have
identified 5 critical issues. And we have already started to work on
these issues and my plan is to have them all ready for a 3.4.1 that we
can decide at any time later if we want to move forward with the W8
support when we have everything in place in time.

For solving one of these issues we have to introduce a new warning box
which means that we have to translate a new string for 3.4.1.

I have updated the Pootle server already with the new string (17 words
only) and I would like to ask our translators to focus on this new
string as soon as possible (ideally this week).

Most important are the languages that we want release:

en-US ar cs de en-GB es fi fr gl hu it ja km nl ru sl pt-BR zh-CN zh-TW

and potentially "sk" where I have to update Pootle with the latest
available updates from Michal Hriň

The new string is in desktop - source - app.po

See for example for French"

desktop.src#STR_BOOTSTRAP_ERR_MULTISESSION.string.text

https://translate.apache.org/fr/OOo_34/translate.html?unitstates=fuzzy,untranslated

"de" will be covered by myself ;-) because there is currently a problem
that I don't understand and that I have to solve.

To simplify the update I would prefer if the string get translated on
the Pootle server.

Please send me a short note when an updated or better a translation of
the string is available. I will take care of the integration.

If anybody have problems doing it on Pootle please let me know.


Juergen

Re: CWS swbookmarkfixes01 rebasing and licensing

On Tue, Jul 3, 2012 at 8:58 AM, Bjoern Michaelsen
 wrote:
> Hi Rob,
>
> On Tue, Jul 03, 2012 at 07:53:25AM -0400, Rob Weir wrote:
>> On Tue, Jul 3, 2012 at 7:17 AM, Bjoern Michaelsen
>>  wrote:
>> > Hi all,
>> >
>> > back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
>> > be convenient not having to recreate. According to:
>> >
>> >  
>> > http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E
>> >
>> > ownership of the CWS is now at ASF. So two simple questions:
>> >
>>
>> Where do you read that?  I don't see that statement.  I see Andrew
>> saying, "We are trying to provide all of the Oracle owned content in
>> the OOo repositories."  "Trying" is not the same as an SGA.  I'm
>> trying to lose weight.  But I can assure you my doctor will trust what
>> the scale says more than my stated intentions.
>
> Your aggressive tone isnt helpful here, but if you want it like that -- fine:
> If you are "trying" to clarify the situation, you fail badly. You can easily
> correct that: Just state what exactly is covered by a SGA -- I can then ask
> Oracle directly to grant the rights for the stuff that is missing. As it, you
> make it appear as if the AOO project has no clue what parts of the old OOo 
> code
> it actually owns.
>

Sorry, I thought you knew about the SGA(s) already. The files covered
by the Oracle SGA(s) are listed here:

https://svn.apache.org/repos/asf/incubator/ooo/pmc/ip-review/

That is what was granted to Apache.  Our 3.4 release was based on that
SGA, using the trunk version of those files.  That is what we released
under ALv2.  So in that sense the project very much has a clue what is
covered by ALv2.  We did an extensive audit of this.

I don't think it is advisable to speculate beyond that, concerning
terms on files not included in the SGA, or terms on other revisions of
those files.  What you need in that case is competent legal advice,
not some non-expert comment from someone on a mailing list.  Or talk
to Oracle.

Regards,

-Rob

Re: CWS swbookmarkfixes01 rebasing and licensing

Hi Rob,

On Tue, Jul 03, 2012 at 07:53:25AM -0400, Rob Weir wrote:
> On Tue, Jul 3, 2012 at 7:17 AM, Bjoern Michaelsen
>  wrote:
> > Hi all,
> >
> > back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
> > be convenient not having to recreate. According to:
> >
> >  
> > http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E
> >
> > ownership of the CWS is now at ASF. So two simple questions:
> >
> 
> Where do you read that?  I don't see that statement.  I see Andrew
> saying, "We are trying to provide all of the Oracle owned content in
> the OOo repositories."  "Trying" is not the same as an SGA.  I'm
> trying to lose weight.  But I can assure you my doctor will trust what
> the scale says more than my stated intentions.

Your aggressive tone isnt helpful here, but if you want it like that -- fine:
If you are "trying" to clarify the situation, you fail badly. You can easily
correct that: Just state what exactly is covered by a SGA -- I can then ask
Oracle directly to grant the rights for the stuff that is missing. As it, you
make it appear as if the AOO project has no clue what parts of the old OOo code
it actually owns.

> > - Is this (my) work in this CWS released under AL2 to the public already 
> > with
> >   this?
> > - If not and I do the work to re-base this CWS against master, and have it
> >   checked into an Apache SVN branch will the work then be immediately
> >   available under the ALv2 license?
> >
> 
> You say "(my) work".  If it is indeed your IP, then you can do with it
> as you wish, right?  

No. If you nitpick, get your facts right. The work was created as I was a
german employee of Oracle. IANAL, but as Urheberrecht (copyright, the claim to
authorship) is inalienable in Germany. At that point in time, Oracle had the
exclusive right of use for the work, but AFAIK it is still _my_ work.

> You could make it ALv2 with or without checking
> it into SVN.  But if it is not your IP, and your right to contribute
> the code is questionable, then checking it into SVN would just provoke
> someone to delete the code.

How about, instead of wasting posts with sentences with way to many
conditionals, you simply answer if this was covered by the SGA, so I know if I
should hassle Oracle with that again (which I might or might not do as the CWS
is hardly mission critcial). If I ask Oracle about this and it turns out Oracle
already handed over code to AOO, but they had to burn ressources on that
because AOO does not seem to be able to come clear with what it owns, that
would throw a rather bad light on AOO, dont you think?

But given the unconstructive reply here, I have to conclude AOO not even
slighty interested in my casual contribution. 

> Also, isn't this essentially the same question that was raised by
> Michael Meeks a couple of months ago?   At that point I think the
> recommendation was for RedHat or SUSE or TDF to talk to Oracle about
> this, since they are the rights owner.

Indeed this seem to be the way to go, I expect to receive a clear "yes" or "no"
from that big corporation sooner that from AOO. Kinda sad and disillusional
actually.

Best,

Bjoern

Re: Updated Slovak translations

2012-07-03 Thread Michal Hriň

-Original Message-
From: Jürgen Schmidt 
To: ooo-dev 
Sent: Tue, Jul 3, 2012 12:55 pm
Subject: Re: Updated Slovak translations

On 6/30/12 7:17 PM, Michal Hriň wrote:
> 
> Hi everyone,
> 
> Here is checked and updated Slovak translations for UI of AOO 3.4.
> 
> http://st.fri.uniza.sk/~hrin/aoo34_sk_po.tar.gz
> 
> I overseen the help files in the package, but we never had it translated at 
time of Oracle/Sun.
> (translating of help files took more time)
> 
> I ll be glad if you create a Slovakian build of AOO, or a separated language 
pack.
> 
> Regards,
> Michal Hriň (solo translator - all people works for Libre I think)

I will update Pootle with your changes and the merge it with the new
templates that introduce 1 further warning message (17 words) that you
hopefully can translate as well when it is available.

We appreciate your contribution and hope that other will join you to
translate AOO into Slovak.

I hope our download numbers motivate some people to join ;-) We should
promote our project even more and should convince people that we are
open to anybody and to any contribution.

Juergen

Thanks Juergen,
I see updates on Pootle now. 

Is there some option how can I download or update translations myself?
Cause, I haven't got mentioned new words in my computer.

Regards,
Michal Hriň

[Call-for-Review]Bug 119887 - [From Symphony]Shape shadow position changed incorrect if open the ppt doc via AOO

2012-07-03 Thread Jianyuan Li

Hi, all

 I have a fix for bug 119887(
https://issues.apache.org/ooo/show_bug.cgi?id=119887 )
 Could anyone help me to review?


Regard,
Jianyuan

Re: CWS swbookmarkfixes01 rebasing and licensing

On Tue, Jul 3, 2012 at 7:17 AM, Bjoern Michaelsen
 wrote:
> Hi all,
>
> back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
> be convenient not having to recreate. According to:
>
>  
> http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E
>
> ownership of the CWS is now at ASF. So two simple questions:
>

Where do you read that?  I don't see that statement.  I see Andrew
saying, "We are trying to provide all of the Oracle owned content in
the OOo repositories."  "Trying" is not the same as an SGA.  I'm
trying to lose weight.  But I can assure you my doctor will trust what
the scale says more than my stated intentions.

> - Is this (my) work in this CWS released under AL2 to the public already with
>   this?
> - If not and I do the work to re-base this CWS against master, and have it
>   checked into an Apache SVN branch will the work then be immediately
>   available under the ALv2 license?
>

You say "(my) work".  If it is indeed your IP, then you can do with it
as you wish, right?  You could make it ALv2 with or without checking
it into SVN.  But if it is not your IP, and your right to contribute
the code is questionable, then checking it into SVN would just provoke
someone to delete the code.

In any case, the act of checking in the code does not give the
committer any more rights to set a license on the code then they
started with.

Also, isn't this essentially the same question that was raised by
Michael Meeks a couple of months ago?   At that point I think the
recommendation was for RedHat or SUSE or TDF to talk to Oracle about
this, since they are the rights owner.

-Rob

> Best,
>
> Bjoern

Re: Stop driving people away (was: [PROPOSAL] Create ooo-l...@incubator.apache.org)

On 7/3/12 12:23 PM, Sam Ruby wrote:
> On Tue, Jul 3, 2012 at 1:16 AM, Jürgen Schmidt
>  wrote:
>> On 7/3/12 4:09 AM, Sam Ruby wrote:
>>> On Mon, Jul 2, 2012 at 2:54 PM, Rob Weir  wrote:

 Your loss.
>>>
>>> I encourage you to rethink that response.
>>
>> And I would like to encourage people to rethink their comments as well
>> because other comments are more provocative and absolutely useless from
>> my point of view.
> 
> The request for a new thread is reasonable.
> 
> As to any and all comments that may be more provocative and/or
> absolutely useless: I encourage the PPMC to find ways to address them
> too.
> 
> The goals here are to build a community and to become self-governing.

exactly, and one very important thing in building communities is the
active participation in the work that have to be done in the many
different areas here in the project. Everybody who is interested to
active participating in the project can find it's niche and can start
doing something. Don't expect that somebody else is doing the work for
you. If you need help, explain your needs and convince others to help you.

It is important to learn from past misbehavior, bad discussion or other
general mistakes and try to improve things over time. It is completely
useless to make insinuations about former mistakes or misbehavior etc.
that potentially force emotional reactions or something like that.

I think we all have a common goal and we should focus on constructive
collaboration to move the project forward.

I know it is not always easy and I personally have to reflect my own
behavior from time to time. But I am anxious to improve myself.

In the end I am watching what people are doing in and for the project
and try to build my own picture of people. I can't make it perfect for
everybody but I am trying to work with everybody who is willing to work
with me ;-) The project is huge and will hopefully become bigger. It is
important that we have respect for each other and work together.

I don't see that we drive people away but if it is really the case then
I would like to hear about it from the people who leave the project
first hand. If people are not able to raise their concerns on the
mailing list it is impossible for others to understand and to change
something. Important is the direct communication on the mailing list and
not via any proxies like our mentors.

Humans are different with very different personalities and we are from
different countries with different cultures but we all have a common
goal. We should remember this!

Juergen

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

On Tue, Jul 3, 2012 at 6:39 AM, Linyi Li  wrote:
> From Xuan Xuan's introduction in the beginning, I think the first data is
> average value of the test results and the second data is the standard
> deviation.
>

So why skip the numbers for the first round test?  Isn't that what
real users see, the first round?  Sure, it will be slower as code is
loaded into memory, files read from disk, etc.  But the same thing
happens for users.

Also, I think the interesting 2nd number is the "standard error of the
mean", which == std deviation / sqrt(count of measurements).  That is
what gives the error bars (confidence interval) on the measurement.
For example, 95% confidence limits on a measurement would be:

lower bound = mean - 1.96*standard_error
upper bound = mean + 1.96*standard_error

And easy "rule of thumb" is to compare the "before" and "after"
measures and see if there is overlap in the intervals.

For example:

Before interval: (1.0, 2.0)
After interval: (1.5, 2.5)

Because the intervals overlap, there might not be a significant
difference between the two.

But:

Before interval: (1.0, 2.0)
After interval: (2.5, 3.5)

In this case there is a clear difference, because the confidence
intervals do not overlap.

A t-test could also be used here, but the above approach works well in
Calc if you use the "stock 2" type chart.  This has series for
high/low/close/open.  So you could do something where the high and low
values are 95% confidence intervals.  This makes it easy to tell what
is important from a glance.

-Rob

>
> On Tue, Jul 3, 2012 at 5:36 PM, Ji Yan  wrote:
>
>> I'm sure Yi Xuan will update her wiki page with detail test case and the
>> meaning of report data
>>
>> 2012/7/3 Andre Fischer 
>>
>> > On 03.07.2012 09:02, Herbert Duerr wrote:
>> >
>> >> |-|---**|---|-**
>> >>> |
>> >>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
>> >>> | |   | Complex | 1.13/ 0.03  |
>> >>> |-|---**|---|-**
>> >>> |
>> >>> [...]
>> >>>   Any comment is welcomed!
>> >>>
>> >>
>> >> Thanks for sharing this interesting data.
>> >> I haven't found an explanation what these numbers mean though, so I have
>> >> to guess: The first number is the average value and the second is the
>> >> sigma value for running the test, right?
>> >>
>> >
>> > It would be good to put any explanation/documentation on the wiki page or
>> > else the information about the test parameters from the first mail -- (8
>> > runs, average over 5), what is plain or complex -- would be lost.
>> >
>> > -Andre
>> >
>>
>>
>>
>> --
>>
>>
>> Thanks & Best Regards, Yan Ji
>>
>
>
>
> --
> Best wishes.
> Linyi Li

CWS swbookmarkfixes01 rebasing and licensing

Hi all,

back in my Oracle days I did some work in CWS swbookmarkfixes01 which would
be convenient not having to recreate. According to:

 
http://mail-archives.apache.org/mod_mbox/incubator-general/201106.mbox/%3cbanlktikvbfnr1viwqyw1+spzf68zx5g...@mail.gmail.com%3E

ownership of the CWS is now at ASF. So two simple questions:

- Is this (my) work in this CWS released under AL2 to the public already with
  this?
- If not and I do the work to re-base this CWS against master, and have it
  checked into an Apache SVN branch will the work then be immediately
  available under the ALv2 license?

Best,

Bjoern

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

On Mon, Jul 2, 2012 at 4:33 AM, Chen Peng  wrote:
> Hi All,
>   My name is Chen Peng, I am a developer from Symphony. My special
> areas are VBA and sw.
>   Now I found an issue about macros lost:
>  I saved an excel file with VBA to spreadsheet, the VBA can work
> well in spreadsheet, then I wanted to save this spreadsheet back to excel,
> but all the macros are lost.

How common is this scenario?   Wouldn't the more typical user action
be to re-save the document back to XLS format?  Isn't that what
happens by default when they do a save when editing an XLS file? If
the user does this, will the macro be saved correctly?

>   I propose to save the binary data of excel VBA to spreadsheet, when
> saving excel to spreadsheet, then we can get the binary data from
> spreadsheet if need to save the spreadsheet to excel again.
>   The binary data will not impact the open/save... of the ODF format
> application, it will not be touched when we operate the ODF formant
> applications. The binary data will be just used when we want to save the
> spreadsheet to excel, it is just a data prestore about saving spreadsheet
> macros to excel.
>Can you give some advice about the solution?
>Any feedback will be preciated, thanks.

Re: Updated Slovak translations

On 6/30/12 7:17 PM, Michal Hriň wrote:
> 
> Hi everyone,
> 
> Here is checked and updated Slovak translations for UI of AOO 3.4.
> 
> http://st.fri.uniza.sk/~hrin/aoo34_sk_po.tar.gz
> 
> I overseen the help files in the package, but we never had it translated at 
> time of Oracle/Sun.
> (translating of help files took more time)
> 
> I ll be glad if you create a Slovakian build of AOO, or a separated language 
> pack.
> 
> Regards,
> Michal Hriň (solo translator - all people works for Libre I think)

I will update Pootle with your changes and the merge it with the new
templates that introduce 1 further warning message (17 words) that you
hopefully can translate as well when it is available.

We appreciate your contribution and hope that other will join you to
translate AOO into Slovak.

I hope our download numbers motivate some people to join ;-) We should
promote our project even more and should convince people that we are
open to anybody and to any contribution.

Juergen

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

2012-07-03 Thread Linyi Li

>From Xuan Xuan's introduction in the beginning, I think the first data is
average value of the test results and the second data is the standard
deviation.


On Tue, Jul 3, 2012 at 5:36 PM, Ji Yan  wrote:

> I'm sure Yi Xuan will update her wiki page with detail test case and the
> meaning of report data
>
> 2012/7/3 Andre Fischer 
>
> > On 03.07.2012 09:02, Herbert Duerr wrote:
> >
> >> |-|---**|---|-**
> >>> |
> >>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
> >>> | |   | Complex | 1.13/ 0.03  |
> >>> |-|---**|---|-**
> >>> |
> >>> [...]
> >>>   Any comment is welcomed!
> >>>
> >>
> >> Thanks for sharing this interesting data.
> >> I haven't found an explanation what these numbers mean though, so I have
> >> to guess: The first number is the average value and the second is the
> >> sigma value for running the test, right?
> >>
> >
> > It would be good to put any explanation/documentation on the wiki page or
> > else the information about the test parameters from the first mail -- (8
> > runs, average over 5), what is plain or complex -- would be lost.
> >
> > -Andre
> >
>
>
>
> --
>
>
> Thanks & Best Regards, Yan Ji
>



-- 
Best wishes.
Linyi Li

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

That doesn't matter that you think they are VBA or Star Basic when saving a
xls with VBA as ods file..To some APIs with behavior difference,they will
be distinguished with the line "Option VBASupport 1" at the beginning..End
users can modify the Star Basic codes in AOO Spreadsheet,but all Star Basic
contents including original and modified will be lost when exporting to xls
file..Here,if the ods file is converted from a xls file based on Peng's
solution,the behavior is still kept unchanged...The only difference is that
the saved binary VBA streams within the ods file will be exported to the
xls file at that time.Thus,when end users launch the xls file in MS
Excel,the original VBA will be there.That's the expected result.thanks.

On Tue, Jul 3, 2012 at 5:02 PM, Lei Wang  wrote:

> Jian Hong,
>
> Will AOO save VBA as Star Basic in ods file when saving a xls file with VBA
> as ods file? If it is true, can user modify the Star Basic in the new ods
> file? What happened if user change the Star Basic in the ods file then save
> as a xls file?
>
> On Tue, Jul 3, 2012 at 3:57 PM, chengjh  wrote:
>
> > Hi Peng,
> >
> > Let me use a scenario to confirm your problem,solution and
> > question..Anything misunderstood,please correct me.thanks.
> >
> > Problem:
> > When AOO launches an excel document with VBA,saves to ods and then saves
> to
> > excel again,the VBA info will be lost.
> >
> > Solution:
> > a)The VBA streams of an excel document will be saved into the ods
> document
> > with binary format when converting an excel document to an ods document
> in
> > AOO Spreadsheet with certain controller.
> > b)Once the ods document containing the binary VBA streams is launched
> into
> > AOO or previous releases,with certain controller,the binary VBA steams
> will
> > be loaded[still binary stream in memory] or rejected..There is no any
> > impact on the application,the application can still work well.
> > c)Based on b),if the ods document is saved to an excel document,the
> binary
> > VBA streams will be exported, thus, the VBA info will not be lost.
> >
> > Question:
> > You are not sure whether this solution is reasonable. So, you want to
> know
> > the comments about your solution. If no comments, you will do so to
> > implement it.
> >
> > On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng 
> wrote:
> >
> > > Hi All,
> > >   My name is Chen Peng, I am a developer from Symphony. My special
> > > areas are VBA and sw.
> > >   Now I found an issue about macros lost:
> > >  I saved an excel file with VBA to spreadsheet, the VBA can
> work
> > > well in spreadsheet, then I wanted to save this spreadsheet back to
> > excel,
> > > but all the macros are lost.
> > >   I propose to save the binary data of excel VBA to spreadsheet,
> when
> > > saving excel to spreadsheet, then we can get the binary data from
> > > spreadsheet if need to save the spreadsheet to excel again.
> > >   The binary data will not impact the open/save... of the ODF
> format
> > > application, it will not be touched when we operate the ODF formant
> > > applications. The binary data will be just used when we want to save
> the
> > > spreadsheet to excel, it is just a data prestore about saving
> spreadsheet
> > > macros to excel.
> > >Can you give some advice about the solution?
> > >Any feedback will be preciated, thanks.
> > >
> >
> >
> >
> > --
> >
> > Best Regards,Jianhong Cheng
> >
>



-- 

Best Regards,Jianhong Cheng

Stop driving people away (was: [PROPOSAL] Create ooo-l...@incubator.apache.org)

2012-07-03 Thread Sam Ruby

On Tue, Jul 3, 2012 at 1:16 AM, Jürgen Schmidt
 wrote:
> On 7/3/12 4:09 AM, Sam Ruby wrote:
>> On Mon, Jul 2, 2012 at 2:54 PM, Rob Weir  wrote:
>>>
>>> Your loss.
>>
>> I encourage you to rethink that response.
>
> And I would like to encourage people to rethink their comments as well
> because other comments are more provocative and absolutely useless from
> my point of view.

The request for a new thread is reasonable.

As to any and all comments that may be more provocative and/or
absolutely useless: I encourage the PPMC to find ways to address them
too.

The goals here are to build a community and to become self-governing.

- Sam Ruby

Re: [QA] request to check update of installed OOo 3.2 and OOo 3.2.1 to AOO 3.4

2012-07-03 Thread Oliver-Rainer Wittmann

Hi,

On 03.07.2012 11:35, Ji Yan wrote:
> Recently, I test update services for both OO3.2/3.2.1/3.3 and find some
> interesting result:
> 1. For OO 3.3
>  a. As I test several language packages(en-US/zh-CN/Ja), update services
> works fine on Windows and Mac.
>  b. There is no menu "Check for Updates.." in Linux. Is this design?
> 2. For OO 3.2 and OO 3.2.1
> All the check update test failed.
> OO 3.2.1(OOO320M18 Build:9502) RPM DE version
> Problem: Could not establish Internet connection to
> update35.services.openoffice.org
> OO 3.2.0(OOO320m12 Build: 9483) DEB EN version
> Problem: "Check for Updates.." menu is unavailable.
> OO 3.2.0(OOO320m12 Build: 9483) DMG EN version
> Problem: Could not establish Internet connection to
> update34.services.openoffice.org
> OO 3.2.1(OOO320m19 Build:9505) MSI KU version
> Problem: "Check for Updates.." menu is unavailable
> OO 3.2.0(OOO320m12 Build:9483) MSI NN version
> Problem: Could not establish Internet connection to
> update34.services.openoffice.org
> 
> Is the update server down these days? and also could somebody check why
> "Check for Updates.." menu is not always exist?
> 

I think there is a misunderstanding, because I expressed myself not clear 
enough.

Yes, the update service for OOo 3.2 and OOo 3.2.1 is not running.
I have proposed to activate it.

Before I activated it, we need to check, if the manual update of OOo 3.2/OOo
3.2.1 works. Thus, I was asking for checking the following:
- take a system with OOo 3.2 or OOo 3.2.1 installed.
- download manually an AOO 3.4 installation package.
- install the AOO 3.4 installation package in order to update installed OOo
3.2/OOo 3.2.1
- give feedback, if update of OOo 3.2/OOo 3.2.1 by AOO 3.4 works fine or not.

Sorry that I was not clear enough.

Best regards, Oliver.

> 2012/6/29 Roberto Galoppini 
> 
>> On Thu, Jun 28, 2012 at 4:19 PM, Ji Yan  wrote:
>>> I'll take care of updat test, and let you know result asap.
>>
>> I made the test on an Intel-based Mac, and it works just fine (manual
>> installation of AOO 3.4 on top of OOo 3.2).
>>
>> Roberto
>>
>>> 在 2012-6-28 下午5:35，"Oliver-Rainer Wittmann" >> 写道：
>>>
 Hi,

 as I have proposed to activate the update service for installed OOo 3.2
 and OOo 3.2.1 instances I would like to request that we check, if an
>> update
 of OOo 3.2 and OOo 3.2.1 to AOO 3.4 works.
 Thus, I am asking here for volunteers to perform such an update in their
 environments and to give feedback.

 Thanks a lot in advance.

 Best regards, Oliver.


>>
>> --
>> 
>> This e- mail message is intended only for the named recipient(s) above. It
>> may contain confidential and privileged information. If you are not the
>> intended recipient you are hereby notified that any dissemination,
>> distribution or copying of this e-mail and any attachment(s) is strictly
>> prohibited. If you have received this e-mail in error, please immediately
>> notify the sender by replying to this e-mail and delete the message and any
>> attachment(s) from your system. Thank you.
>>
>>
> 
>

[QA AUTOMATION] Build Verification Test(BVT) test results

2012-07-03 Thread Linyi Li

Hi,

I setup some machines to perform Build Verification Test(BVT). Here is the
test result.

   - Platform:

windows 8
mac 10.7.4
redhat 6.1
ubuntu 10.04
windows 7 x64

   - Build version: trunk build r1355288.
   - Total cases: 41.
   - Found defects: 1.
   https://issues.apache.org/ooo/show_bug.cgi?id=120171

Liu Zhe helped me to put the detailed result to his spac. You can get them
from here: http://people.apache.org/~liuzhe/test/
Thanks Zhe!

About the test results.
logs/Logs of BVT. Recording the executed test cases and
error messages.
report/  Summary of test results. How many test cases were
executed. How many passed, how many failed. Execution time. You can click
on the number in the page to see the relevant test cases.
result/  A .xml file. Recording the whold test process.
screenshot/  If any case is failed, there will be a screenshot to
record failing scenario.

Any comments are welcomed!

-- 
Best wishes.
Linyi Li

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

I'm sure Yi Xuan will update her wiki page with detail test case and the
meaning of report data

2012/7/3 Andre Fischer 

> On 03.07.2012 09:02, Herbert Duerr wrote:
>
>> |-|---**|---|-**
>>> |
>>> | Filter | odt Load Show| Plain   | 0.72/ 0.03  |
>>> | |   | Complex | 1.13/ 0.03  |
>>> |-|---**|---|-**
>>> |
>>> [...]
>>>   Any comment is welcomed!
>>>
>>
>> Thanks for sharing this interesting data.
>> I haven't found an explanation what these numbers mean though, so I have
>> to guess: The first number is the average value and the second is the
>> sigma value for running the test, right?
>>
>
> It would be good to put any explanation/documentation on the wiki page or
> else the information about the test parameters from the first mail -- (8
> runs, average over 5), what is plain or complex -- would be lost.
>
> -Andre
>



-- 


Thanks & Best Regards, Yan Ji

Re: [QA] request to check update of installed OOo 3.2 and OOo 3.2.1 to AOO 3.4

Recently, I test update services for both OO3.2/3.2.1/3.3 and find some
interesting result:
1. For OO 3.3
a. As I test several language packages(en-US/zh-CN/Ja), update services
works fine on Windows and Mac.
b. There is no menu "Check for Updates.." in Linux. Is this design?
2. For OO 3.2 and OO 3.2.1
All the check update test failed.
OO 3.2.1(OOO320M18 Build:9502) RPM DE version
   Problem: Could not establish Internet connection to
update35.services.openoffice.org
OO 3.2.0(OOO320m12 Build: 9483) DEB EN version
   Problem: "Check for Updates.." menu is unavailable.
OO 3.2.0(OOO320m12 Build: 9483) DMG EN version
   Problem: Could not establish Internet connection to
update34.services.openoffice.org
OO 3.2.1(OOO320m19 Build:9505) MSI KU version
   Problem: "Check for Updates.." menu is unavailable
OO 3.2.0(OOO320m12 Build:9483) MSI NN version
   Problem: Could not establish Internet connection to
update34.services.openoffice.org

Is the update server down these days? and also could somebody check why
"Check for Updates.." menu is not always exist?

2012/6/29 Roberto Galoppini 

> On Thu, Jun 28, 2012 at 4:19 PM, Ji Yan  wrote:
> > I'll take care of updat test, and let you know result asap.
>
> I made the test on an Intel-based Mac, and it works just fine (manual
> installation of AOO 3.4 on top of OOo 3.2).
>
> Roberto
>
> > 在 2012-6-28 下午5:35，"Oliver-Rainer Wittmann"  >写道：
> >
> >> Hi,
> >>
> >> as I have proposed to activate the update service for installed OOo 3.2
> >> and OOo 3.2.1 instances I would like to request that we check, if an
> update
> >> of OOo 3.2 and OOo 3.2.1 to AOO 3.4 works.
> >> Thus, I am asking here for volunteers to perform such an update in their
> >> environments and to give feedback.
> >>
> >> Thanks a lot in advance.
> >>
> >> Best regards, Oliver.
> >>
> >>
>
> --
> 
> This e- mail message is intended only for the named recipient(s) above. It
> may contain confidential and privileged information. If you are not the
> intended recipient you are hereby notified that any dissemination,
> distribution or copying of this e-mail and any attachment(s) is strictly
> prohibited. If you have received this e-mail in error, please immediately
> notify the sender by replying to this e-mail and delete the message and any
> attachment(s) from your system. Thank you.
>
>

-- 

Thanks & Best Regards, Yan Ji

3.4.1_release_blocker requested: [Bug 120172] [Crash]After undo delete text box with animation assgined, edit the textbox will cause a crash.

2012-07-03 Thread bugzilla

Yan Ji  has asked  for 3.4.1_release_blocker:
Bug 120172: [Crash]After undo delete text box with animation assgined, edit the
textbox will cause a crash.
https://issues.apache.org/ooo/show_bug.cgi?id=120172


--- Additional Comments from Yan Ji 
Reproduced in AOO 3.4.1 dev snapshot build

Re: [QE] AOO 3.4.1 First Snapshot build PVT Report

2012-07-03 Thread Andre Fischer


On 03.07.2012 09:02, Herbert Duerr wrote:

|-|---|---|-|
| Filter | odt Load Show| Plain   | 0.72/ 0.03  |
| |   | Complex | 1.13/ 0.03  |
|-|---|---|-|
[...]
  Any comment is welcomed!


Thanks for sharing this interesting data.
I haven't found an explanation what these numbers mean though, so I have
to guess: The first number is the average value and the second is the
sigma value for running the test, right?


It would be good to put any explanation/documentation on the wiki page 
or else the information about the test parameters from the first mail -- 
(8 runs, average over 5), what is plain or complex -- would be lost.


-Andre

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

2012-07-03 Thread Lei Wang

Jian Hong,

Will AOO save VBA as Star Basic in ods file when saving a xls file with VBA
as ods file? If it is true, can user modify the Star Basic in the new ods
file? What happened if user change the Star Basic in the ods file then save
as a xls file?

On Tue, Jul 3, 2012 at 3:57 PM, chengjh  wrote:

> Hi Peng,
>
> Let me use a scenario to confirm your problem,solution and
> question..Anything misunderstood,please correct me.thanks.
>
> Problem:
> When AOO launches an excel document with VBA,saves to ods and then saves to
> excel again,the VBA info will be lost.
>
> Solution:
> a)The VBA streams of an excel document will be saved into the ods document
> with binary format when converting an excel document to an ods document in
> AOO Spreadsheet with certain controller.
> b)Once the ods document containing the binary VBA streams is launched into
> AOO or previous releases,with certain controller,the binary VBA steams will
> be loaded[still binary stream in memory] or rejected..There is no any
> impact on the application,the application can still work well.
> c)Based on b),if the ods document is saved to an excel document,the binary
> VBA streams will be exported, thus, the VBA info will not be lost.
>
> Question:
> You are not sure whether this solution is reasonable. So, you want to know
> the comments about your solution. If no comments, you will do so to
> implement it.
>
> On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng  wrote:
>
> > Hi All,
> >   My name is Chen Peng, I am a developer from Symphony. My special
> > areas are VBA and sw.
> >   Now I found an issue about macros lost:
> >  I saved an excel file with VBA to spreadsheet, the VBA can work
> > well in spreadsheet, then I wanted to save this spreadsheet back to
> excel,
> > but all the macros are lost.
> >   I propose to save the binary data of excel VBA to spreadsheet, when
> > saving excel to spreadsheet, then we can get the binary data from
> > spreadsheet if need to save the spreadsheet to excel again.
> >   The binary data will not impact the open/save... of the ODF format
> > application, it will not be touched when we operate the ODF formant
> > applications. The binary data will be just used when we want to save the
> > spreadsheet to excel, it is just a data prestore about saving spreadsheet
> > macros to excel.
> >Can you give some advice about the solution?
> >Any feedback will be preciated, thanks.
> >
>
>
>
> --
>
> Best Regards,Jianhong Cheng
>

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

2012-07-03 Thread Chen Peng

Yes, Jim. Your description is very exact about this topic. Thank you.

2012/7/3 chengjh 

> Hi Peng,
>
> Let me use a scenario to confirm your problem,solution and
> question..Anything misunderstood,please correct me.thanks.
>
> Problem:
> When AOO launches an excel document with VBA,saves to ods and then saves to
> excel again,the VBA info will be lost.
>
> Solution:
> a)The VBA streams of an excel document will be saved into the ods document
> with binary format when converting an excel document to an ods document in
> AOO Spreadsheet with certain controller.
> b)Once the ods document containing the binary VBA streams is launched into
> AOO or previous releases,with certain controller,the binary VBA steams will
> be loaded[still binary stream in memory] or rejected..There is no any
> impact on the application,the application can still work well.
> c)Based on b),if the ods document is saved to an excel document,the binary
> VBA streams will be exported, thus, the VBA info will not be lost.
>
> Question:
> You are not sure whether this solution is reasonable. So, you want to know
> the comments about your solution. If no comments, you will do so to
> implement it.
>
> On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng  wrote:
>
> > Hi All,
> >   My name is Chen Peng, I am a developer from Symphony. My special
> > areas are VBA and sw.
> >   Now I found an issue about macros lost:
> >  I saved an excel file with VBA to spreadsheet, the VBA can work
> > well in spreadsheet, then I wanted to save this spreadsheet back to
> excel,
> > but all the macros are lost.
> >   I propose to save the binary data of excel VBA to spreadsheet, when
> > saving excel to spreadsheet, then we can get the binary data from
> > spreadsheet if need to save the spreadsheet to excel again.
> >   The binary data will not impact the open/save... of the ODF format
> > application, it will not be touched when we operate the ODF formant
> > applications. The binary data will be just used when we want to save the
> > spreadsheet to excel, it is just a data prestore about saving spreadsheet
> > macros to excel.
> >Can you give some advice about the solution?
> >Any feedback will be preciated, thanks.
> >
>
>
>
> --
>
> Best Regards,Jianhong Cheng
>

Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again

Hi Peng,

Let me use a scenario to confirm your problem,solution and
question..Anything misunderstood,please correct me.thanks.

Problem:
When AOO launches an excel document with VBA,saves to ods and then saves to
excel again,the VBA info will be lost.

Solution:
a)The VBA streams of an excel document will be saved into the ods document
with binary format when converting an excel document to an ods document in
AOO Spreadsheet with certain controller.
b)Once the ods document containing the binary VBA streams is launched into
AOO or previous releases,with certain controller,the binary VBA steams will
be loaded[still binary stream in memory] or rejected..There is no any
impact on the application,the application can still work well.
c)Based on b),if the ods document is saved to an excel document,the binary
VBA streams will be exported, thus, the VBA info will not be lost.

Question:
You are not sure whether this solution is reasonable. So, you want to know
the comments about your solution. If no comments, you will do so to
implement it.

On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng  wrote:

> Hi All,
>   My name is Chen Peng, I am a developer from Symphony. My special
> areas are VBA and sw.
>   Now I found an issue about macros lost:
>  I saved an excel file with VBA to spreadsheet, the VBA can work
> well in spreadsheet, then I wanted to save this spreadsheet back to excel,
> but all the macros are lost.
>   I propose to save the binary data of excel VBA to spreadsheet, when
> saving excel to spreadsheet, then we can get the binary data from
> spreadsheet if need to save the spreadsheet to excel again.
>   The binary data will not impact the open/save... of the ODF format
> application, it will not be touched when we operate the ODF formant
> applications. The binary data will be just used when we want to save the
> spreadsheet to excel, it is just a data prestore about saving spreadsheet
> macros to excel.
>Can you give some advice about the solution?
>Any feedback will be preciated, thanks.
>

-- 

Best Regards,Jianhong Cheng

[Call-for-Review] Bug 120140 - [From Symphony]After doc file saved by AOO, one more section is created

2012-07-03 Thread Lin Yuan

I have submitted a patch to fix bug 120140. Something is not correct when
export column break and section break in the MS Word 2003 export filter.
Detail issue info and comments of this issue please refer to
https://issues.apache.org/ooo/show_bug.cgi?id=120140
The patch link is as below
https://issues.apache.org/ooo/attachment.cgi?id=78557

Please help review this fix. Thanks.

Thanks,
Lin Yuan

Re: [Review|Discussion]For Ideas and Comments on the Vision of Writer's Track Changes Improvement