gmane.comp.openoffice.general

Now available: Apache OpenOffice Announcement List

Rob Weir — 2011-12-27T00:29:21

The Apache OpenOffice Project Management Committee is pleased to
announce the availability of our new Announcement mailing list.  This
is a low-volume list which will be used to announce the availability
of OpenOffice betas and releases, to issue security bulletins, and to
report similar relevant information.  This is not a discussion list.
It will be used only for authoritative announcements regarding Apache
OpenOffice.

We encourage all OpenOffice users and other interested parties to
subscribe to this list by following these steps:

1) Send an email to:   ooo-announce-subscribe< at >incubator.apache.org

2) Wait a few minutes and then check your inbox for a confirmation email.

3) Respond to the confirmation email

(If you ever want to unsubscribe, send an email to:
ooo-announce-unsubscribe< at >incubator.apache.org and respond to the
confirmation email.)

More information on this list, and other Apache OpenOffice project
lists can be found here:

http://incubator.apache.org/openofficeorg/mailing-lists.html

Regards,

-Rob

Fwd: Open Office 3.3 Problems

2011-11-22T20:45:07

Further to the subject, I continue to encounter anomolies and  
misfunctions:  Re. the "VLOOKUP(), the references are to *.cvx, i.e.  comma (,) 
delimited spreadsheets. Each time the objective file is opened (i.e.  referring 
file), OO 3.3 brings up "Text Import" to convert to an *.xls.format. I  save all 
files in .xls format to maintain compatability. With OO 3.2 upon first  
time import I would convert to *.xls format; thereafter with each opening  of 
the objective file, upon clicking "Update), the file would open updated from  
all imported files. 
 
The previously mentioned problem, that "Paste Special"-numbers &  formats 
only from a VLOOKUP cell, pastes an empty cell. This rendere OO 3.3  useless 
to me.
 
Is OO 3.3 the latest version?, If there is a more recent version I would  
try it. Otherwise, I either need OO 3.2 or must go to another office program. 
I  can't imagine the problems are unique to my applications. What say you?
 
 
 
 
  
____________________________________
 From: Jreyr< at >aol.com
To: discuss< at >openoffice.org,  Malte.Timmermann< at >Sun.COM
Sent: 11/21/2011 5:01:05 P.M. Pacific Standard  Time
Subj: Fwd: Open Office 3.3


Further to the subject email, below, also "Paste Special", numbers &  
formats will not paste any value; it is blank; "Paste Special"-text, numbers  & 
formats pastes the numeric value as text, and so calculation still will  not 
occur. Attempt to Paste Special again eliminating "text" yields blank  
cells. Right now I am out of business with OO 3.3!
 
 
  
____________________________________
 From: Jreyr< at >aol.com
To: discuss< at >openoffice.org,  Malte.Timmermann< at >Sun.COM
Sent: 11/21/2011 4:46:17 P.M. Pacific Standard  Time
Subj: Open Office 3.3


I have been using OO 3.2 with good success. But upon installing and  using 
OO 3.3 I am encountering serious problems. That which I know so far is  that 
OO3.3 Spreadsheet  will not carry out calculations  wherin one or more 
values are obtained via a VLOOKUP.function  Specifically I have several 
spreadsheets that obtain values from another  spreadsheet. E.g. a specific code is:
 
