Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2017? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - Corrupted Embedded Items in Writer Docs
Corrupted Embedded Items in Writer Docs
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 5:51 am    Post subject: Corrupted Embedded Items in Writer Docs Reply with quote

All of us use writer at work and recently we are experiencing repeated problems where calc spreadsheets used in writer docs start showing up with the plug icon. We need help badly because we have to use lots of these in documents and may have to stop using NeoOffice is this can't be fixed. In particular, I have a document right now in which this just happened. I can't place it here because of confidential content.

Note- This is occurring in all versions, including 3.1.4 patch 4, patch 7 and 3.2 beta patch 3.
Back to top
View user's profile Send private message
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Apr 15, 2011 6:13 am    Post subject: Reply with quote

Can you tell us how the spreadsheets were included in the Writer document? There are several ways to do this, and each behaves somewhat differently. If we know how you are doing this, we may be able to recreate this issue.

Have any of the Calc documents been moved?

I know you can't provide an actual problem document, but can you recreate the problem in a test document that could be safely shared?

If you control-click or right click on the plug icon, does a contextual menu appear? If so, what options are provided there?

Lorinda
Back to top
View user's profile Send private message
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 6:31 am    Post subject: Reply with quote

I can send you the document privately. Private message me your email address.
Back to top
View user's profile Send private message
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Apr 15, 2011 6:38 am    Post subject: Reply with quote

It's probably best to send it pluby (the developer) if that works for him. Can you answer my other questions?

Lorinda
Back to top
View user's profile Send private message
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 6:47 am    Post subject: Reply with quote

Thanks Lorinda. How do I contact him?
Back to top
View user's profile Send private message
Lorinda
Captain Mifune


Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA

PostPosted: Fri Apr 15, 2011 6:51 am    Post subject: Reply with quote

I would expect him to chime in on this thread soon. He can tell you if he's comfortable receiving a private file, and if it would be helpful.

My first guess would be that the link in the Writer files to the Calc files has been broken and needs to be reestablished.

Lorinda
Back to top
View user's profile Send private message
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 6:54 am    Post subject: Reply with quote

OK. I am comfortable sending him these files, just not posting them online. If the links are broken, this is a problem that is now starting to repeatedly crop up. I can send both the version backup just prior to the corruption and then the corrupted one which might help in deciphering what is going on.
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11856
Location: California, USA

PostPosted: Fri Apr 15, 2011 8:20 am    Post subject: Reply with quote

gbh wrote:
OK. I am comfortable sending him these files, just not posting them online. If the links are broken, this is a problem that is now starting to repeatedly crop up. I can send both the version backup just prior to the corruption and then the corrupted one which might help in deciphering what is going on.


Sorry, but I will not accept confidential documents. That puts an onerous amount of potential liability on me. All it takes is someone in your company to leak the same document and I am now on a suspect.

What I suggest you do is take an existing document that shows this problem and strip out all of the confidential material leaving only the corrupted data. Once you have done that, then attach that as a sample.

Patrick
Back to top
View user's profile Send private message Visit poster's website
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11856
Location: California, USA

PostPosted: Fri Apr 15, 2011 8:39 am    Post subject: Reply with quote

If you cannot attach a non-confidential file, I would like to investigate is where are people accessing these corrupted files?

From what you describe, corruption like this occurs when 2 people try to save to a file at the same time. NeoOffice will use native file locking if a shared volume supports it. However, if you use a shared volume like iDisk or MobileMe or some SAMBA configurations that don't support file locking, NeoOffice will not be able to protect users from writing at the same time.

Also, if some users use OpenOffice.org or LibreOffice to open the save files, those applications do not do any native file locking and will allow those users to overwrite a file that is locked by a NeoOffice user.

Can you answer two questions:

1. Tell us what type of volume that these corrupt documents are accessed from? To do that, right-click or Control-click on the volume icon on your Desktop that these documents reside in. In the popup menu that appears, select the Get Info menu. In the window that appears, copy and paste the General :: Format field's value into your reply.

2. Is anyone in your office using OpenOffice.org or LibreOffice to access the same files?

Patrick
Patrick
Back to top
View user's profile Send private message Visit poster's website
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 9:01 am    Post subject: Reply with quote

Here is a greatly scaled down version of a corrupt document with only a few of the items included.

We are not networked. Each person works on their own documents using NeoOffice and we do not share documents. I use OpenOffice sometimes, but not on the attached document which from a colleague.
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11856
Location: California, USA

PostPosted: Fri Apr 15, 2011 9:21 am    Post subject: Reply with quote

Thank you for the sample document. I unzipped the document to look for the corrupt images and what I found was that none of the embedded objects are there at all. In other words, the objects in the file are not corrupted, they are missing completely.

The bad news is that since NeoOffice uses the underlying OpenOffice.org without modification to save embedded objects, I suspect that this problem will also occur in OpenOffice.org and LibreOffice as well so switching to either of those most likely will not stop this issue from occurring.

So, the difficult part is now to find what actions trigger the OpenOffice.org code to skip saving embedded objects. Below are a list of issues that I have encountered in the OpenOffice.org code that we have tried to fix in the past. Can you tell us of any or all are applicable in your case? I am hoping that what you are seeing is a variant of a known OpenOffice.org problem and we can retool our existing fix to fix this problem:

1. Was the file open for more than a day when the file was last saved before the embedded objects disappeared?

2. What kind of embedded object was in the Writer document? A spreadsheet, chart, presentation, drawing, or math object?

I will probably have more questions after these ones. My goal is to be able to narrow down the range of OpenOffice.org code that might be causing this problem.

Patrick
Back to top
View user's profile Send private message Visit poster's website
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 9:35 am    Post subject: Reply with quote

1. No
2. Spreadsheet
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11856
Location: California, USA

PostPosted: Fri Apr 15, 2011 9:45 am    Post subject: Reply with quote

gbh wrote:
1. No
2. Spreadsheet


OK. That tells us this isn't a variant of the OpenOffice.org bug that causes saving to fail after having a document open more than 24 hours (we fixed that before NeoOffice 3.1.2).

Since I cannot reproduce this problem when I save a simple Writer document that has a very small, embedded spreadsheet, I suspect that this problem will only occur when some specific action or change occurs in the Writer document or the embedded spreadsheet. So here are a few more questions:

1. Can you or the other user remember what were the last few changes that were made to the document just before the save that failed to save the embedded objects?

2. Did NeoOffice ever crash around the time of the saving? If so, did you use NeoOffice's document recovery dialog to try to recover the document or did you open a backup copy of the document?

3. Does the embedded spreadsheet have any distinguishing characteristics that make make it different from a small spreadsheet? For example, does it have thousands of rows or does it have charts or macros?

Patrick
Back to top
View user's profile Send private message Visit poster's website
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 9:54 am    Post subject: Reply with quote

1. Not sure
2. Not that they can remember.
3. No. Pretty small spreadsheet.

Here is another guess. Some of these may have been old spreadsheets originally created in word documents that were converted to neoffice some time ago. While they have not been problematic to now, could that create corruptions that do not show up until much later?
Back to top
View user's profile Send private message
gbh
Councilperson


Joined: Jul 28, 2007
Posts: 172

PostPosted: Fri Apr 15, 2011 10:12 am    Post subject: Reply with quote

Maybe this will help. Attached is the document with a few of the spreadsheets from a backup before they would not open any more. Maybe you can see something in them.

Last edited by gbh on Fri Apr 15, 2011 10:14 am; edited 1 time in total
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Goto page 1, 2  Next
Page 1 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.03 Seconds