Re: A preservation hazard in OpenOffice

2013-01-08 Thread Joost Andrae

Hi,

Am 07.01.2013 22:53, schrieb Andrea Pescetti:

Joost Andrae wrote:

If somebody has a problem with linked
images within stored files then he/she can easily break these links by
using /edit/links...


Yes, this is the answer to the preservation hazard: just break links;
and there are several macros and perhaps extensions around that just add
a Break all links button to embed all images instead of linking to them.

That said, I think it would be quite reasonable (if there are no UX
problems or major development problems) to do the opposite in OpenOffice
4.0 and break links by default, since this happens to be the standard
expectation many users have.

For the record, the relevant issue is
https://issues.apache.org/ooo/show_bug.cgi?id=37652



+1 but there should be a toggle to revert this behavior for those who 
know what they're doing...


Kind regards, Joost



Re: CHIP Award Top Download 2012

2013-01-08 Thread Kadal Amutham
Dear Mr. Rob

I have some skill in HTML and CSS. I do not know whether they are good. Any
way send me the orignal of http://www.openoffice.org/awards/ and I will try
to organize better

With Warm Regards

V.Kadal Amutham
919444360480


On 8 January 2013 02:42, Rob Weir robw...@apache.org wrote:

 http://www.openoffice.org/awards/


Re: Spam on extensions website

2013-01-08 Thread FR web forum
Spam again: http://extensions.openoffice.org/en/recent_updated

- Mail original -
De: FR web forum ooofo...@free.fr
À: dev@openoffice.apache.org
Envoyé: Lundi 17 Décembre 2012 16:25:14
Objet: Re: Spam on extensions website

Massive spam from several users (fake oxt)


Re: CHIP Award Top Download 2012

2013-01-08 Thread Rob Weir
On Mon, Jan 7, 2013 at 9:48 PM, Kadal Amutham vka...@gmail.com wrote:
 Dear Mr. Rob

 I have some skill in HTML and CSS. I do not know whether they are good. Any
 way send me the orignal of http://www.openoffice.org/awards/ and I will try
 to organize better


Great.  I'll email you a zip file of that page.

-Rob


 With Warm Regards

 V.Kadal Amutham
 919444360480


 On 8 January 2013 02:42, Rob Weir robw...@apache.org wrote:

 http://www.openoffice.org/awards/


Re: Spam on extensions website

2013-01-08 Thread Roberto Galoppini
Fixed, thanks.

We'll keep that in mind while enhancing AOOE/T features, maybe we can come
up with something smart to avoid that.

Roberto

On Tue, Jan 8, 2013 at 3:22 PM, FR web forum ooofo...@free.fr wrote:

 Spam again: http://extensions.openoffice.org/en/recent_updated

 - Mail original -
 De: FR web forum ooofo...@free.fr
 À: dev@openoffice.apache.org
 Envoyé: Lundi 17 Décembre 2012 16:25:14
 Objet: Re: Spam on extensions website

 Massive spam from several users (fake oxt)


-- 

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.



Re: 30 million downloads, year end blog post

2013-01-08 Thread Roberto Galoppini
On Tue, Jan 1, 2013 at 5:26 PM, Rob Weir robw...@apache.org wrote:

 On Tue, Jan 1, 2013 at 9:10 AM, Marcus (OOo) marcus.m...@wtnet.de wrote:
  Am 12/31/2012 08:00 PM, schrieb Rory O'Farrell:
 
  The download count on main D/L page ought be updated to show the 30+
  million.
 
 
  I've done the update.
 

 Thanks.  And I've updated the charts now:
 http://www.openoffice.org/stats/downloads.html

 The final count for 2012 was:  30,687,795 downloads.


Actually we missed to compute download logs from Dec 23, 24 and Jan 2.
We've worked out a plan for reconstituting them all and we did it as of
yesterday. If you could kindly recompute your graphs you'll see a bit more
downloads for 2012.

Sorry for the inconvenience it might have caused to you.

Roberto


 I predict we will more than double this in 2013, due to:

 1) Being able to count downloads for the full year.  (AOO 3.4 was not
 available until May in 2012 and I did not include OOo 3.3.0 download
 in the counts.)

 2) Greater language coverage, starting very soon with the release of
 more 3.4.1 languages, and even more with 4.0.

 3) Exciting new features in AOO 4.0

 Regards,

 -Rob

  Marcus


-- 

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.



Re: 30 million downloads, year end blog post

2013-01-08 Thread janI
Quite a large number, congrats to all those that made it happen !

@rob: did you check up on wiki and google analytics ?
we switch to a new vm in a couple of days, but that should not influence
it...but once we do it would be nice to have it controlled again.

rgds
Jan I.