=VLOOKUP($A16;'file:///C:/Documents and Settings/jreyr/My  
Documents/ATTACHE-FINANCE/GJJT last.xls'#$Sheet1.$A$2:$M$27;2;FALSE())
 
If I paste special so that the actual numeric value is present, the  
calculations proceed OK.
 
Calculations are carried out OK with OO 3.2. 
 
This situation with OO3.3 is unsatisfactory and is uselrss to me. Upon  
installing OO3.3, OO 3.2 is gone. Is there a remedy to the VLOOKUP problem  or 
is OO3.2 available? The calculations are carried out daily, so I am   in 
real trouble with this and urgently await a reply.
 
s/G.G.  Wire

Re: Digest for list discuss< at >openoffice.org

Michael Amann — 2011-11-23T10:27:41

Have you tried ooo 3.4?
 On Nov 23, 2011 5:47 AM, <discuss-request< at >openoffice.org> wrote:

Open Office 3.3

2011-11-22T00:46:17

I have been using OO 3.2 with good success. But upon installing and using  
OO 3.3 I am encountering serious problems. That which I know so far is  that 
OO3.3 Spreadsheet  will not carry out calculations  wherin one or more 
values are obtained via a VLOOKUP.function  Specifically I have several 
spreadsheets that obtain values from another  spreadsheet. E.g. a specific code is:
 
=VLOOKUP($A16;'file:///C:/Documents and Settings/jreyr/My  
Documents/ATTACHE-FINANCE/GJJT last.xls'#$Sheet1.$A$2:$M$27;2;FALSE())
 
If I paste special so that the actual numeric value is present, the  
calculations proceed OK.
 
Calculations are carried out OK with OO 3.2. 
 
This situation with OO3.3 is unsatisfactory and is uselrss to me. Upon  
installing OO3.3, OO 3.2 is gone. Is there a remedy to the VLOOKUP problem or 
is  OO3.2 available? The calculations are carried out daily, so I am  in real 
 trouble with this and urgently await a reply.
 
s/G.G. Wire-- 
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscribe< at >openoffice.org
For additional commands send email to sympa< at >openoffice.org
with Subject: help

About Openoffice

Diego León Ullauri — 2011-11-21T16:30:27

Hello Friends

I want to know when Openoffice will be in
the cloud

I'll be waiting for your commentes
diego

----------
http://www.DiegoLeonUllauri.com-- 
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscribe< at >openoffice.org
For additional commands send email to sympa< at >openoffice.org
with Subject: help

Re: Problem with the Open Office Text Processing

Larry Gusaas — 2011-11-16T03:54:50

Opens fine in OOo, LibreOffice, NeoOffice, and Pages.

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-16T03:10:54

xml of the code between section 2 and section 4 from the original:

</w:t></w:r></w:p><w:p w:rsidR="00633641" w:rsidRDefault="00633641"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr><w:sectPr
w:rsidR="00633641" w:rsidSect="00633641"><w:type
w:val="continuous"/><w:pgSz w:w="12240" w:h="15840"/><w:pgMar
w:top="1440" w:right="1440" w:bottom="1440" w:left="1440" w:header="720"
w:footer="720" w:gutter="0"/><w:cols w:space="720"/><w:docGrid
w:linePitch="360"/></w:sectPr></w:pPr></w:p><w:p w:rsidR="005F75F9"
w:rsidRPr="00633641" w:rsidRDefault="005F75F9"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs
w:val="24"/></w:rPr><w:lastRenderedPageBreak/><w:tab/></w:r></w:p><w:p
w:rsidR="004E2C77" w:rsidRPr="00633641" w:rsidRDefault="004E2C77"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:tab/></w:r></w:p><w:p
w:rsidR="004E2C77" w:rsidRPr="00633641" w:rsidRDefault="004E2C77"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:tab/></w:r></w:p><w:p
w:rsidR="00FF51CE" w:rsidRPr="00633641" w:rsidRDefault="00FF51CE"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr></w:p><w:p
w:rsidR="00FF51CE" w:rsidRPr="00633641" w:rsidRDefault="00FF51CE"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:tab/></w:r></w:p><w:p
w:rsidR="00FF51CE" w:rsidRPr="00633641" w:rsidRDefault="00FF51CE"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:tab/></w:r></w:p><w:p
w:rsidR="000D078E" w:rsidRPr="00633641" w:rsidRDefault="00FF51CE"
w:rsidP="007E3ECA"><w:pPr><w:pStyle w:val="NoSpacing"/><w:rPr><w:rFonts
w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:cs="Times New
Roman"/><w:sz w:val="24"/><w:szCs w:val="24"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:tab/></w:r><w:r
w:rsidR="000D078E" w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times
New Roman" w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/></w:rPr><w:br
w:type="page"/></w:r></w:p><w:p w:rsidR="000D078E" w:rsidRPr="00633641"
w:rsidRDefault="000D078E" w:rsidP="007E3ECA"><w:pPr><w:pStyle
w:val="NoSpacing"/><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/><w:u
w:val="single"/></w:rPr></w:pPr><w:r
w:rsidRPr="00633641"><w:rPr><w:rFonts w:ascii="Times New Roman"
w:hAnsi="Times New Roman" w:cs="Times New Roman"/><w:sz
w:val="24"/><w:szCs w:val="24"/><w:u
w:val="single"/></w:rPr><w:lastRenderedPageBreak/><w:t>References<

And from mine with the section deleted:

So something in the first is causing the crashes.

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-16T02:59:10

I think that I may have found the issue; I opened in MS Word 2002 with
the MS odf extension installed and found that there is an extra section
between the last text column and the references page. In other words it
went from section 2 at "intent of the law could be solidified." to a
blank section 3, and then section 4 which is the 'Refrences' page. I
deleted the section 3 and then did a saveas. Attached is the .docx from
that & it no longer crashes my linux OOO's or LO's.

Seems odd that a blank section would cause this. Please test on the Mac.
Thanks.

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-16T02:34:53

Interesting & thanks for testing.

On WinXP OOo didn't crash (but dual columns in 2-5, no page 6 with
references):

OOo 3.3.0
OpenOffice.org 3.3.0
OOO330m20 (build:9567)

or

OOo-Dev (Windows)
OOo-dev 3.4.0
OOO340m0 (Build:9583)

LO (Windows same VM):
LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.1

Doesn't crash. Again, dual columns in 2-5, no page 6 with references. I
wonder why this only crashes non-windows versions.

So it appears that there are two issues: 1) the .docx crashes other
non-windows versions tested (linux, Mac), and 2) even when the file
opens it is missing the references page. OOo 3.2.1 (go-oo Ubuntu
distribution build linux)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1. opens the document &
displays the reference page, but 2-6 are single column.

