[users] Re: MS Word Alternative

2011-08-08 Thread James Knott

Dale Erwin wrote:

but .odt is the proper file extension for ODF files.


For text files.  Spreadsheets use .ods etc.

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Basic – Feeling stupid…

2011-08-08 Thread Johnny Rosenberg
For years I have emptied arrays by just setting each element to 0 with
For loops. That's time consuming for big arrays and today when I was
looking at some old code I wrote a couple of years ago I ran into
those lines, and I thought that there must be a much better way to do
this, so I started thinking… And yes, of course there is!

How many times didn't I scratch my head when my array is suddenly
empty when I forgot ”Preserve” in ReDim? So why not just forget it by
purpose…?

Here's my example code:
REM  *  BASIC  *

Option Explicit

Sub Main
Const MaxElements=100

'   Create an array.
Dim A(1 To MaxElements) As Integer
Dim i As Long

'   Fill the array with some data.
Randomize
For i=1 To MaxElements
A(i)=Rnd*1000
Next i

'   Empty the array.
Dim Time As Long
Time=GetSystemTicks()
For i=1 To MaxElements
A(i)=0
Next i
Print GetSystemTicks()-Time

'   Fill it again.
For i=1 To MaxElements
A(i)=Rnd*1000
Next i

'   Empty it again.
Time=GetSystemTicks()
ReDim A(1 To MaxElements) As Integer
Print GetSystemTicks()-Time
End Sub

Running this, two message boxes (from the Print command) pops upp.
Typically the first one displays around 14000 (14213 when I tested a
few seconds ago) and the second one around 600 – 800 (797 in this
case, 638 is the lowest value so far). After trying a couple of times
it seems like the ReDim statement is about 20 times faster than the
For loop.

It doesn't really matter for small arrays, but the ReDim is a
one-liner, For requires three lines.

So now I feel really stupid that I didn't think of this before…

By the way, the getSystemTicks() function seems to return the time in
ms, at least on my system (did some experiments with it a while ago).
Try this one, for example:
REM  *  BASIC  *

Sub Main
Dim A As Long, B As Long, C As Long
A=getSystemTicks()
Wait 100
B=getSystemTicks()
Wait 100
C=getSystemTicks()
Print A, B, C
End Sub


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ
-- 
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Calc fails inexplicably

2011-08-08 Thread Dean Allen Provins, P. Geoph.
Hello:

Calc now offers VERY LARGE numbers of rows and columns.  On the surface
this seems great, but I have recently encountered problems updating a
spreadsheet which uses just IT columns and 1055 rows on the main sheet,
and about 9 subordinate sheets, mostly with just a few cells filled.
One sheet has graphs based on the contents of the main sheet (and it
can be a little slow to update).

The specific problem was that Calc simply aborted without warning
when I did an Edit-Fill-Down on several dozen columns.

The version is 3.3.0, M20, build 9567.

Another issue is that adding a reference takes forever - not just a long
time as the maintainers suggested.

One last issue is that OO when initiated without the command line option
-norestore, it says that it wants to restore a small CSV file that always
exists on my system.  If I click OK, it aborts, again without warning.

Anyone else had similar problems?  Are these bugs that need to be
reported?

Dean

-- 
   Dean Provins, P. Geoph.
 dprov...@alumni.ucalgary.ca
  KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65
  Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65
-- 
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: operating problem

2011-08-08 Thread Dave Barton
Copy to Roy Commander - Non-Subscribed Poster

 Original Message  
From: David Barlow davebar...@clear.net.nz
To: users@openoffice.org
Date: Mon, 08 Aug 2011 09:22:58 +1200

 I had the same thing and installed O.O. 3.3 WITHOUT uninstalling first -
 and it worked.
 
 Dave Barlow N.Z.
 
 --
 From: Johnny Rosenberg gurus.knu...@gmail.com
 Sent: Monday, August 08, 2011 8:21 AM
 To: users@openoffice.org
 Subject: [users] Re: operating problem
 
 2011/8/4 Roy Commander r...@talktalk.net:
 Hi

 I have been using Open Office for a number of years as a private
 individual.
 Suddenly it fails to work,I cannot access my files or open Open
 Office files
 without being asked to register which I have done on a number of
 occasions
 only to be back to no access, I have also tried uninstalling and
 reinstalling all to no avail. Can you help please I am a retired
 pensioner.

 Thanks Roy Commander UK



 Maybe if we know what you've got.
 What version of OpenOffice.org?
 What operating system (and version)?


 Kind regards

 Johnny Rosenberg

Roy,

You do NOT have to register to download, install or use OpenOffice.org
I recommend you take Dave Barlow's advice and get 3.3.0 from:
http://www.openoffice.org/

Dave

-- 
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: MS Word Alternative

2011-08-08 Thread Dave Barton
Copy to paul whitehill - Non-Subscribed Poster

 Original Message  
