Re: [libreoffice-users] 2 Questions about Calc in LibreOffice

Hi :)
It's good to have bug-reports that have identified a specific part of a 
problem.  A vastly long bug-report that gives a good overview of a problem is 
good but smaller reports that address a specific part of that problem are 
probably easier to work with.  


There is a guide on how to post a bug-report 
http://wiki.documentfoundation.org/BugReport
Regards from
Tom :)




________________________________
From: Bill Gradwohl <bill@ycc.com>
To: users@global.libreoffice.org
Sent: Fri, 26 August, 2011 17:14:31
Subject: Re: [libreoffice-users] 2 Questions about Calc in LibreOffice

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/26/2011 03:44 AM, plmvantooren@hetnet.nl wrote:
>         The problem I met, is that when the document is saved and closed, the 
> scrolling bars are  corrupted in  that way, that these are 0,05 mm high instead 
> of 0,5 mm as I have set-up the bar.
>         I have already tried to overcome this problem by insert the scroll-bar 
> first, save then the document and after that to complete the scroll-bar with its 
> features.
>         This has not worked at all, the same problem occurred
>
> 2.    In the same document there are a lot of references made to others pages 
> of the same document.
>         Very often I found that in some places these references are changed by 
> the system (?) in a totally different and not relevant reference.
>         Each time this anomaly occurs, I have to reconstruct the references in 
> the correct way.
...
...
...
> Both these “errors” also happens in the version 3.3 of OpenOffice.org Calc. 
> From there I have put the same remark (a few months ago)  without getting an 
> answer. 
>
> Is is possible to provide me with information about How to solve these two 
> problems?

See bug https://bugs.freedesktop.org/show_bug.cgi?id=39930
I submitted it a few weeks ago. It falls under the general heading of
"file corruption" which in my experience is common with OO / LO CALC if
you build anything of any consequence.

I also believe the IDE causes corruption as I see corruption errors pop
up shortly after I make changes via the IDE. My spreadsheet works fine
for months, but as soon as I touch it with the IDE I can expect issues
fairly quickly.

My testing tells me that these types of errors occur when the document
is saved to its xml form. When its in use ( in memory ) it functions
normally. When you save and reload it, that's when it comes out corrupted.

I have had cases where deleting a sheet in a spreadsheet document
functions fine after the delete. A save and reload produces a bogus
password error and the document is trashed. If its fine for hours after
the sheet delete, and then the document is trashed when it is
subsequently saved and reacquired, then the save / open code in LO is
most likely the source of the bug(s).

I've manually remove 110K of xml rubbish from a spreadsheet that is 250K
in its clean state. The routine that writes the spreadsheet to disk is
most likely the problem.

- -- 
Bill Gradwohl
Roatan, Honduras
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk5XxmEACgkQ7Orvev+eC8qkdQCgqgQ1LvYJSt036Vzb4X7XiuCE
cQQAoJdEazb43a+fxILwFXzZMGZjdP/L
=54ok
-----END PGP SIGNATURE-----

-- 
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