Question about Calc and Annotations

users
#1

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

#2

Hi :slight_smile:
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 :slight_smile:

#3

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

#4

Hi :slight_smile:
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 :slight_smile:

#5

Hi Alex,

alex sato wrote (19-01-12 01: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??

Not that I know. On the other hand: I never tried :slight_smile:
And you did, in a very comprehensive way, if I also judge your second post!

I think some of the devs will be very happy with your trial / posts.

I include a link to your posts here - lets see what their judgement is about the need/use to create a bug report.
   http://listarchives.libreoffice.org/global/users/msg15541.html
   http://listarchives.libreoffice.org/global/users/msg15612.html

Work is going in on all sorts of re-work in Calc, so it might be that this is on the radar already. Maybe not.

Thanks so far - to be continued,

#6

Hi, Tom.

to switch off Java I just need to uncheck "Use a Java runtime environment"?
I did it, restarted the LO3.5beta3 and I don't see any difference.

Alex Mitsio Sato

#7

Hi Cor,

I'm writing this just to say "thanks".

Sorry for my poor english that sometimes turn me incapable to say exactly
what I want.

Regards

Alex Mitsio Sato

#8

Hi :slight_smile:
Cor is a star here as are quite a few others.  It's really good to hear from someone that understands what is going on in the devs list.  Don't worry about your English.  It is better than many people that were born and raised in my country (i live in England)! :slight_smile:
Regards from
Tom :slight_smile:

#9

Hi :slight_smile:
Yes, unticking the option "Use a Java runtime environment" does stop java
from being used. If the freezing and slowdowns still happen then there is
no need to change to a different version of java. Might as well leave it
ticked/checked on the other machines because it has no effect.
Regarsd from
Tom :slight_smile:

#10

Hi Alex,

Cor Nouws wrote (19-01-12 23:19)

I think some of the devs will be very happy with your trial / posts.

I had a short chat with Markus.
It's not exactly something they currently work on. On the other hand, they have a recent very positive experience with someone who helped to get great performance improvement in another area:
http://kohei.us/2011/11/30/performance-improvement-in-opening-ods/

You may get the hint: i you are in need for 18000 annotations and are using macros for creating things like that, it might be a possible step...
How does that sound ? Maybe it looks way to complicated. But reading the blog, I know that there was great support for Laurent too.

Cheers,

#11

Hi Cor!

I'm using Calc to manage documents from job where each row correspond to a
document and has information like dates, values, names, etc., and one
historic description that some times takes very long. I made a test
inserting historic as annotation and the result looks very good, except the
slow down/freezing aspect that do not occurs in MS Office 2010.
Actually I inserted the historic as normal string, that is a little
difficult to search as I need to press F2 in the selected cell (after using
normal search) to see what is written. By the way, that multiline inputbar
implemented in LO3.5beta would solve this problem but I cannot use beta
version at work (however I don't know why we still using LO3.3 there). :-/
:wink:

Regards

Alex Mitsio Sato