On 8 January 2013 20:13, Rob Weir robw...@apache.org wrote:

 On Tue, Jan 8, 2013 at 1:41 PM, Roberto Galoppini rgalopp...@geek.net
 wrote:
  On Tue, Jan 1, 2013 at 5:26 PM, Rob Weir robw...@apache.org wrote:
 
  On Tue, Jan 1, 2013 at 9:10 AM, Marcus (OOo) marcus.m...@wtnet.de
 wrote:
   Am 12/31/2012 08:00 PM, schrieb Rory O'Farrell:
  
   The download count on main D/L page ought be updated to show the 30+
   million.
  
  
   I've done the update.
  
 
  Thanks.  And I've updated the charts now:
  http://www.openoffice.org/stats/downloads.html
 
  The final count for 2012 was:  30,687,795 downloads.
 
 
  Actually we missed to compute download logs from Dec 23, 24 and Jan 2.
  We've worked out a plan for reconstituting them all and we did it as of
  yesterday. If you could kindly recompute your graphs you'll see a bit
 more
  downloads for 2012.
 
  Sorry for the inconvenience it might have caused to you.
 

 No problem.  We want to have the most accurate numbers possible, so
 this is good.  I've updated the charts.

 So the new count for the year end figure is:  30,963,581

 -Rob



  Roberto
 
 
  I predict we will more than double this in 2013, due to:
 
  1) Being able to count downloads for the full year.  (AOO 3.4 was not
  available until May in 2012 and I did not include OOo 3.3.0 download
  in the counts.)
 
  2) Greater language coverage, starting very soon with the release of
  more 3.4.1 languages, and even more with 4.0.
 
  3) Exciting new features in AOO 4.0
 
  Regards,
 
  -Rob
 
   Marcus
 
 
  --
  
  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.
 



Re: 30 million downloads, year end blog post

2013-01-08 Thread Rob Weir
On Tue, Jan 8, 2013 at 2:17 PM, janI j...@apache.org wrote:
 Quite a large number, congrats to all those that made it happen !

 @rob: did you check up on wiki and google analytics ?
 we switch to a new vm in a couple of days, but that should not influence
 it...but once we do it would be nice to have it controlled again.


It is showing data since last Thursday, around 20-25K page views per
day, which is where it was before the holidays.

-Rob


 rgds
 Jan I.


 On 8 January 2013 20:13, Rob Weir robw...@apache.org wrote:

 On Tue, Jan 8, 2013 at 1:41 PM, Roberto Galoppini rgalopp...@geek.net
 wrote:
  On Tue, Jan 1, 2013 at 5:26 PM, Rob Weir robw...@apache.org wrote:
 
  On Tue, Jan 1, 2013 at 9:10 AM, Marcus (OOo) marcus.m...@wtnet.de
 wrote:
   Am 12/31/2012 08:00 PM, schrieb Rory O'Farrell:
  
   The download count on main D/L page ought be updated to show the 30+
   million.
  
  
   I've done the update.
  
 
  Thanks.  And I've updated the charts now:
  http://www.openoffice.org/stats/downloads.html
 
  The final count for 2012 was:  30,687,795 downloads.
 
 
  Actually we missed to compute download logs from Dec 23, 24 and Jan 2.
  We've worked out a plan for reconstituting them all and we did it as of
  yesterday. If you could kindly recompute your graphs you'll see a bit
 more
  downloads for 2012.
 
  Sorry for the inconvenience it might have caused to you.
 

 No problem.  We want to have the most accurate numbers possible, so
 this is good.  I've updated the charts.

 So the new count for the year end figure is:  30,963,581

 -Rob



  Roberto
 
 
  I predict we will more than double this in 2013, due to:
 
  1) Being able to count downloads for the full year.  (AOO 3.4 was not
  available until May in 2012 and I did not include OOo 3.3.0 download
  in the counts.)
 
  2) Greater language coverage, starting very soon with the release of
  more 3.4.1 languages, and even more with 4.0.
 
  3) Exciting new features in AOO 4.0
 
  Regards,
 
  -Rob
 
   Marcus
 
 
  --
  
  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.
 



Re: [WEBSITE] broken link on mac porting page

2013-01-08 Thread Andrea Pescetti

On 07/01/2013 Marcus (OOo) wrote:

Am 01/07/2013 09:54 PM, schrieb Rob Weir:

http://www.openoffice.org/porting/mac/
So I'd recommend either keeping the page and updating it. Or
replacing it with a page that says that the Mac port is now full
integrated with our releases and then link to the download page. Or
put in a 401 redirect from that URL to the download page. ...

OK, then I prefer to use a redirect to the download area.


Sounds good. Actually, we can redirect everything under

http://www.openoffice.org/porting/mac/

to the homepage, since links on the old page include support, 
screenshots, downloads... all resources directly available from the 
project homepage.


Regards,
  Andrea.


Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Andrea Pescetti

On 07/01/2013 Andrew Douglas Pitonyak wrote:

