[QA Report]Weekly report as of 2012/08/13

2012-08-13 Thread Yan Ji
Hi all,

  I update QA weekly report in [1]. Please review

[1] http://wiki.services.openoffice.org/wiki/QA/Report/WeeklyReport/20120813

Thanks  Best Regards, Yan Ji



3.4.1_release_blocker granted: [Bug 120501] Starting OpenOffice with -nodefault parameter should not open the StartCenter

2012-08-13 Thread bugzilla
j...@apache.org has granted Ariel Constenla-Haile arie...@apache.org's request
for 3.4.1_release_blocker:
Bug 120501: Starting OpenOffice with -nodefault parameter should not open the
StartCenter
https://issues.apache.org/ooo/show_bug.cgi?id=120501


--- Additional Comments from j...@apache.org
set release blocker flag for 3.4.1


Re: Extensions and Templates New Features

2012-08-13 Thread FR web forum
  1) Download statistics are now automatically obtained via the
  SourceForge API and are more reliable than the old system, in which
  the counters had been turned off and remained stuck for a long time
Great! 

Is it possible to translate Timeline?
In french, you could set Historique.
Thanks


Re: spell checker

2012-08-13 Thread Andrea Pescetti

On 12/08/2012 Phil Hocott wrote:

Since I downloaded the apache version of open office my spelling and
gramer doesn't work properly so I found an old copy of open office
3.1.0 and downloaded it and everything is fine.


This is a quite radical solution: version 3.1.0 is really old and misses 
many features and security fixes. It's better to reinstall 3.4.0 and, if 
you have problems with dictionaries, reset your user profile:

http://s.apache.org/resetprofile
Regards,
  Andrea.


[RELEASE][3.4.1]: propose new snapshot based on revision 1372282

2012-08-13 Thread Jürgen Schmidt
Hi,

after a short break I have checked the current situation and where we are.

We had identified some further issues for 3.4.1 while we continued
testing the latest snapshots. These issues are now fixed and I would
like to propose a new snapshot build based on revision 1372282.

Issues that will be fixed in this new snapshot:

- OO crashes when I Print
  https://issues.apache.org/ooo/show_bug.cgi?id=120389

- Remove the Browser Plug-in tab page from the Options dialog
  https://issues.apache.org/ooo/show_bug.cgi?id=120518

- Starting OpenOffice with -nodefault parameter should not open the
StartCenter
  https://issues.apache.org/ooo/show_bug.cgi?id=120501

The last 2 issues matched not directly our criteria for blocker issues
but after reviewing the issues and the fix I decided to integrate them
in 3.4.1 as well.
The reason for integrating the last issue is quite simple and I believe
that we probably share this view. We want that AOO is used in
combination with other software systems and as backend service for
document conversion etc. From my point of view it make sense to
integrate this fix in 3.4.1.

Juergen



Re: OO Sold on eBay

2012-08-13 Thread Fernando Cassia
On Sun, Aug 12, 2012 at 9:29 PM, Rob Weir robw...@apache.org wrote:
 But I am concerned that several of the auctions seem to be selling old
 versions of OpenOffice including 3.2 and 3.1.  These earlier versions
 lack important security fixes and those who distribute old versions,
 without a warning, are putting their customers at risk.

If you ask me (which you haven´t ;) this is a tempest in a teapot.
Move along, nothing to see here. Which is exactly new about people
selling ancient software on eBay??. In fact some might want to buy
ancient software due to being a collector´s item etc.

IE I bought an original version  of Paint Shop Pro 5.0, released at
the time of the Windows 98 release or thereabout. It turns out to be
the best bitmap editor I´ve seen (for my needs), works well under WINE
on Linux, and beinfg designed to run on Pentium I computers with
64-128MB of RAM, just flies in today´s hardware.

Previously to that, I used Micrografx Picture Publisher 4.0 which I
used for about a decade (16-bit windows 3.x app under 32-bit IBM
OS/2).

I don´t see Microsoft going after people selling Microsoft OS/2 1.2 on
eBay or Windows 3.11 boxes or Windows 2000. Why should Apache waste
time on this non-issue?.

The only conceivable way Apache should be concerned is if someone
labels it the latest version of Open Office and sells outdated
versions instead. Is that the case here?.

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


Re: [Call-For-Review] Bug 119592 [From Symphony] The left-style columns display with the same width when opening with AOO

2012-08-13 Thread Oliver-Rainer Wittmann

Hi Jinlong Wu,

On 21.06.2012 11:18, Jinlong Wu wrote:

Hello,

I have a fix for bug 119592 (
https://issues.apache.org/ooo/show_bug.cgi?id=119592).

Can anyone help to review it?



Please have a look at Andre's comment.


Thanks in advance, Oliver.


Re: Yes. You can do this with OpenOffice. (MysteryGuitarMan video with OpenOffice Mac)

2012-08-13 Thread Ariel Constenla-Haile
Hi *,

On Mon, Aug 13, 2012 at 03:31:46AM +0800, imacat wrote:
 On 2012/08/12 21:08, Ariel Constenla-Haile said:
  Hi,
  
  On Sun, Aug 12, 2012 at 9:55 AM, imacat ima...@mail.imacat.idv.tw wrote:
  I had posted a video reply:
 
  http://www.youtube.com/watch?v=pqJXYPG-5Bc
  
  you could use recordmydesktop / gtk-recordmydesktop /
  qt-recordmydesktop to capture your desktop.
 
 Thank you.  I tried to use gtk-recordMyDesktop to record a new video:
 
 http://youtu.be/8Nyp7xUBXto

Nice :)

 Strange that the sound is not recorded. ^^;