Overall pretty disappointing results as the .docx doesn't contain
anything special (formating-wise).

If I get time I'll try to save to a .doc and see if there are any major
differences.

Gary

Re: Problem with the Open Office Text Processing

Larry Gusaas — 2011-11-16T02:22:14

That is basically the same as the original opened in Pages on my Mac.

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-16T01:54:04

I have WinXP on a VMWare virtual machine; opened the file in MS Word
viewer and get all 6 pages (2-5 are dual columns, page 6 is the
references page). Not sure if the PDF will be accepted as an attachment,
but I'll give it a try (it's 29.2KB) so that it can be used for comparison.

Re: Problem with the Open Office Text Processing

Larry Gusaas — 2011-11-15T04:45:56

On 2011-11-14 9:59 PM  NoOp wrote:

On Mac OS X version 10.6.8 OOo 3.3.0, OOo-dev 3.4.0, NeoOffice 3.1.2 Patch 9, and LibreOffice 
3.4.4 all crash immediatly and leave a lock file.

Pages, TextEdit, and Bean all open document with references and biograpy.


Bug reports can be filed on the Apache OOo Bugzilla – Main Page
https://issues.apache.org/ooo/

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-15T03:59:37

Found an old version of Windows 2KPro on one of my virtual machines that
still has OOo 3.3.0 OOO330m20 (build:9567) and opening the .docx file in
that demonstrates what you probably are experiencing: only 5 pages, dual
columns in pages 2-5, and no References and Biography page.