I can read these formats in AOO, but I cannot write them. Although I
remember seeing discussion on this, my current understanding is that
there are no current plans to add this capability into AOO, is this
correct? (or did I totally miss something and it is currently available).


I've heard for a long time (since version 3.3, and perhaps earlier) that 
OpenOffice does contain OOXML-writing code, but that it is commented out 
(not simply disabled at build time). Is this correct?


If the code indeed exists and can be compiled, maybe we could start by 
compiling it and doing some tests to see how (in)complete it is...


Regards,
  Andrea.


Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Hagar Delest

Hello all,

I'm back on the dev mailing list because there are some interesting topics 
sometimes. But no further involvement in the AOO project anymore.

Before AOO starts to try such OOXML filter, I think it would be interesting to 
have a global consensus about what is intended about OOXML.
The OOXML compatibility was a rather frequent question in the Google Moderator 
session, same in the forums.

If AOO offers the possibility to save in OOXML, what is the future of ODF then? 
Why users should bother with a still rather unknown format if they can save in 
OOXML for compatibility with MS Office users?

So what is exactly the rationale to implement the export filter?
Do we really want to go this way and then handle the users ranting because of 
the glitches of such a format?

I guess that it is still easy to get a pirated copy of MS Office nowadays. So 
if someone wants MSO for free, this should not really be a big deal (and MS 
would certainly let it be so that its OOXML still expands). And the numbers 
show that AOO has not lost its leverage compared to LibreOffice for example 
(the only other to propose the OOXML export filter). So the sub-question is: do 
really our users need that OOXML export filter?

This is a political question. The previous OOo team took a decision. What is 
the AOO team position on that now? This could have long term consequences.

And by the way, what flavor of the OOXML would be supported? Transient or ISO?

Hagar


Le 08/01/2013 22:17, Andrea Pescetti a écrit :


On 07/01/2013 Andrew Douglas Pitonyak wrote:

I can read these formats in AOO, but I cannot write them. Although I
remember seeing discussion on this, my current understanding is that
there are no current plans to add this capability into AOO, is this
correct? (or did I totally miss something and it is currently available).


I've heard for a long time (since version 3.3, and perhaps earlier) that 
OpenOffice does contain OOXML-writing code, but that it is commented out (not 
simply disabled at build time). Is this correct?

If the code indeed exists and can be compiled, maybe we could start by 
compiling it and doing some tests to see how (in)complete it is...

Regards,
   Andrea.


Re: [PROPOSAL] lazy consensus for new News scrolling

2013-01-08 Thread Kay Schenk



On 01/07/2013 05:07 PM, Dave Fisher wrote:


On Jan 7, 2013, at 12:39 PM, Rob Weir wrote:


On Fri, Jan 4, 2013 at 1:12 PM, Kay Schenk kay.sch...@gmail.com wrote:

On Thu, Jan 3, 2013 at 4:09 PM, Rob Weir robw...@apache.org wrote:



snip


Since this is the visitors first impression of the project, I wonder
if it is worth exploring further to see if there is a way to address
these issues?   As I mentioned before, the ASF home page has a latest
activity panel that avoids both of these problems:

http://www.apache.org/

Can we copy what they do?



Yes. See below where I show where to find the rest of the code that Rob has 
tracked down.

We can handle it like a feed with ASF::Value type patterns in path.pm

Or we can use xslt and parse a file file in view.pm

Or a combination.




ummm...not sure about this. We would need to do more thorough investigation
here. Right now, I can not easily determine how this column is generated --
manually vs something else.



I did a little research on how the ASF home page works.

You cans see the source here:
http://svn.apache.org/repos/asf/infrastructure/site/trunk/

index.html is here:
http://svn.apache.org/repos/asf/infrastructure/site/trunk/content/index.html

and Latest Activity looks like this:

h3Latest Activity/h3
  div class=section-content
pemThis is an overview of activity going on with our
projects. SVN commits, bug reports, tweets, you name it/em./p
  /div

 {% for e in twitter.list %}
 div class=section-content
 a href={{ e.url }}@/a{{ e.title|safe }}
 /div
 {% endfor %}

{% for e in svn.list %}
div class=section-content
a class=svn
href=http://svn.apache.org/viewvc?revision={{ e.revision
}};view=revisionr{{ e.revision }}/a
  {{ e.message|safe|truncatewords_html:20 }} ({{
  e.projects|safe }}) mdash;
  a
href=http://people.apache.org/committer-index.html#{{ e.author }}{{
e.author }}/a
/div
{% endfor %}

 {% for e in jira.list %}
 div class=section-content
 a class=bug href={{ e.url }}{{
e.title|safe }}/abr/
 {{ e.content|safe|truncatewords_html:20 }}
 /div
 {% endfor %}

/div



So they are iterating over twitter.list, svn.list and jira.list.  But
it is not leaping out at me where that data comes from.  Presumably it
is RSS/Atom feeds, but I don't see the glue that connects this.