This may be a big with your distro's version. AFAIK you can add it some
music, once uploaded in Youtube, with Youtube's own editing tools. Or
you can add audio before uploading it, with some of the tools available
on Linux: from the simplest PiTiVi http://www.pitivi.org to the complex
Cinelerra http://cinelerra.org/ there are many other options.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina


pgpclkSLQqwBx.pgp
Description: PGP signature


[Call-for-Review] Issue 120158 [From Symphony]Time format is different than MS Office

2012-08-13 Thread ZuoJun Chen
Hi all,

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

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


Thanks in advance.

Regards - Zuojun


Re: OO Sold on eBay

2012-08-13 Thread Graham Lauder
 On 13 August 2012 01:29, Rob Weir robw...@apache.org wrote:
  On Sun, Aug 12, 2012 at 5:50 PM, Kay Schenk kay.sch...@gmail.com wrote:
  On Sun, Aug 12, 2012 at 10:49 AM, Rob Weir robw...@apache.org wrote:
  On Sun, Aug 12, 2012 at 12:38 PM, Max Merbald max.merb...@gmx.de 
wrote:
   Hi,
   
   I'd say it's not very fair because probably not everyone knows OOO is
   available for free. It's kind of weird that someone is trying to make
  
  money
  
   with something which is available for free.
  
  I wonder... is there anything that prevents one of us from offering
  the same thing on eBay, but at a near-zero price?  For example, would
  it be within eBay policy to have an auction for instructions for
  downloading OpenOffice?  Give all the same marketing plugs for
  features, etc., but set it as a Buy Now price of 1-cent or
  something.
  
  Some users want a CD, because of bandwidth limitations.  But the cost
  of information, in this case, should be nearly zero.
  
  -Rob
  
  You might want to check out seller requirements first...
  
   http://pages.ebay.com/help/sell/questions/sell-requirements.html
  
  I would think if we're willing to do this -- and set this up somehow,
  the answer is no unless ASF precludes this, which it might.
  
  Drew mentioned another eBay policy that said you could not sell access
  to downloaded software.  You could only sell the media.
  
  Looking at the ebay auctions, some of them seem reasonable.  $3 or $5
  for a CD and packaging, shipping, etc., is not outrageous.
  
  But I am concerned that several of the auctions seem to be selling old
  versions of OpenOffice including 3.2 and 3.1.  These earlier versions
  lack important security fixes and those who distribute old versions,
  without a warning, are putting their customers at risk.
  
  As a project we take great pains to ensure the users who download from
  our website get authentic versions of our software, the latest
  versions, not tampered with.  We give the downloader ways of verifying
  this, with MD5 hashes and PGP signatures.
  
  But there is no current way that we can offer similar assurances to
  users who purchase a CD.  (Anyone who thinks users will verify
  checksums or signatures on a CD is deluded.)
  
  Our options:
  
  1) Do nothing.  Bandwidth and access is increasing and this problem
  will solve itself...sometime.

This would the best course, although I don't that there is a problem.  Quite 
the opposite, it is in fact a good thing.  People are thinking like 
proprietary software vendors, please get out of this trap.

Ebay sellers are cheap promotion, they get the brand out there.  
People who return to those sellers do it to save bandwidth. The people who buy 
off them the first time but who do have bandwidth, may not do it a second time 
because they figure out pretty quickly that the name is a web address, or at 
least they used to.  Also many people like dealing with a person rather than a 
server.  

The vast majority of the EBay sellers do the brand a service.  Getting someone 
to do it on behalf of the project is just a waste of energy that could be put 
to better use.  We would be better to promote the EBay sellers, treat them as 
partners rather than competitors.EBay tends to be self policing, the 
unscrupulous ones get bad feedback and disappear fairly quickly.

If they are selling older versions, my answer to that is So what?  My wife 
still uses 3.0 and it suits her needs perfectly.  When the user decides that 
perhaps downloading is the better way to go then they will automatically get 
the latest version.  Having the latest and greatest is not the be all and end 
all.


  
  2) Define voluntary requirements for distributors of OpenOffice.
  Those who agree to these requirements would be allowed use of a
  special logo and would be listed on our website.

More bureaucracy that is unneeded

  
  3) One or more community members, acting outside of Apache, could
  organize to sell CD's on eBay at cost, and have eBay auction listings
  that are upfront and honest, explaining that the software is open
  source and can be downloaded for free.  We can give the URL right in
  the listing.  We would make it clear that the charge is only for
  convenience of having a CD delivered.

Putting a URL in the body of the listing that allows people to circumvent the 
auction process is against EBay TOU.

 
 Is it worth approaching eBay with our concerns?

No, because there are none

 - ensuring that sellers credit (and link to) the ASF

They are selling OOo, that's enough credit, these people are our retailers.  
We, the project, do not supply the software on media, just like Heinz gets 
supermarkets to sell their beans rather than only supply from a Heinz shop.

 - ensuring that sellers provide clear information on the version supplied

EBay won't do anything like that, their policing is along strict guidelines. 
Their actions are strictly binary:  Allow or Ban.  The value to EBay of 

Re: OO Sold on eBay

