Re: [libreoffice-users] Question about Calc and Annotations

Hi :)
On 1 machine can you try switch off Java in LibreOffice?

Tools - Options - Java

This is just a test to see if java is causing the problem but it's unlikely.  It's just that 
freezing and slow-downs fit the pattern.  

Wizards and some Extensions use java.  So does Base if you use the in-built back-end.  So, it's 
possible that you might be able to do without java completely if you are lucky.  If you do need it 
then you tend to get error messages rather than data-loss.  In which case you just switch java back 
on and then re-open LO with no harm done.  

If you do need java then version JRE 6u21 stops the freezing and works faster but has significant 
security issues on Windows.  
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html

LibreOffice 3.5.0 is due out soon 
http://wiki.documentfoundation.org/ReleasePlan  
(6th Feb but out as beta already i think) and that can handle JRE 7
http://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html#javasejdk

The devs are working hard at writing out any need for java but Base is tricky.
Regards from
Tom :)



--- On Thu, 19/1/12, alex sato <amsxdkc@gmail.com> wrote:

From: alex sato <amsxdkc@gmail.com>
Subject: Re: [libreoffice-users] Question about Calc and Annotations
To: users@global.libreoffice.org
Date: Thursday, 19 January, 2012, 20:47

I tested in following configurations:
-Windows7 PT-BR/ BrOffice 3.2
-Windows7 PT-BR / LO 3.3
-Windows XP PT-BR (SP3) / BrOffice 3.1
-Windows XP PT-BR (SP3) / LO 3.3
-Windows XP JP (SP3) / LO 3.4
-Windows XP JP (SP3) / LO 3.5beta3

2 versions in each of 3 machines that I have access (one is my own computer)
all acting the same way.

About Java version. In my machine is Java6 - Version 6 Update 29 (Build
1.6.0_29-b11)

Regards

Alex Mitsio Sato





On Thu, Jan 19, 2012 at 7:49 AM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

> Hi :)
> I don't think it's normal.Please could you let us know which release of
> LibreOffice you are using?  Try
> Help - About
> to find out.  Also which version of java
> Tools - Options - Java
> Although it seems unlikely that java would be involved in that sort of
> operation (hopefully).  The OS you are using might be good to know too.
> Windows, Ubuntu or some other Gnu&Linux such as Mint, Mageia, Fedora or
> whatever, Mac or Bsd?
>
> You might find that renaming the UserProfile fixes things as it resets all
> settings to "factory defaults" and hides your Extensions/Add-ons/Plug-ins
> http://wiki.documentfoundation.org/Documentation/UserProfile
>
> Regards from
> Tom :)
>
> --- On Thu, 19/1/12, alex sato <amsxdkc@gmail.com> wrote:
>
> From: alex sato <amsxdkc@gmail.com>
> Subject: [libreoffice-users] Question about Calc and Annotations
> To: users@global.libreoffice.org
> Date: Thursday, 19 January, 2012, 0:04
>
> Is it normal Calc to freeze some minutes when resizing the width of a
> column in a blank sheet that only has a column filled with 18000 cells with
> annotation??
> Nothing abnormal happens here when the sheet has 18000 cell with normal
> data instead annotation.
> Just opening the file take long time too here.
>
> By the way, there is no slow down or freezing when using it in MS Office
> 2010 (file saved in ODS format, not XLS).
>
> I did a macro to insert annotations in 18000 cells for test purpose.
>
> Sub Add18KAnnotations
> dim p as integer
> p=0
> dim m(3) as string
> m(0)="ABCDEFGHIJKLMNOPQRSTUVWXYZ"
> m(1)="0123456789 0123456789"
> m(2)="abcdefghijklmnopqrstuvwxyz"
> m(3)="0123456789 0123456789"
> dim s as object
> dim n as object
> dim y as integer
> dim c as object
> dim a as object
> s = thisComponent.sheets(0)
> n = s.getAnnotations()
> for y=0 to 18000
>     c=s.getCellByPosition(2,y)
>     a=c.CellAddress
>     n.insertNew(a,"-""m(p))
>     p=p+1
>     if p=4 then p=0
> next y
> End Sub
>
>
> Thanks
>
> Alex Mitsio Sato
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted