You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/07/03 03:01:26 UTC
[Issue 127464] New: The file '' could not be repaired and
therefore can not be opened
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Issue ID: 127464
Issue Type: DEFECT
Summary: The file '<file name>' could not be repaired and
therefore can not be opened
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Linux 64-bit
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: jari.kosonen@rayence.com
Target Milestone: ---
Created attachment 86167
--> https://bz.apache.org/ooo/attachment.cgi?id=86167&action=edit
can not save the document
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #5 from Peter <le...@gmail.com> ---
Also, also please keep in mind that we have here not the focus to fix your
issue. If we can confirm it is a general issue and if we can locate it we will
improve the codebase. Which will then be released.
Sometimes it is better to check with user Mailing List or user Forums. To see
if there is a workaround.
We would be still happy receive some information on the issue but more from the
overall improvement perspective.
Hope you understand.
All the best
Peter
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #22 from jari.kosonen@rayence.com <ja...@rayence.com> ---
The machine has the maximum memory, that is 64Gb for the Intel(R) Xeon(R) CPU
E5-1660 v2 @ 3.70GHz:
[jari@vatcad3 IMG]$ free
total used free shared buffers cached
Mem: 65900004 14911552 50988452 11280 168496 11130816
-/+ buffers/cache: 3612240 62287764
Swap: 33021948 9828 33012120
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #8 from Peter <le...@gmail.com> ---
I agree 3 GB is suspicious.
Please describe from where you load data?
I am traveling. Can have a look tonight.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #19 from jari.kosonen@rayence.com <ja...@rayence.com> ---
It is possible that the macro has some errors, since I did not find maybe good
reference to make such macro.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #1 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Created attachment 86168
--> https://bz.apache.org/ooo/attachment.cgi?id=86168&action=edit
can not open the document
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #23 from Regina Henschel <rb...@t-online.de> ---
The parts with oBitmaps look suspicious. An object
("com.sun.star.drawing.BitmapTable") is used for background filling. But it
looks as if you only want to add an image to the draw page of the sheet, not to
use this image as background. Try to comment out statements, which use
oBitmaps. You might need to adapt pathes, from where the images are loaded by
the macro.
As a general rule for huge images, only work with linked images and do not
manipulate the images in OpenOffice but use a dedicated application for that.
For example, do not rotate an image in OpenOffice, but rotate it outside and
then insert the rotated image into OpenOffice as link.
[Work on a copy of the file!] If you need to remove the images from an existing
file, then you can unpack the file. It is actually a zip-container. Then open
the sub-document styles.xml in an editor and remove all the <draw:fill-image
... lines.
Open the subfolder Pictures and remove all pictures. After that mark all the
content and pack it.
You might want to use the scripts (Linux or Cygwin) posted in
https://lists.oasis-open.org/archives/office/201706/msg00001.html to unpack and
pack it.
Using linked images needs to load at least those images, which are currently
visible. Have you already adapt the settings in Tools > Options > OpenOffice,
item Memory, to your huge amount of images and to the huge size of the images?
Do you need all of these images at the same time? Perhaps you can divide the
problem in smaller tasks?
For to learn Basic use the book from Andrew Pitonyak.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #18 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I don't know what means:
"The problem is, that the pictures are used for filling. After use, the
fill-style definition like <draw:fill-image
draw:name="WN14B736_5f_2_5f_X30Y30_5f_2"
draw:display-name="WN14B736_2_X30Y30_2"
xlink:href="Pictures/1000000000000654000008B6D97E5E90.bmp" xlink:type="simple"
xlink:show="embed" xlink:actuate="onLoad"/>
stays in the subdocument styles.xml."
Could you inform to me how to remove it from there?
Even if I deleted the 2nd sheet the file size did not reduce, that is the
visible sheet seemed empty, but almost all the data remained in the file.
This document is to show the pictures. So it is not possible to enter the
results only in this case. The results are then in another sheet already. So
that works, but I can not get the image summary.
Pictures are inserted there with macro as:
oLinked=Doc.createInstance("com.sun.star.drawing.GraphicObjectShape")
url$=sPath+"/"+sFile
surl$=sDie+"_"+Trim(Str(fi-43))
If oBitmaps.hasByName(surl) Then
oBitmaps.removeByName(surl)
End If
aPos.X=(Sheet.getCellByPosition((Nx+2)*i+pX+1,(Ny+3)*j+pY+6).Position.X)+rX
aPos.Y=(Sheet.getCellByPosition((Nx+2)*i+pX+1,(Ny+3)*j+pY+6).Position.Y)+rY
oBitmaps.insertByName(surl,url)
oLinked.GraphicURL=converttourl(url$)
rem oLinked.Anchor=Sheet.getCellByPosition((Nx+2)*i+pX+1,(Ny+3)*j+pY+6)
c=oDrawPage.count
oLinked.RotateAngle=rot
oLinked.ShearAngle=0
If mirrorX="Y" Then
oLinked.IsMirrored=True
Else
oLinked.IsMirrored=False
End If
oLinked.Position=aPos
oLinked.Size=aSize
oLinked.Name=sDie
oDrawPage.add(oLinked)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #7 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I try manage, even it does not work...
The size of >3Gb is little bit suspicious.
I think it is adding more data into the sheet everytime I used it.
Even I delete the Sheet2 and it looks clean, the data is probably
still in the ods-file somewhere.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #24 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I'll try to check how to insert the image by the macro as a link instead of
embedded image. But it seems hard to be found.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #29 from jari.kosonen@rayence.com <ja...@rayence.com> ---
It works now, after removed the oBitmap definitions. I think that was done to
insert the images as embedded. But I think the method is wrong way to try
insert embedded image. I try further check about the issue on the Forum. Thanks
for the support given.
oLinked.Position=aPos
oLinked.Size=aSize
oLinked.Name=sDie
oLinked.AsLink=False
oDrawPage.add(oLinked)
The ".AsLink" does not work in this context. I try further check with the
Forum.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |knmc@apache.org
Keywords| |needhelp
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #14 from Keith N. McKenna <kn...@apache.org> ---
I was able to download the ods file from the google drive link and can confirm
that AOO 4.1.3 reports it as corrupted and tries and fails to repair it. The
contents.xml file shows a lot of what appear to be graphics frame entries, but
it will take someone with more knowledge than I decipher the root cause.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #25 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Maybe at the moment I could not find the right book to add the images as a
link. I have just the "OpenOffice.org" macros explained, and that book is not
too good to explain how to insert the bitmaps into excel sheet.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #20 from jari.kosonen@rayence.com <ja...@rayence.com> ---
How to generate the contents.xml -file?
Could you upload it here?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #26 from jari.kosonen@rayence.com <ja...@rayence.com> ---
It seems that the images are not embedded into Sheet2, but into the document
and deleting Sheet2 does not remove the images from the document:
https://drive.google.com/open?id=0BwII5b2Vli_RMDQ5ekZISllzeUk
This is maybe because the images are bitmaps (that you said are the background
images) that are attached to the document itself instead of Sheet2.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #3 from jari.kosonen@rayence.com <ja...@rayence.com> ---
The file is possibly too large to be uploaded there... I might try to upload it
now.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leginee@gmail.com
--- Comment #4 from Peter <le...@gmail.com> ---
You Cam Upload the Document to File Share Services like Dropbox, google Docs
ans provide a Link.
All the best
peter
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOT_AN_ISSUE
Status|CONFIRMED |RESOLVED
--- Comment #30 from Peter <le...@gmail.com> ---
You are welcome. I see this as resolved.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #15 from Keith N. McKenna <kn...@apache.org> ---
(In reply to Keith N. McKenna from comment #14)
> I was able to download the ods file from the google drive link and can
> confirm that AOO 4.1.3 reports it as corrupted and tries and fails to repair
> it. The contents.xml file shows a lot of what appear to be graphics frame
> entries, but it will take someone with more knowledge than I decipher the
> root cause.
I can confirm this with Windows 10 and AOO 4.1.3
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #27 from Peter <le...@gmail.com> ---
We get OT here. For macro coding help please ask on Forum or on Mailing List.
There are more people that can help.
This is only the development team looking here, and we are quite small Team.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #10 from Peter <le...@gmail.com> ---
It did not work.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #13 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Can you download the file from the google drive?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #21 from Peter <le...@gmail.com> ---
Regina says you have to much pictures per document. We currently can not hold
that much pictures.
How much memory do you have in your machine?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #2 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I think the Sheet2 of this document that has some images can not save properly
and is possibly accumulating the images from previous save, like if it can not
clear the sheet data completely. Even the Sheet2 is deleted from the ods-file
it still has very large size, like the images still would be in the ods-file.
[jari@vatcad3 IMG]$ ls -la *.ods
-rw-r--r-- 1 jari TEAM1 3566162876 Jul 3 10:29
SORT_IMAGES_SUDS150_WN174958_Jul2017.ods
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #12 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Please try the latest google-drive document download.
Due to large size it may have problems.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #16 from Regina Henschel <rb...@t-online.de> ---
The problem is, that the pictures are used for filling. After use, the
fill-style definition like
<draw:fill-image draw:name="WN14B736_5f_2_5f_X30Y30_5f_2"
draw:display-name="WN14B736_2_X30Y30_2"
xlink:href="Pictures/1000000000000654000008B6D97E5E90.bmp" xlink:type="simple"
xlink:show="embed" xlink:actuate="onLoad"/>
stays in the subdocument styles.xml.
On load AOO tries to open all those files, which are currently count 625. Each
of them is 3.613.678 Bytes, approx 3,44MB. That results in 2150MB approx 2,1GB.
At least for my PC that's far too much and I get a "Bad allocation" error
because of out of RAM.
The message "cannot be repaired" is misleading.
Whatever you want to do, that's not the way to go.
You likely need to modify your macros. I don't know, what your macros will do.
But the pictures look like you do not examine them manually. Do you have
considered not to include the pictures into the sheet, but only enter the
results into the sheet?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #6 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I'll check if I can add permissions for you.
It might had sent the invitation already.
https://vatechcorp-my.sharepoint.com/personal/jari_kosonen_rayence_com/_layouts/15/guestaccess.aspx?docid=0c518c2daaeb144de97dc7ae3c0bf0af0&authkey=AQkcbGRBklF-RSt9ACB6uWU&expiration=2017-07-18T07%3a23%3a46.000Z
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #17 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Created attachment 86171
--> https://bz.apache.org/ooo/attachment.cgi?id=86171&action=edit
Sample how the images are used (with blank images)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #9 from jari.kosonen@rayence.com <ja...@rayence.com> ---
Can you receive the file? I am not 100% sure if the sharing works.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #11 from jari.kosonen@rayence.com <ja...@rayence.com> ---
https://drive.google.com/open?id=0BwII5b2Vli_RUW9tcVFkOEdvSEU
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127464] The file '' could not be repaired and
therefore can not be opened
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127464
--- Comment #28 from jari.kosonen@rayence.com <ja...@rayence.com> ---
I think the problems is that it accumulate the same file again and again with
different internal name. It can not check if the image is there already. But
maybe it should be checked by the macro instead of the calc.
--
You are receiving this mail because:
You are the assignee for the issue.