2012-08-13 Thread Rob Weir
On Mon, Aug 13, 2012 at 8:19 AM, Graham Lauder g.a.lau...@gmail.com wrote:
 On 13 August 2012 01:29, Rob Weir robw...@apache.org wrote:
  On Sun, Aug 12, 2012 at 5:50 PM, Kay Schenk kay.sch...@gmail.com wrote:
  On Sun, Aug 12, 2012 at 10:49 AM, Rob Weir robw...@apache.org wrote:
  On Sun, Aug 12, 2012 at 12:38 PM, Max Merbald max.merb...@gmx.de
 wrote:
   Hi,
  
   I'd say it's not very fair because probably not everyone knows OOO is
   available for free. It's kind of weird that someone is trying to make
 
  money
 
   with something which is available for free.
 
  I wonder... is there anything that prevents one of us from offering
  the same thing on eBay, but at a near-zero price?  For example, would
  it be within eBay policy to have an auction for instructions for
  downloading OpenOffice?  Give all the same marketing plugs for
  features, etc., but set it as a Buy Now price of 1-cent or
  something.
 
  Some users want a CD, because of bandwidth limitations.  But the cost
  of information, in this case, should be nearly zero.
 
  -Rob
 
  You might want to check out seller requirements first...
 
   http://pages.ebay.com/help/sell/questions/sell-requirements.html
 
  I would think if we're willing to do this -- and set this up somehow,
  the answer is no unless ASF precludes this, which it might.
 
  Drew mentioned another eBay policy that said you could not sell access
  to downloaded software.  You could only sell the media.
 
  Looking at the ebay auctions, some of them seem reasonable.  $3 or $5
  for a CD and packaging, shipping, etc., is not outrageous.
 
  But I am concerned that several of the auctions seem to be selling old
  versions of OpenOffice including 3.2 and 3.1.  These earlier versions
  lack important security fixes and those who distribute old versions,
  without a warning, are putting their customers at risk.
 
  As a project we take great pains to ensure the users who download from
  our website get authentic versions of our software, the latest
  versions, not tampered with.  We give the downloader ways of verifying
  this, with MD5 hashes and PGP signatures.
 
  But there is no current way that we can offer similar assurances to
  users who purchase a CD.  (Anyone who thinks users will verify
  checksums or signatures on a CD is deluded.)
 
  Our options:
 
  1) Do nothing.  Bandwidth and access is increasing and this problem
  will solve itself...sometime.

 This would the best course, although I don't that there is a problem.  Quite
 the opposite, it is in fact a good thing.  People are thinking like
 proprietary software vendors, please get out of this trap.

 Ebay sellers are cheap promotion, they get the brand out there.

Maybe the auction listing are different in your country, but here they
are not promoting the Apache OpenOffice brand. We're seeing listings
selling things like:

Open Office Suite 2010

Open Office Home and Student 2010

Open Office Professional' 2010

Open Office Business and Professional

This seems to be taking Microsoft Office brand elements and putting
Open in front of them.  I don't see this as promoting our brand.

 People who return to those sellers do it to save bandwidth. The people who buy
 off them the first time but who do have bandwidth, may not do it a second time
 because they figure out pretty quickly that the name is a web address, or at
 least they used to.  Also many people like dealing with a person rather than a
 server.


I have no objections to someone who sells a CD with the latest version of AOO.

 The vast majority of the EBay sellers do the brand a service.  Getting someone
 to do it on behalf of the project is just a waste of energy that could be put
 to better use.  We would be better to promote the EBay sellers, treat them as
 partners rather than competitors.EBay tends to be self policing, the
 unscrupulous ones get bad feedback and disappear fairly quickly.


If it is worth someone else's time and effort to do this, why wouldn't
it be worth my time and effort?

 If they are selling older versions, my answer to that is So what?  My wife
 still uses 3.0 and it suits her needs perfectly.  When the user decides that
 perhaps downloading is the better way to go then they will automatically get
 the latest version.  Having the latest and greatest is not the be all and end
 all.


The issue is when they say it is the latest version but they are
really selling OOo 3.2.  Maybe you are not aware of the security
flaws, now publicly disclosed, in older versions of OpenOffice?


 
  2) Define voluntary requirements for distributors of OpenOffice.
  Those who agree to these requirements would be allowed use of a
  special logo and would be listed on our website.

 More bureaucracy that is unneeded


I think the feedback we have received from users suggests otherwise.
They are looking for a trusted source of CDs.

 
  3) One or more community members, acting outside of Apache, could
  organize to sell CD's on eBay at cost, and 

Re: [DISCUSS] OpenOffice Track: ApacheCon Europe

2012-08-13 Thread Rob Weir
On Sun, Aug 12, 2012 at 9:14 PM, Donald Harbison dpharbi...@gmail.com wrote:
 By now everyone must be aware that the CFP system will be closing tomorrow,
 August 13th. We'll have an idea of what was submitted this week. In the
 meantime, let's have a discussion about how we want to shape our track
 beyond those proposals.

 Here's an outline to get the discussion moving...

 REMEMBER, this is our conference track to shape was we wish. We have a fair
 amount of flexibility within the overall framework of ApacheCon. At this
 point, let's conceive of this as a 2-day affair nested within the 4 days of
 ApacheCon.

 Keynote(s)
 a) PMC Chair (let's plan on graduation as a fact by early November, so we
 would ask our Chair to anchor the track keynote

If it is a two-day conference we could have a keynote each day.  The
PMC Chair could be a full keynote, or even just some short welcoming
remarks to open the conference.

 b) I/T Leader responsible for OpenOffice user communities

Also known as ICT.Do we have someone in mind?

 c)


 Meetups with other projects:
 a) Shindig/Rave
 b) Chemistry
 c) POI,Tika, PDFbox
 d) ...


Maybe ODF Toolkit (incubating) as well.

Could be worth having a 1 hour (or 45 minute or whatever the normal
session time is) to talk with each of these projects.  Or could be
informal.

 Hackathons
 -- topics?

 Social
 a) Fora
 b) National community groups: ...

 Other Topics?