Take a look at www.apache.org's trunk/lib/path.pm:

our @patterns = (

 [qr!^/index\.html$!, news_page =
   {
 svn  = ASF::Value::SVN-new(limit = 5),
 jira = ASF::Value::Jira-new(limit = 5,
   url = http://s.apache.org/q4;),
 announce = ASF::Value::Mail-new(list = 'annou...@apache.org',
   limit = 3),
 planet   = ASF::Value::Blogs-new(blog = planet, limit= 3),
 blog = ASF::Value::Blogs-new(blog = foundation, limit= 3),
 twitter  = ASF::Value::Twitter-new(name = 'TheASF', limit = 3),
   },
 ],

 [qr!^/dev/index\.html$!, news_page =
   {
 svn  = ASF::Value::SVN-new(limit = 5),
 twitter  = ASF::Value::Twitter-new(name=infrabot, limit = 3),
 blog = ASF::Value::Blogs-new(blog = infra, limit= 3),
 jira = ASF::Value::Jira-new(limit = 5,
   url = http://s.apache.org/lg;),
   },
 ],

 [qr!^/dev/sitemap\.html$!, sitemap = { headers = { title = Developer 
Sitemap }} ],

 [qr!^/licenses/exports/index\.html$!, exports = {} ],

 [qr!\.mdtext$!, single_narrative = { template = single_narrative.html 
}],
);

And also view.pm, doap2perl.xsl and list2urls.xsl

sub news_page {
 my %args = @_;
 my $count=0;
 for (fetch_doap_url_list()) {
 my $result = parse_doap($_);
 next unless defined $result;
 push @{$args{projects}}, $result;
 last if ++$count == 3;
 }

 return ASF::View::news_page(%args);
}

sub parse_doap {
 my $url = shift;
 my $doap = get $url or die Can't get $url: $!\n;
 my ($fh, $filename) = tempfile(XX);
 print $fh $doap;
 close $fh;
 my $result = eval `xsltproc lib/doap2perl.xsl $filename`;
 unlink $filename;
 return undef if $result-{pmc} =~ m!^http://attic\.apache\.org!;
 return $result;
}

sub fetch_doap_url_list {
 my $xml = get 
http://svn.apache.org/repos/asf/infrastructure/site-tools/trunk/projects/files.xml;
 or die Can't get doap file list: $!\n;
 my ($fh, $filename) = tempfile(XX);
 print $fh $xml;
 close $fh;
 chomp(my 

Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-08 Thread kieth lovell
unfortunately formatting as text prevents me from using functions to do any 
calculations.
It is not a real solution to the problem and does not help at all with the 
automatic alteration of entered text



 From: Andrew Douglas Pitonyak and...@pitonyak.org
To: dev@openoffice.apache.org 
Cc: kieth lovell m3...@yahoo.co.uk 
Sent: Sunday, 6 January 2013, 23:36
Subject: Re: (old) New feature/option to prevent autodata alterations in calc
 


Remember, that anything that begins as a number, Calc tries to interpret 
as a number rather than text. For most users, this is exactly what you 
want most of the time. For a few unlucky people (like you), their 
average use case is different than others, and you do not want that. It 
is odd that you can turn this stuff off in a text table, but I am unsure 
how to do so in a Calc document unless

Read this, it will give you some ideas.

http://forum.openoffice.org/en/forum/viewtopic.php?f=9t=57276

Sounds like setting the default style to be text will solve your 
problems; maybe.

On 01/06/2013 11:56 PM, kieth lovell wrote:
 My name is kiet lovell,
 I am an serial small scale entrepeneur, and I like to do my business plans 
 (as well as everything else) in spreadsheets.

 For years I have suffered as
     1. numbers are turned to dates

     2. phone numbers are altered

     3. lower case data is changed to identical higher case data (eg: data to 
 DATA(when DATA is a separate piece of data that i typed than the lower case))

     4. If I type Scone then i can not write s, sc, sco, or scon in the same 
 field without my data being altered to the full word scone.


 There is no solution to this in the options for calc.
 Please do not reference selecting every cell as text or another type of data 
 as it only stops certain types of alterations.

 What needs to be done is that there needs to be an option to turn off all 
 autodata transformations.

 It should be in toolsoptionsopenoffice.org calcgeneralinput settings

 Thank you in advance
 Kiet Lovell

 The important part of the message is the piece above, the following are just 
 my views/or justifications.

 I am sending this to the development mailing group as this issue has been 
 complained about by at least hundreds of users for several years without 
 solution.


 If you do not think it is a big problem then please google any of the 
 following phrases:

 Office keeps changing numbers to dates
 Turn off autodata in calc
 Prevent openoffice changing my data
 etc.

 I have spent weeks of my life trying to fix this problem to no avail.
 The only way i can use calc is to change the data such as putting letters 
 with phone numbers and when unable to input the correct data, by inputting 
 slightly wrong data so that it isn't changed to a different value.

 Almost all users of calc use it for home finance or education or business 
 purposes, and all of these can be badly affected by unsanctioned changes to 
 data.

 Microsoft office in it's latest reincarnation is unusable for a professional 
 and libre office has the same problem as openoffice.

 If you the developers of open office cannot fix this then i will either:
     * continue to suffer in relative silence
 or less likely
     * spend 6 months learning to program and produce my own software that i 
 will charge for.
 or probably

     * downgrade to an efficient OS like windows 3.1 when computers were made 
 for saving time and money, not costing you it

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

Re: (old) New feature/option to prevent autodata alterations in calc

2013-01-08 Thread kieth lovell
Thank you Joost, as this does partially solve the problem (text being altered)

however the instant removal of the zeroes on phone numbers is still a problem.
adding a single quote to every phone number, especially when pasting in large 
amounts of data really is inappropriate and very time consuming
and surely you cant expect every user who wants to enter phone numbers to have 
to set up macros to try to do this

Is there a better way to deal with this already?
Or could a small piece of code be written to enable users to turn the option 
off?
thanks in advance
Kieth Lovell



 From: Joost Andrae joost.and...@gmx.de
To: dev@openoffice.apache.org 
Sent: Monday, 7 January 2013, 2:04
Subject: Re: (old) New feature/option to prevent autodata alterations in calc
 
Hi Kieth,

 For years I have suffered as
     1. numbers are turned to dates

is it really a number you want to input or do you use a number format ?

 
     2. phone numbers are altered

In this case you can start your cell entry using a single quote character. A 
trailing single quote character will handle the cell content as a string not as 
a number.

 
     3. lower case data is changed to identical higher case data (eg: data to 
 DATA(when DATA is a separate piece of
data that i typed than the lower case))

I have to confess this can be odd but it really is a feature of Calc to 
autocorrect the way you once wrote a string within another input cell within a 
column. You can turn this behavior off within the tools menu.

/tools/cell content/auto input (or something like that - I use a German 
localization)

 
     4. If I type Scone then i can not write s, sc, sco, or scon in the same 
 field without my data being altered to the full word scone.
 

same as above

Kind regards, Joost

Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Rob Weir
On Tue, Jan 8, 2013 at 4:59 PM, Hagar Delest hagar.del...@laposte.net wrote:
 Hello all,

 I'm back on the dev mailing list because there are some interesting topics
 sometimes. But no further involvement in the AOO project anymore.

 Before AOO starts to try such OOXML filter, I think it would be interesting
 to have a global consensus about what is intended about OOXML.
 The OOXML compatibility was a rather frequent question in the Google
 Moderator session, same in the forums.

 If AOO offers the possibility to save in OOXML, what is the future of ODF
 then? Why users should bother with a still rather unknown format if they can
 save in OOXML for compatibility with MS Office users?

 So what is exactly the rationale to implement the export filter?

There was a time, back 5 years ago, when it was not certain whether
OOXML would survive or not.  I, and many others, spent a lot of energy
trying to prevent that from happening.  We knew that if OOXML was
standardized and accepted that it would perpetuate Microsoft's lock-in
advantage and make extra work for competitors like OpenOffice.  We
knew that if OOXML survived we'd waste resources implementing it,
rather than other, more useful features that users want.   We were
right to have this concern, but we lost that battle, and these things
have now come to pass.  IMHO it is time to make the best of the
situation we find ourselves in.

OOXML is the default format in MS Office 2007, 2010 and 2013.  Office
2003, which defaulted to the binary formats, hits end of support next
year.  So, whether we like it or not, our users will be receiving
OOXML documents from people, and when they collaborate they will want
to be able to return modified OOXML documents.

OOXML is the new DOC format.  We wouldn't think of not supporting DOC,
would we?  But even as we support DOC we know that ODF, as the native
format for OpenOffice, will give the best fidelity and preservation.
Everything else other than ODF is a foreign language to OpenOffice
that we speak imperfectly.

 Do we really want to go this way and then handle the users ranting because
 of the glitches of such a format?


This is an excellent point.  We don't want users to be frustrated by a
partial implementation.  So maybe it could be exposed as an
experimental feature?


 I guess that it is still easy to get a pirated copy of MS Office nowadays.
 So if someone wants MSO for free, this should not really be a big deal (and
 MS would certainly let it be so that its OOXML still expands). And the
 numbers show that AOO has not lost its leverage compared to LibreOffice for
 example (the only other to propose the OOXML export filter). So the
 sub-question is: do really our users need that OOXML export filter?


As we saw in the Google Moderator counts, this feature was near the top.

 This is a political question. The previous OOo team took a decision. What is
 the AOO team position on that now? This could have long term consequences.


I hope we can avoid the politics.  For example, with the license we
have taken a pragmatic view rather than follow the copyleft purists.
Where other projects have stripped all non-GPL extensions from their
extensions repository, we're happy for our users to have a choice and
decide for themselves.

So maybe a good compromise would:

1) Aim to provide the industry's best support for ODF

2) Continue to explain the value and advantage of ODF to our users

3) Support whatever formats that our users need to be productive with
OpenOffice in real-world work.

 And by the way, what flavor of the OOXML would be supported? Transient or
 ISO?


Presumably we would implement Microsoft OpenXML, what they actually can read.

Regards,

-Rob

 Hagar


 Le 08/01/2013 22:17, Andrea Pescetti a écrit :


 On 07/01/2013 Andrew Douglas Pitonyak wrote:

 I can read these formats in AOO, but I cannot write them. Although I
 remember seeing discussion on this, my current understanding is that
 there are no current plans to add this capability into AOO, is this
 correct? (or did I totally miss something and it is currently available).


 I've heard for a long time (since version 3.3, and perhaps earlier) that
 OpenOffice does contain OOXML-writing code, but that it is commented out
 (not simply disabled at build time). Is this correct?

 If the code indeed exists and can be compiled, maybe we could start by
 compiling it and doing some tests to see how (in)complete it is...

 Regards,
Andrea.


Re: [PROPOSAL] lazy consensus for new News scrolling

2013-01-08 Thread Kay Schenk



On 01/08/2013 02:55 PM, Rob Weir wrote:

On Tue, Jan 8, 2013 at 4:59 PM, Kay Schenk kay.sch...@gmail.com wrote:



On 01/07/2013 05:07 PM, Dave Fisher wrote:



On Jan 7, 2013, at 12:39 PM, Rob Weir wrote:


On Fri, Jan 4, 2013 at 1:12 PM, Kay Schenk kay.sch...@gmail.com wrote:


On Thu, Jan 3, 2013 at 4:09 PM, Rob Weir robw...@apache.org wrote:



snip


Since this is the visitors first impression of the project, I wonder
if it is worth exploring further to see if there is a way to address
these issues?   As I mentioned before, the ASF home page has a latest
activity panel that avoids both of these problems:

http://www.apache.org/

Can we copy what they do?



Yes. See below where I show where to find the rest of the code that Rob
has tracked down.

We can handle it like a feed with ASF::Value type patterns in path.pm

Or we can use xslt and parse a file file in view.pm

Or a combination.




ummm...not sure about this. We would need to do more thorough
investigation
here. Right now, I can not easily determine how this column is generated
--
manually vs something else.



I did a little research on how the ASF home page works.

You cans see the source here:
http://svn.apache.org/repos/asf/infrastructure/site/trunk/

index.html is here:

http://svn.apache.org/repos/asf/infrastructure/site/trunk/content/index.html

and Latest Activity looks like this:

h3Latest Activity/h3
   div class=section-content
 pemThis is an overview of activity going on with our
projects. SVN commits, bug reports, tweets, you name it/em./p
   /div

  {% for e in twitter.list %}
  div class=section-content
  a href={{ e.url }}@/a{{ e.title|safe }}
  /div
  {% endfor %}

 {% for e in svn.list %}
 div class=section-content
 a class=svn
href=http://svn.apache.org/viewvc?revision={{ e.revision
}};view=revisionr{{ e.revision }}/a
   {{ e.message|safe|truncatewords_html:20 }} ({{
   e.projects|safe }}) mdash;
   a