From: Doug dmcgarr...@optonline.net
To: users@openoffice.org
Date: Sun, 07 Aug 2011 17:18:22 -0400

 On 08/07/2011 04:18 PM, Johnny Rosenberg wrote:
 2011/7/30 paul whitehillwhitehill_p...@yahoo.com:
 Hi i  wonder  if  you  can  help me.
 I wonder that too�
 the alternative  seems to  have  a  charge £1.59 but  it says  it 
 is  free.
 What alternative and to what?
 OpenOffice.org is free if you download it at
 http://www.openoffice.org/. No charge what so ever, as long as you
 download it yourself.

 Is  the  open office Writer the  same as  MS Word  ?
 No. If it was, it wouldn't be free.

 This  is  the  software  I  want to  type up a  document,   can  you 
 help
 me  ?
 Well� download it from http://www.openoffice.org/, install it, run it
 and start typing�
 Don't forget to use Styles from the beginning. It will save you a lot
 of time later.
 There is built in help which is sometimes helpful. If not, ask
 specific questions here.

 Are  there  any  software  clashes,  Say i  want  to  send  a  document
 attached  to  my  e.mail,  will  it  Open  in  all  systems?
 Yes, as long as support for ODF is installed (like OpenOffice.org,
 LibreOffice, AbiWord, ODF-plugins for MS Office and so on). If the
 receiver doesn't have to edit your document, you can always send it as
 a PDF.

 Thanks,  please  answer  my questions

 Regards,

 Paul Whitehill.
 What's ODF?  My OO/LO/Symnphony wants to save in .odt.
 --doug

ODF (OpenDocument ISO/IEC 26300:2006 standard file format
http://en.wikipedia.org/wiki/ODF)



-- 
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: operating problem

2011-08-08 Thread David Barlow
To all.  My advice seems to have taken a step backwards.  Every time I open 
O.O. up, it now lasts for about a minute and then crashes, regardless of 
what I do.  I've tried everything I know and it won't come right.  Don't 
quite know what to do next.  Come back Sun Systems!


David Barlow N.Z.

--
From: Dave Barton d...@tasit.net
Sent: Monday, August 08, 2011 10:25 AM
To: users@openoffice.org
Cc: r...@talktalk.net
Subject: [users] Re: operating problem


Copy to Roy Commander - Non-Subscribed Poster

 Original Message  
From: David Barlow davebar...@clear.net.nz
To: users@openoffice.org
Date: Mon, 08 Aug 2011 09:22:58 +1200


I had the same thing and installed O.O. 3.3 WITHOUT uninstalling first -
and it worked.

Dave Barlow N.Z.

--
From: Johnny Rosenberg gurus.knu...@gmail.com
Sent: Monday, August 08, 2011 8:21 AM
To: users@openoffice.org
Subject: [users] Re: operating problem


2011/8/4 Roy Commander r...@talktalk.net:

Hi

I have been using Open Office for a number of years as a private
individual.
Suddenly it fails to work,I cannot access my files or open Open
Office files
without being asked to register which I have done on a number of
occasions
only to be back to no access, I have also tried uninstalling and
reinstalling all to no avail. Can you help please I am a retired
pensioner.

Thanks Roy Commander UK




Maybe if we know what you've got.
What version of OpenOffice.org?
What operating system (and version)?


Kind regards

Johnny Rosenberg


Roy,

You do NOT have to register to download, install or use OpenOffice.org
I recommend you take Dave Barlow's advice and get 3.3.0 from:
http://www.openoffice.org/

Dave

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help 


--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: operating problem

2011-08-08 Thread David Barlow
I have just found that if  disconnect from the net, O.O. operates perfectly 
well without 'crashing!'


David Barlow N.Z.

--
From: David Barlow davebar...@clear.net.nz
Sent: Tuesday, August 09, 2011 12:55 PM
To: users@openoffice.org
Subject: [users] Re: operating problem

To all.  My advice seems to have taken a step backwards.  Every time I 
open O.O. up, it now lasts for about a minute and then crashes, regardless 
of what I do.  I've tried everything I know and it won't come right. 
Don't quite know what to do next.  Come back Sun Systems!


David Barlow N.Z.

--
From: Dave Barton d...@tasit.net
Sent: Monday, August 08, 2011 10:25 AM
To: users@openoffice.org
Cc: r...@talktalk.net
Subject: [users] Re: operating problem


Copy to Roy Commander - Non-Subscribed Poster

 Original Message  
From: David Barlow davebar...@clear.net.nz
To: users@openoffice.org
Date: Mon, 08 Aug 2011 09:22:58 +1200


I had the same thing and installed O.O. 3.3 WITHOUT uninstalling first -
and it worked.

Dave Barlow N.Z.

--
From: Johnny Rosenberg gurus.knu...@gmail.com
Sent: Monday, August 08, 2011 8:21 AM
To: users@openoffice.org
Subject: [users] Re: operating problem


2011/8/4 Roy Commander r...@talktalk.net:

Hi

I have been using Open Office for a number of years as a private
individual.
Suddenly it fails to work,I cannot access my files or open Open
Office files
without being asked to register which I have done on a number of
occasions
only to be back to no access, I have also tried uninstalling and
reinstalling all to no avail. Can you help please I am a retired
pensioner.

Thanks Roy Commander UK




Maybe if we know what you've got.
What version of OpenOffice.org?
What operating system (and version)?


Kind regards

Johnny Rosenberg


Roy,

You do NOT have to register to download, install or use OpenOffice.org
I recommend you take Dave Barlow's advice and get 3.3.0 from:
http://www.openoffice.org/

Dave

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help 


--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help