Maybe set aside 60-90 minutes for a series of 5-minute lighting
talks. which could include short demos, etc.,  These can be fun.

Maybe discussion sessions for build, install, qa, localization, web,
security, marketing, UI, etc.  In some cases we might have formal
presentations in these areas.  But where we don't, and even where we
do, it might be worth having time set aside for discussion.


-Rob


Re: Extensions and Templates New Features

2012-08-13 Thread Roberto Galoppini
On Mon, Aug 13, 2012 at 9:12 AM, FR web forum ooofo...@free.fr wrote:

   1) Download statistics are now automatically obtained via the
   SourceForge API and are more reliable than the old system, in which
   the counters had been turned off and remained stuck for a long time
 Great!

 Is it possible to translate Timeline?
 In french, you could set Historique.
 Thanks


As a one-shot request it's now fixed, see:

http://extensions.openoffice.org/fr
http://templates.openoffice.org/fr/most_popular

For the future I'd like to workout similar request via Pootle with Apache
Infra, though. Of course we're open to generate all the PO files needed.

Roberto

-- 

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.



Help updating Apache OpenOffice timeline

2012-08-13 Thread Rob Weir
Remmeber this?

https://blogs.apache.org/OOo/entry/an_apache_openoffice_timeline

That was in March.  A lot has happened since then.

2012-05-08: Released OpenOffice 3.4
2012:05-15: 1 million downloads
2012-06-20: 5 million downloads
2012-07-31: 10 million downloads

I'm sure there are some other key milestones we can put here.  If you
have one you would like listed, please post the date and a short label
and I'll add it.

Regards,

-Rob


Re: Extensions and Templates New Features

2012-08-13 Thread Ariel Constenla-Haile
Hi Roberto,

On Mon, Aug 13, 2012 at 04:17:33PM +0200, Roberto Galoppini wrote:
 For the future I'd like to workout similar request via Pootle with Apache
 Infra, though. Of course we're open to generate all the PO files needed.

This would be really nice, at least to support translation for all the
languages we are building; now the templates site has more translations
than the extensions one, the later, for example, isn't translated into
Spanish, while the former is.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina


pgp0R4ivAuW0X.pgp
Description: PGP signature


Re: Help updating Apache OpenOffice timeline

2012-08-13 Thread Oliver-Rainer Wittmann

Hi,

On 13.08.2012 16:25, Rob Weir wrote:

Remmeber this?

https://blogs.apache.org/OOo/entry/an_apache_openoffice_timeline

That was in March.  A lot has happened since then.

2012-05-08: Released OpenOffice 3.4
2012:05-15: 1 million downloads
2012-06-20: 5 million downloads
2012-07-31: 10 million downloads

I'm sure there are some other key milestones we can put here.  If you
have one you would like listed, please post the date and a short label
and I'll add it.



2012-06-05 - 06-14: activation of update service for OOo 3.3 (*)
2012-07-12: activation of update service for OOo 3.2 and OOo 3.2.1 (*)


* for platforms and languages for whose we have AOO 3.4 release


Best regards, Oliver.


Re: Extensions and Templates New Features

2012-08-13 Thread Jürgen Schmidt
On 8/13/12 4:17 PM, Roberto Galoppini wrote:
 On Mon, Aug 13, 2012 at 9:12 AM, FR web forum ooofo...@free.fr wrote:
 
 1) Download statistics are now automatically obtained via the
 SourceForge API and are more reliable than the old system, in which
 the counters had been turned off and remained stuck for a long time
 Great!

 Is it possible to translate Timeline?
 In french, you could set Historique.
 Thanks

 
 As a one-shot request it's now fixed, see:
 
 http://extensions.openoffice.org/fr
 http://templates.openoffice.org/fr/most_popular
 
 For the future I'd like to workout similar request via Pootle with Apache
 Infra, though. Of course we're open to generate all the PO files needed.

that is a good idea and we have to analyze how it can work.

But we have to solve the Pootle issue first and have to ensure that the
Pootle server is running and working as expected. Currently it is not
working 100% and we have to solve this issue with infra together...

Juergen



Re: spell checker

2012-08-13 Thread Max Merbald

Hi Phil,

I had that too, at first, and I had to delete the Ooo folder in 
Appdata/Roaming which was probably somewhat addled. I installed Apache 
Openoffice again and then it worked.


Max


Am 12.08.2012 22:23, schrieb Phil Hocott:

Since I downloaded the apache version of open office my spelling and gramer 
doesn't work properly so I found an old copy of open office 3.1.0 and 
downloaded it and everything is fine.
Phil Hocott




Re: [RELEASE][3.4.1]: propose new snapshot based on revision 1372282

2012-08-13 Thread Jürgen Schmidt
On 8/13/12 10:27 AM, Jürgen Schmidt wrote:
 Hi,
 
 after a short break I have checked the current situation and where we are.
 
 We had identified some further issues for 3.4.1 while we continued
 testing the latest snapshots. These issues are now fixed and I would
 like to propose a new snapshot build based on revision 1372282.
 
 Issues that will be fixed in this new snapshot:
 
 - OO crashes when I Print
   https://issues.apache.org/ooo/show_bug.cgi?id=120389
 
 - Remove the Browser Plug-in tab page from the Options dialog
   https://issues.apache.org/ooo/show_bug.cgi?id=120518
 
 - Starting OpenOffice with -nodefault parameter should not open the
 StartCenter
   https://issues.apache.org/ooo/show_bug.cgi?id=120501
 
 The last 2 issues matched not directly our criteria for blocker issues
 but after reviewing the issues and the fix I decided to integrate them
 in 3.4.1 as well.
 The reason for integrating the last issue is quite simple and I believe
 that we probably share this view. We want that AOO is used in
 combination with other software systems and as backend service for
 document conversion etc. From my point of view it make sense to
 integrate this fix in 3.4.1.
 