href=http://people.apache.org/committer-index.html#{{ e.author }}{{
e.author }}/a
 /div
 {% endfor %}

  {% for e in jira.list %}
  div class=section-content
  a class=bug href={{ e.url }}{{
e.title|safe }}/abr/
  {{ e.content|safe|truncatewords_html:20 }}
  /div
  {% endfor %}

 /div



So they are iterating over twitter.list, svn.list and jira.list.  But
it is not leaping out at me where that data comes from.  Presumably it
is RSS/Atom feeds, but I don't see the glue that connects this.



Take a look at www.apache.org's trunk/lib/path.pm:

our @patterns = (

  [qr!^/index\.html$!, news_page =
{
  svn  = ASF::Value::SVN-new(limit = 5),
  jira = ASF::Value::Jira-new(limit = 5,
url =
http://s.apache.org/q4;),
  announce = ASF::Value::Mail-new(list = 'annou...@apache.org',
limit = 3),
  planet   = ASF::Value::Blogs-new(blog = planet, limit= 3),
  blog = ASF::Value::Blogs-new(blog = foundation, limit=
3),
  twitter  = ASF::Value::Twitter-new(name = 'TheASF', limit =
3),
},
  ],

  [qr!^/dev/index\.html$!, news_page =
{
  svn  = ASF::Value::SVN-new(limit = 5),
  twitter  = ASF::Value::Twitter-new(name=infrabot, limit =
3),
  blog = ASF::Value::Blogs-new(blog = infra, limit= 3),
  jira = ASF::Value::Jira-new(limit = 5,
url =
http://s.apache.org/lg;),
},
  ],

  [qr!^/dev/sitemap\.html$!, sitemap = { headers = { title =
Developer Sitemap }} ],

  [qr!^/licenses/exports/index\.html$!, exports = {} ],

  [qr!\.mdtext$!, single_narrative = { template =
single_narrative.html }],
);

And also view.pm, doap2perl.xsl and list2urls.xsl

sub news_page {
  my %args = @_;
  my $count=0;
  for (fetch_doap_url_list()) {
  my $result = parse_doap($_);
  next unless defined $result;
  push @{$args{projects}}, $result;
  last if ++$count == 3;
  }

  return ASF::View::news_page(%args);
}

sub parse_doap {
  my $url = shift;
  my $doap = get $url or die Can't get $url: $!\n;
  my ($fh, $filename) = tempfile(XX);
  print $fh $doap;
  close $fh;
  my $result = eval `xsltproc lib/doap2perl.xsl $filename`;
  unlink $filename;
  return undef if $result-{pmc} =~ m!^http://attic\.apache\.org!;
  return $result;
}

sub fetch_doap_url_list {
  my $xml = get

Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Regina Henschel

Hi all,

Andrew Douglas Pitonyak schrieb:


I can read these formats in AOO, but I cannot write them. Although I
remember seeing discussion on this, my current understanding is that
there are no current plans to add this capability into AOO, is this
correct? (or did I totally miss something and it is currently available).




I don't know if code already exists. But LibreOffice has an OOXML 
export. And there exist the project Layout-getreue Darstellung von 
OOXML-Dokumenten in Open Source Office Applikationen of the Open Source 
Business Alliance.

http://www.osb-alliance.de/working-groups/office-interoperability/

[For an English information use 
http://www.osb-alliance.de/fileadmin/specificationooxmlimprovements_en_v06.pdf]


If it has been done as planed, the code is under AL2 license and Apache 
OpenOffice may use it.


Kind regards
Regina


Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Dave Fisher

On Jan 8, 2013, at 4:07 PM, Rob Weir wrote:

 On Tue, Jan 8, 2013 at 4:59 PM, Hagar Delest hagar.del...@laposte.net wrote:
 Hello all,
 
 I'm back on the dev mailing list because there are some interesting topics
 sometimes. But no further involvement in the AOO project anymore.
 
 Before AOO starts to try such OOXML filter, I think it would be interesting
 to have a global consensus about what is intended about OOXML.
 The OOXML compatibility was a rather frequent question in the Google
 Moderator session, same in the forums.
 
 If AOO offers the possibility to save in OOXML, what is the future of ODF
 then? Why users should bother with a still rather unknown format if they can
 save in OOXML for compatibility with MS Office users?
 
 So what is exactly the rationale to implement the export filter?
 
 There was a time, back 5 years ago, when it was not certain whether
 OOXML would survive or not.  I, and many others, spent a lot of energy
 trying to prevent that from happening.  We knew that if OOXML was
 standardized and accepted that it would perpetuate Microsoft's lock-in
 advantage and make extra work for competitors like OpenOffice.  We
 knew that if OOXML survived we'd waste resources implementing it,
 rather than other, more useful features that users want.   We were
 right to have this concern, but we lost that battle, and these things
 have now come to pass.  IMHO it is time to make the best of the
 situation we find ourselves in.

There is the Java based Apache POI which includes OOXML4J. I am on the POI PMC. 
Two of the Mentors for ODFToolkit are also on the POI PMC.

I have always thought that one needs to be in the MIDDLE of this position.

If the following is possible - xlsx - ods - xlsx - ods  OR pdf - pptx - 
odf - pdf then the software that enables such interop will be what people in 
institutions will use. No institution with 2,000 desktops is going to seriously 
think of Apache OpenOffice as a viable solution to test unless it can do a 
reasonably accurate job converting.

 OOXML is the default format in MS Office 2007, 2010 and 2013.  Office
 2003, which defaulted to the binary formats, hits end of support next
 year.  So, whether we like it or not, our users will be receiving
 OOXML documents from people, and when they collaborate they will want
 to be able to return modified OOXML documents.
 
 OOXML is the new DOC format.  We wouldn't think of not supporting DOC,
 would we?  But even as we support DOC we know that ODF, as the native
 format for OpenOffice, will give the best fidelity and preservation.
 Everything else other than ODF is a foreign language to OpenOffice
 that we speak imperfectly.

Differences in conversions due to the file format should be well documented. 
After all a choice is being made.

 
 Do we really want to go this way and then handle the users ranting because
 of the glitches of such a format?
 
 
 This is an excellent point.  We don't want users to be frustrated by a
 partial implementation.  So maybe it could be exposed as an
 experimental feature?

With enough samples and the knowledge of standards people like Rob we can 
certainly highlight the INHERENT superiority.

 
 
 I guess that it is still easy to get a pirated copy of MS Office nowadays.
 So if someone wants MSO for free, this should not really be a big deal (and
 MS would certainly let it be so that its OOXML still expands). And the
 numbers show that AOO has not lost its leverage compared to LibreOffice for
 example (the only other to propose the OOXML export filter). So the
 sub-question is: do really our users need that OOXML export filter?
 
 
 As we saw in the Google Moderator counts, this feature was near the top.
 
 This is a political question. The previous OOo team took a decision. What is
 the AOO team position on that now? This could have long term consequences.
 
 
 I hope we can avoid the politics.  For example, with the license we
 have taken a pragmatic view rather than follow the copyleft purists.
 Where other projects have stripped all non-GPL extensions from their
 extensions repository, we're happy for our users to have a choice and
 decide for themselves.
 
 So maybe a good compromise would:
 
 1) Aim to provide the industry's best support for ODF
 
 2) Continue to explain the value and advantage of ODF to our users
 
 3) Support whatever formats that our users need to be productive with
 OpenOffice in real-world work.

Exactly. People need Interop. Without interop it will be either Microsoft 
Office or OpenOffice, but NOT both.

 
 And by the way, what flavor of the OOXML would be supported? Transient or
 ISO?
 
 
 Presumably we would implement Microsoft OpenXML, what they actually can 
 read.

Microsoft has fixed problems when they have deviated from the ISO spec. I know 
of one significant instance on the initial release of Mac PowerPoint 2008. They 
had a patch in one month. It helped that Lawrence Livermore Labs was the one 
reporting the trouble.

Microsoft claims to 

Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Regina Henschel
Addition: Wasn't there a talk about it on ApacheCon Europe 2012 by 
Matthias Stürmer?


Re: Is there consensus on latest MS Office formats?

2013-01-08 Thread Andrew Douglas Pitonyak


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


I can read these formats in AOO, but I cannot write them. Although I 
remember seeing discussion on this, my current understanding is that 
there are no current plans to add this capability into AOO, is this 
correct? (or did I totally miss something and it is currently available).




OK, that answers my primary question

I agree with Dennis Hamilton that if we read but cannot write the 
formats, market share will be lost. For casual interactions with people, 
there is certainly no problems with sending the older document formats 
or even PDF, but I frequently have no option but to produce an OOXML 
document for delivery.


Does Symphony support OOXML? I know that it could read the format, but 
unsure if it can write it. LibreOffice certainly writes the formats 
sufficiently well for the majority of my documents.


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



Re: project Volunteer

2013-01-08 Thread chengjh
Hi Tseng,

Welcome to join the community for the product development.How about the
progress of your build?Any issue during your build,please post to the
community for help.Have a good day.

On Mon, Jan 7, 2013 at 9:44 PM, Regina Henschel rb.hensc...@t-online.dewrote:

 Hi Tseng,

 tseng chan schrieb:

  Hello Regina Henschel,

 I'm using Ubuntu (12.04). OpenOffice is already installed on Ubuntu, am I
 still to get my own build?


 If you will do core development, then you need your own build.

 You checkout (or download) the source and build it. Then you write your
 changes to your local source and build it again. Then you test, whether the
 bug is fixed or the feature works as intended. If all is OK, you create a
 patch and append the patch to the issue and make an review request.

 If an experienced developer finds your patch is good, he will push it to
 the trunk. This commit will get your name as author, so it is recorded,
 that you have written the patch.

 Kind regards
 Regina




-- 

Best Regards,Jianhong Cheng


Re: completed lvel1

2013-01-08 Thread Yue Helen
Great! Please continue and let's know here if you need any help.

Helen

2013/1/8 syamala parvatam syamala@gmail.com

 hi,

 i have completed level1

 thanks,
 syamala



[UX] Five new presentation template design

2013-01-08 Thread Xin Li
Hi all,

We have some new presentation template design and have uploaded five new
templates. Welcome to have a try and give me some feedback.  Thanks.

http://templates.services.openoffice.org/en/node/9165
http://templates.services.openoffice.org/en/node/9169
http://templates.services.openoffice.org/en/node/9171
http://templates.services.openoffice.org/en/node/9173
http://templates.services.openoffice.org/en/node/9175

-- 
Best regards,
Xin Li   李欣
UX designer


Re: build problem

2013-01-08 Thread Herbert Duerr

On 09.01.2013 08:06, 2 wrote:

 when got my own build, I couldn't found the filefolder wntmsci12.pro in sw 
module which be found in sc module, could it be said that my build failed ?


That is no problem: The sw module has been converted to gbuild, so that 
the files are now in main/solver/350/wntmsci12.pro instead of the 
modules wntmsci12.pro folder.


Herbert