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

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