The build is now available for MacOS and Windows.
https://cwiki.apache.org/confluence/display/OOOUSERS/Development+Snapshot+Builds

Linux upload is in progress and the wiki will be updated asap when the
builds are available.

Juergen



Importing pics to text on openoffice 3.4

2012-08-13 Thread Eric Klassen
When I import a pic into my text on 3.4, I am unable to move it around, or
to WRAP my text around the pic.  My previous version of openoffice gave me
a lot of flxibility when integrating pics with text.  I tried the forum
without success.  When I click on ANCHOR, the options are all grayed out;
when I click on WRAP, all options are grayed out except EDIT Contour.
Do you have any resolution to this problem.


Re: Importing pics to text on openoffice 3.4

2012-08-13 Thread Alexandro Colorado
On Mon, Aug 13, 2012 at 11:31 AM, Eric Klassen eric.klas...@gmail.comwrote:

 When I import a pic into my text on 3.4, I am unable to move it around, or
 to WRAP my text around the pic.  My previous version of openoffice gave me
 a lot of flxibility when integrating pics with text.  I tried the forum
 without success.  When I click on ANCHOR, the options are all grayed out;
 when I click on WRAP, all options are grayed out except EDIT Contour.
 Do you have any resolution to this problem.


Ok just saw your question on the forum. So just to understand what you have
done:
1) Go Insert - Image - From file...   select the image an image and want
to align it, correct?

Is this image on the page header by any chance?

Right clicking on the image will show you the Picture dialog box, on the
Anchor section it will list you different options:
1) To Page
2) To Paragraph
3) To Character
4) As character

This will help you arange your image more precise according to your needs.
When you find the closest please use the Position criteria to adjust it in
relation with the other objects of the document, like text, other images,
or page.

Here is more information on how to work yourself around the document.
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Arranging_anchoring_aligning

Here is another tutorial:
http://openoffice.blogs.com/openoffice/2009/01/how-to-insert-graphics-in-openoffice-writer-that-are-reasonably-manageable.html


Re: Yes. You can do this with OpenOffice. (MysteryGuitarMan video with OpenOffice Mac)

2012-08-13 Thread Risto Jääskeläinen

Hello!