Again, this appears to be a a regression between 3.3.0 and OOo-Dev
(3.4.0). Given the OOo - Apache conversion I'm not even sure if you can
file a bug report any longer (at least I've no idea how). But hopefully
someone from Apache will pick up on this post and see if they can pass
it along to their devs. If I've time tomorrow I'll try to remember to
file a bug report with LO.

Re: Problem with the Open Office Text Processing

NoOp — 2011-11-15T02:45:48

...
This is interesting. I tried your document on the following:

1. OOo 3.2.1 (go-oo Ubuntu distribution build linux)
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.

The file opens properly and displays 7 full pages of text including
References and Biography etc., with no problem.

2. OOo-Dev (standard build linux)
OOo-dev 3.4.0
DEV300m106 (Build:9582)

Crashes OOo immediately & leaves a lock file in place.

3. LibreOffice 3.3.4 (standard build linux)
LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.

Crashes LO immediately & leaves a lock file in place.

4. LibreOffice 3.4.4 (standard build linux)
LibreOffice 3.4.4
OOO340m1 (Build:402)

Crashes LO immediately & leaves a lock file in place.

Unfortunately I no longer have earlier 'standard' OOo versions installed
or I would have tested with them as well. In any event it appears that
you have a reportable bug.

Re: CAN SOMEONE PLEASE HELP

Joost Andrae — 2011-11-07T20:48:41

Hi Tracey,

if it is version 3.3.0 and if the operating system on your computer is 
Windows then install the following:

http://download.services.openoffice.org/files/stable/3.3.0/OOo_3.3.0_Win_x86_langpack_en-US.exe

Then start OpenOffice.org and switch the UI language in 
/tools/options/language settings/language/ to English. Then restart 
Openoffice.org and you're done.

Am 07.11.2011 19:18, schrieb Tracey:

Kind regards, Joost

New Google Plus OpenOffice.org page

Alexandro Colorado — 2011-11-08T00:28:51

Hi if you are into Google plus you can now follow OpenOffice.org at
http://plus.ly/openofficeorg

Re: HTMT interactive

Bruce Martin — 2011-11-06T19:27:11

Dear Eduardo:

Depending on the details of what you would like to do, this should be 
quite possible.

I have done spreadsheet workbooks to handle:

-    Industrial chemical inventories with ongoing turnover (Weight or 
Volume, English or Metric, Canadian or U.s. Dollars in combination. This 
was normally used ongoing day to day to manage purchasing and stock 
reserve for jobs planned for production.


-    Sales tracker for an Automobile dealer: This dealer has about 20 
regular salesmen and one Fleet Salesman. A regular salesman could sell 
up to 100 vehicles a month. The Fleet salesman could sell up to 200, as 
he was selling largely to Car rental companies during the month, 
possible with some government sales.

A secretary supported the sales team full time, entering certain 
specific information about each sale in the sheet related to the 
salesman who sole it. e.g. Profit figure, model and type, duration of 
lease, etc. and type of contract.

Each model and each type of contract had specific mnemonic codes that 
were common to dealers in that brand of vehicles.

At the end of the month, only 2 of about 25 sheets were printed: One 
went to the sales manager to support his keeping track of thew 
performance of each salesman.

The other went to the general manager who, as far as I now used his 
customized report to determine which cars he would order in the next 
business cycle from the auto manufacturer - This would suggest a lot of 
financial responsibility resting on that report!

The spreadsheet was then cloned for each successive month without the 
input data and so the cycle repeated monthly.

-    Another application was designed for industries based in a recipe 
by weight with adds testing.

The initial recipe was entered with quantities designed to produce a 
test batch of 50 gm. This was then made up in the lab and tested. If the 
qualities desired were not exactly satisfactory, the lab would add small 
snippets of one or other ingredient.

Each time the lab had to add, naturally the batch was larger than 50 gm. 
Therefore the batch ingredient weights were "normalized' or proportioned 
to render weights for a 50 gram batch with the modified proportions of 
the ingredients. The spreadsheet would track this for up to 10 adds.

Since the mixing machine had a capacity of 50 Kg., it was easy to 
multiple the normalized weights by 1000 to get a list of a production batch.

When an order came in, the requested quantity was divided by the batch 
size of 50 Kg. to give the number of batches needed for the order.

In another sheet, a bill of ingredients automatically calculated the 
total weight of each ingredient needed for the whole order.

In another column of this sheet, the weight of available stock for each 
ingredient was pasted from the ongoing inventory, and the remaining 
quantity in stock after the order was filed would be shown. In the event 
that there was insufficient quantity of any ingredient, a red flag would 
show to draw the stock manager's attention.

He then could arrange purchasing for the shortages.

Finally he could post a reserve quantity for any or all of the 
ingredients in the inventory so that the proforma available quantities 
would show. A bottom line figure for the value of inventory with or 
without the reserved items would then show on the summary page.

In the summary page, each ingredient was a line, the totals being pinned 
at the top.
In the column on the summary page where the product description was to 
go, the descriptions were actually hyperlinks to the corresponding 
detail "electronic ledger" pages, so there was no need to struggle with 
the tabs in a workbook of easily 100 sheets.

Generally, in each application, the details are entered in detail pages, 
and the results show on one or more summary pages, depending on how many 
different report are needed to support different personnel each with 
different needs.

¡La versatilidad y la complexidad son hermanos - son siempre in los 
mismos lugares!


Bruce Martin,
Greater Montreal area,
Quebec
Canada.

On 11/5/2011 5:28 PM, Eduardo Araujo wrote:

HTMT interactive

Eduardo Araujo — 2011-11-05T21:28:11

I would like to publish an OOcalc spreadsheet adding interactive 
feature, in order the users can change some contents. Does is 
possible to do this using OO 3.3 ?
thanks
Eduardo

Re: Announcement: New Apache OpenOffice.org mail list to replace this list

Rob Weir — 2011-11-02T14:05:19

Many more users participate via the Community Forums, at:
http://user.services.openoffice.org/en/forum/

There are also versions in other languages:
http://user.services.openoffice.org/

The English-language support forum has over 45,000 members, for
example.  Based on the feedback I've received, some users hate email
lists, while others hate forums.  So we will continue to have both for
user support questions and users can select to participate in either
venues, or both.

Regards,

-Rob

Re: Announcement: New Apache OpenOffice.org mail list to replace this list

Mike Scott — 2011-11-02T13:49:53

...

Thanks. That's an interesting page - first time I've seen the numbers of 
subscribers anywhere. Is anyone else concerned that the number of 
'users' subscribers is only 1852? It seems remarkably few to me, 
especially as the 'dev' list has well over 600.

Re: Announcement: New Apache OpenOffice.org mail list to replace this list

Rob Weir — 2011-11-02T12:23:38

That is correct.  We're combining both lists into the ooo-users list.
Although some people explained that the user and discuss list had
different goals initially, when they were first created, none of us
were able to discern any actually difference today in what topics were
being discussed.  Both lists ranged from project discussions, support
questions, general chat, etc.

The OpenOffice.org project had 300+ mailing lists.  The Apache project
will have far fewer lists, but hopefully higher energy, more active
lists.  So we hope to have no more than 10 or so lists in the end,
mapping each of the legacy lists into a new list.

You can see the proposed mapping, for the top 100 OOo lists here:

https://cwiki.apache.org/confluence/display/OOOUSERS/Mailing+lists

Regards,

-Rob