This was too much challenge for me so my CalcTV is a bit unfinnished 
(-;  But compared to PixelMatrix i think using Cell styles may be a bit 
faster than lookup table?


Dont know if attachment is OK but I try to send small spreadsheet.

Greetings
Risto


11.08.2012 01:06, Andreas Säger kirjoitti:

Am 10.08.2012 02:24, Rob Weir wrote:


And here is the behind the scenes video that explains how he did it:

http://www.youtube.com/watch?v=6PCTinsZ7dM



Having a video converter which creates the coarse pixel frames, all 
you need is one matrix of color values per frame and script to dump 
them into the Calc document.


Matrix of 16 colors calculated from 32x32 random values:

http://www.mediafire.com/file/zfw69gddrcwacoc/PixelMatrix.ods








CalcTV.ods
Description: application/vnd.oasis.opendocument.spreadsheet


Re: Need MWiki Admin assistance to correct Google Analytics code

2012-08-13 Thread Rob Weir
No response to this note or BZ issue :-(

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

I'm told that we have only two people who have sys admin access to the
wiki:  imacat and Raphael.

I appreciate that we're all busy with many other things, but I'd
greatly appreciate it if this change can be made.  It should be easy
since Google Analytics is already integrated.  We just need to update
the account codes.

Thanks!

-Rob

On Mon, Aug 6, 2012 at 5:10 PM, Rob Weir robw...@apache.org wrote:
 I need some help, from a MWiki admin, to fix the issue reported here:
 https://issues.apache.org/ooo/show_bug.cgi?id=120301

 I tried a JIRA issue with Infra, but they said that our admins need to
 handle this.

 I'd be happy to do this myself, but I don't have permissions.

 Thanks!

 -Rob


Re: [Draft] The Public Service Mission of OpenOffice

2012-08-13 Thread Kay Schenk
On Thu, Jul 19, 2012 at 6:07 AM, Rob Weir robw...@apache.org wrote:

 On Thu, Jul 19, 2012 at 8:55 AM, Ariel Constenla-Haile
 arie...@apache.org wrote:
  Hi Jürgen, *,
 
  On Wed, Jul 18, 2012 at 07:47:42AM +0200, Jürgen Schmidt wrote:
  On 7/17/12 6:03 PM, Rob Weir wrote:
   I'd like to see if we can agree on a statement along these lines.  I
   think it is important that we show how our project aligns with
   Apache's overall mission, which the apache.org home page phrases as:
   provides support for the Apache community of open-source software
   projects, which provide software products for the public good.
  
   I think we do and always have been strongly aligned with this goal.
   But still, sometimes, we're questioned about our emphasis on
   distributing binaries, or seeking support for items related to
   distributing binaries.  In some ways we're the oddball at Apache,
   being the only prominent end-user facing project.  So I think it will
   help if we can express in clear terms how what we are doing is in fact
   for the public good, and our aims and achievements are at least as
   noble as what any other Apache project can claim.


Well I am still getting caught up from a while back and reviewing this
post. I think the wiki page is very good as it stands and this this
information should be incorporated on the project web page at least, may
be directly under the What is OpenOffice section, a new section The Public
Service Mission, or, if we want to remain flexible, make it into a page
that we can use to link from other areas -- the main www.openoffice.org. We
have this old about.html page, http://www.openoffice.org/about/

that is currently linked from the project web site. I think this mission
information should be included on that.

Yes/no? to any of these suggestions.



 
  I totally agree and that is of course the most annoying point here at
  Apache for me. But that is another topic and not for this thread.
 
  I guess it is because in Apache, so far, the idea was to provide
  software for the public good in form of source, for others to build
  their solutions upon. In OpenOffice's case, distributing binaries is
  also for the public good, not only for the reason mentioned by Rob, but
  mainly because OpenOffice provides a way to build your solution on top
  of its binary distribution with extensions, without needing to compile
  the source yourself, nor learn/modify a single line of code.
 

 This is a good point.  I remember reading, years ago, in a magazine
 called Computer Languages (now defunct) about a survey they did of
 corporate programmers, seeing what the most popular programming
 language was.  This was 1992 or so.  The answer was not C, not COBOL,
 but the 1-2-3 Macro language.   Today maybe such a survey would say
 Javascript?

 But the meaning is clear;:  there are more application developers than
 system developers.  And more script developers than application
 developers.  The closer you get to end user programming the larger
 your audience is and the more people you are helping.  You could think
 of the spreadsheet itself as support end-user programming.

  So it would be nice to have some numbers about extensions in Rob's paper
  (of course, we can only measure extensions on the extension's site; this
  will not include all the people builder their solutions in a commercial
  way).
 
 
  Regards
  --
  Ariel Constenla-Haile
  La Plata, Argentina




-- 

MzK

Never express yourself more clearly than you are able to think.
--
Niels Bohr


Re: [RELEASE][3.4.1]: propose new snapshot based on revision 1372282

2012-08-13 Thread Ariel Constenla-Haile
Hi Jürgen, *

On Mon, Aug 13, 2012 at 1:33 PM, Jürgen Schmidt
jogischm...@googlemail.com wrote:
 The build is now available for MacOS and Windows.
 https://cwiki.apache.org/confluence/display/OOOUSERS/Development+Snapshot+Builds

 Linux upload is in progress and the wiki will be updated asap when the
 builds are available.

Full install sets for en-US and language packs for all supported
languages (Linux 32 and 64 bits) are uploaded and listed on
https://cwiki.apache.org/confluence/x/f8KoAQ

I'll remove r1369110, it's 12 GB and I still need to upload all full
install sets (ca. 10.4 GB) and I'm not sure if there is a quota at
people.apache.org. I'll keep r1369843.


Regards.


Re: [RELEASE][3.4.1]: propose new snapshot based on revision 1372282

2012-08-13 Thread Kay Schenk
On Mon, Aug 13, 2012 at 3:38 PM, Ariel Constenla-Haile
arie...@apache.orgwrote:

 Hi Jürgen, *

 On Mon, Aug 13, 2012 at 1:33 PM, Jürgen Schmidt
 jogischm...@googlemail.com wrote:
  The build is now available for MacOS and Windows.
 
 https://cwiki.apache.org/confluence/display/OOOUSERS/Development+Snapshot+Builds
 
  Linux upload is in progress and the wiki will be updated asap when the
  builds are available.

 Full install sets for en-US and language packs for all supported
 languages (Linux 32 and 64 bits) are uploaded and listed on
 https://cwiki.apache.org/confluence/x/f8KoAQ

 I'll remove r1369110, it's 12 GB and I still need to upload all full
 install sets (ca. 10.4 GB) and I'm not sure if there is a quota at
 people.apache.org. I'll keep r1369843.


 Regards.


Thanks Ariel...I will download this now to check out.

-- 

MzK

Never express yourself more clearly than you are able to think.
--
Niels Bohr


Re: [Draft] The Public Service Mission of OpenOffice

2012-08-13 Thread Rob Weir
On Mon, Aug 13, 2012 at 5:09 PM, Kay Schenk kay.sch...@gmail.com wrote:
 On Thu, Jul 19, 2012 at 6:07 AM, Rob Weir robw...@apache.org wrote:

 On Thu, Jul 19, 2012 at 8:55 AM, Ariel Constenla-Haile
 arie...@apache.org wrote:
  Hi Jürgen, *,
 
  On Wed, Jul 18, 2012 at 07:47:42AM +0200, Jürgen Schmidt wrote:
  On 7/17/12 6:03 PM, Rob Weir wrote:
   I'd like to see if we can agree on a statement along these lines.  I
   think it is important that we show how our project aligns with
   Apache's overall mission, which the apache.org home page phrases as:
   provides support for the Apache community of open-source software
   projects, which provide software products for the public good.
  
   I think we do and always have been strongly aligned with this goal.
   But still, sometimes, we're questioned about our emphasis on
   distributing binaries, or seeking support for items related to
   distributing binaries.  In some ways we're the oddball at Apache,
   being the only prominent end-user facing project.  So I think it will
   help if we can express in clear terms how what we are doing is in fact
   for the public good, and our aims and achievements are at least as
   noble as what any other Apache project can claim.


 Well I am still getting caught up from a while back and reviewing this
 post. I think the wiki page is very good as it stands and this this
 information should be incorporated on the project web page at least, may
 be directly under the What is OpenOffice section, a new section The Public
 Service Mission, or, if we want to remain flexible, make it into a page
 that we can use to link from other areas -- the main www.openoffice.org. We
 have this old about.html page, http://www.openoffice.org/about/

 that is currently linked from the project web site. I think this mission
 information should be included on that.

 Yes/no? to any of these suggestions.


I have it here, on this page, but it is not linked to from anything yet:

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

It might work well to publicize this once we graduate.  But no
objections to using it earlier.

-Rob



 
  I totally agree and that is of course the most annoying point here at
  Apache for me. But that is another topic and not for this thread.
 
  I guess it is because in Apache, so far, the idea was to provide
  software for the public good in form of source, for others to build
  their solutions upon. In OpenOffice's case, distributing binaries is
  also for the public good, not only for the reason mentioned by Rob, but
  mainly because OpenOffice provides a way to build your solution on top
  of its binary distribution with extensions, without needing to compile
  the source yourself, nor learn/modify a single line of code.
 

 This is a good point.  I remember reading, years ago, in a magazine
 called Computer Languages (now defunct) about a survey they did of
 corporate programmers, seeing what the most popular programming
 language was.  This was 1992 or so.  The answer was not C, not COBOL,
 but the 1-2-3 Macro language.   Today maybe such a survey would say
 Javascript?

 But the meaning is clear;:  there are more application developers than
 system developers.  And more script developers than application
 developers.  The closer you get to end user programming the larger
 your audience is and the more people you are helping.  You could think
 of the spreadsheet itself as support end-user programming.

  So it would be nice to have some numbers about extensions in Rob's paper
  (of course, we can only measure extensions on the extension's site; this
  will not include all the people builder their solutions in a commercial
  way).
 
 
  Regards
  --
  Ariel Constenla-Haile
  La Plata, Argentina




 --
 
 MzK

 Never express yourself more clearly than you are able to think.
 --
 Niels Bohr


Re: Need MWiki Admin assistance to correct Google Analytics code

2012-08-13 Thread TJ Frazier

On 8/13/2012 17:20, Dave Fisher wrote:


On Aug 13, 2012, at 1:35 PM, Rob Weir wrote:


No response to this note or BZ issue :-(

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

I'm told that we have only two people who have sys admin access to the
wiki:  imacat and Raphael.

I appreciate that we're all busy with many other things, but I'd
greatly appreciate it if this change can be made.  It should be easy
since Google Analytics is already integrated.  We just need to update
the account codes.


I am also looking for help from the MWiki Admin to complete the activation of 
wiki.openoffice.org. It looks like the ATS code needs to recognize the URL (or 
MWiki does). The httpd config is simple so the trouble is not there.

Regards,
Dave


Dave,
AFAIK, Mwiki is only listening on 127.0.0.1, or some such, with ATS on 
the other end. I know of no one with ATS expertise (I would like to 
complain about stale pages), but it /is/ an active Apache project ...


/tj/


Thanks!

-Rob

On Mon, Aug 6, 2012 at 5:10 PM, Rob Weir robw...@apache.org wrote:

I need some help, from a MWiki admin, to fix the issue reported here:
https://issues.apache.org/ooo/show_bug.cgi?id=120301

I tried a JIRA issue with Infra, but they said that our admins need to
handle this.

I'd be happy to do this myself, but I don't have permissions.

Thanks!

-Rob









Re: [RELEASE][3.4.1]: propose new snapshot based on revision 1372282

2012-08-13 Thread Ji Yan
Thanks, I'll continue RC build testing, the result will be updated to [1]
timely.

[1]http://wiki.services.openoffice.org/wiki/QA/AOO341_RC_TestResult

2012/8/14 Kay Schenk kay.sch...@gmail.com

 On Mon, Aug 13, 2012 at 3:38 PM, Ariel Constenla-Haile
 arie...@apache.orgwrote:

  Hi Jürgen, *
 
  On Mon, Aug 13, 2012 at 1:33 PM, Jürgen Schmidt
  jogischm...@googlemail.com wrote:
   The build is now available for MacOS and Windows.
  
 
 https://cwiki.apache.org/confluence/display/OOOUSERS/Development+Snapshot+Builds
  
   Linux upload is in progress and the wiki will be updated asap when the
   builds are available.
 
  Full install sets for en-US and language packs for all supported
  languages (Linux 32 and 64 bits) are uploaded and listed on
  https://cwiki.apache.org/confluence/x/f8KoAQ
 
  I'll remove r1369110, it's 12 GB and I still need to upload all full
  install sets (ca. 10.4 GB) and I'm not sure if there is a quota at
  people.apache.org. I'll keep r1369843.
 
 
  Regards.
 

 Thanks Ariel...I will download this now to check out.

 --

 
 MzK

 Never express yourself more clearly than you are able to think.
 --
 Niels Bohr




-- 


Thanks  Best Regards, Yan Ji


Re: Need MWiki Admin assistance to correct Google Analytics code

2012-08-13 Thread Dave Fisher

On Aug 13, 2012, at 4:39 PM, TJ Frazier wrote:

 On 8/13/2012 17:20, Dave Fisher wrote:
 
 On Aug 13, 2012, at 1:35 PM, Rob Weir wrote:
 
 No response to this note or BZ issue :-(
 
 https://issues.apache.org/ooo/show_bug.cgi?id=120301
 
 I'm told that we have only two people who have sys admin access to the
 wiki:  imacat and Raphael.
 
 I appreciate that we're all busy with many other things, but I'd
 greatly appreciate it if this change can be made.  It should be easy
 since Google Analytics is already integrated.  We just need to update
 the account codes.
 
 I am also looking for help from the MWiki Admin to complete the activation 
 of wiki.openoffice.org. It looks like the ATS code needs to recognize the 
 URL (or MWiki does). The httpd config is simple so the trouble is not there.
 
 Regards,
 Dave
 
 Dave,
 AFAIK, Mwiki is only listening on 127.0.0.1, or some such, with ATS on the 
 other end. I know of no one with ATS expertise (I would like to complain 
 about stale pages), but it /is/ an active Apache project ...

BTW - The MWiki now answers to wiki.openoffice.org.

wiki.services.openoffice.org, doc.services.openoffice.org and 
ooo-wiki.apache.org are all redirected to wiki.openoffice.org.

This all happens in DNS and Apache Traffic Server.

Please describe the stale page problem.

Regards,
Dave

 
 /tj/
 
 Thanks!
 
 -Rob
 
 On Mon, Aug 6, 2012 at 5:10 PM, Rob Weir robw...@apache.org wrote:
 I need some help, from a MWiki admin, to fix the issue reported here:
 https://issues.apache.org/ooo/show_bug.cgi?id=120301
 
 I tried a JIRA issue with Infra, but they said that our admins need to
 handle this.
 
 I'd be happy to do this myself, but I don't have permissions.
 
 Thanks!
 
 -Rob
 
 
 
 
 



Re: request for enchancement of the define name function in calc

2012-08-13 Thread Jianyuan Li
If the defined name is correctly set, formula calculation result will be
corrected. So it is a formula issue and also a defined name issue.

2012/8/13 shzh zhao aoo.zhaos...@gmail.com

 I think it is a formula issue and not belong to name scope range.

 2012/8/10 Jianyuan Li lijianyuan1...@gmail.com

  Hi, Wang Lei,
 
  Below is my clarification for issue
  https://issues.apache.org/ooo/show_bug.cgi?id=119565. Comment is also
  added
  in Bugzilla.
 
  In Excel 2003 define a defined name as
  =Sheet1!$D$3:$D$5,Sheet1!$B$3:$B$5. In this defined name, a union
  operator(Excel uses , and AOO uses ~) is used to form a union area.
  This defined name will be passed into a formula SUM. Import them in AOO,
 by
  Excel 2003 filter the union operator will be translated into ; which is
  an old union operator. And SUM will take it as a parameter separator. So
  the SUM result seems correct while it is not in AOO.
  Union operator should be set as ~ in defined name in AOO. But a fix in
  Excel 2003 filter is not reasonable because:
  1. Defined name with union(OO uses ;) created in lower version
  OO(OOo2.4.3) still cannot be imported correctly even if a fix is patched
 in
  Excel 2003 filter.
  2. I have checked this formula =SUM((B3:B5,D3:D5))(union directly used)
  created in Excel 2003. It will be imported as =SUM((B3:B5~D3:D5)) which
  is correct. While Excel 2003 filter still imports the union as ;. But
 as
  last it is ~. Core function must does something which a hint to fix
 union
  issue in defined name.
 
  So please take consideration for it in the enhancement.
 
 
  Regards,
  Jianyuan
 
  2012/8/8 Lei Wang lei.wang.l...@gmail.com
 
   Hi Regina
  
   I saw your comments in
   https://issues.apache.org/ooo/show_bug.cgi?id=120478
  
   It is glad to know that ODF1.2 support sheet scoped defined name. It is
   very important to comply with ODF1.2. So our plan will be changed to
   Step 1, support interoperability with sheet scoped defined name in
 Excel.
   Because the solution is ready. it is our first priority.
   Step 2, support loading and saving ods file for sheet scoped defined
  name.
   We will put it in our AOO3.5 plan.
   Step 3, support create sheet scoped defined name in GUI in AOO.
  
   On Wed, Aug 8, 2012 at 5:00 PM, Regina Henschel 
 rb.hensc...@t-online.de
   wrote:
  
Hi shzh zhao,
   
there is no need for modifying ODF, named-expressions with scope on
 one
sheet are already specified and LibreOffice reads and writes such
   documents.
   
I think the order should be the other way round. First make AOO read
  and
write such named-expressions in ODF and then improve the import and
   export
filter.
   
Kind regards
Regina
   
shzh zhao schrieb:
   
 hi,
   
here is an interoperability issue in Aoo.
When loading VBA that contains defined name in Aoo, the names are
   changed
to a new one if the name is limited
in a worksheet in MS office.This will cause big problem.
   
After my investigation,I found it is an limitation of Aoo. Because
 MS
Excel
2003 can support worksheet scope defined name. but it can't be set
 in
   UI.
and Excel 2007 can define duplicate name for different sheet in its
  name
manager dialog.
When AOO loading a xlsx/xls file which has duplicated defined name,
  AOO
will only change the name to a unique one. But any other place which
   uses
the defined name is not changed, this is the root cause.
   
this enchancement will be completed in 2 steps.
in Currently step, just focus on the interoperability of MS defined
name.,and not modify the ODF file format.
   
if MS office defined range names with a sheet or a work book,import
 it
   in
Aoo,
make the name of work book in the original,but with a flag of global
name,for example,the name is Name_1,it will be Name_1 as before
 in
the define name dialog.
make the name of work sheet to the original,but with a flag of sheet
name,for
example,the name is Name_1,it will be Name_1 (sheet 1) in the
  define
name
dialog if the name is defined in the sheet 1.
   
here is the issue link:
https://issues.apache.org/ooo/**show_bug.cgi?id=120478
   https://issues.apache.org/ooo/show_bug.cgi?id=120478
   
   
   
  
 



 --
 *


 mailto: *aoo.zhaos...@gmail.com https://google.com/profiles
 https://google.com/profiles