I also tried opening the document on OpenOfficeOrg 1.0.1 on Win2K. 
Same problem, but it did give me a more descriptive error message:
Error loading document file:///C:/temp/tk.sxc:
Read-Error.
Format error discovered in the file in sub-document content.xml at
2,108386(row,col).

So, I guess the real bug here is that it saved it in a way that it
cannot reload it.

So, I opened the doc with nedit, and there are 2 rows.  Line feeds
below are mine.
Row1: <?xml version="1.0" encoding="UTF-8"?>
Row2: <!DOCTYPE office:document-content PUBLIC "-//OpenOffice.org//DTD
OfficeDocument 1.0//EN" "office.dtd">
<office:document-content 
... lots of xmlns settings ...
office:class="spreadsheet" office:version="1.0">
... lots of text ...
</office:document-content>

So, here's the real kicker.  There are only 103319 bytes in line2. So,
where does the error message get 108386?

This does look funny, near the end of line 2.  Could it be the problem? :
<table:named-expressions>
<table:named-expression table:name="BuiltIn_Print_Area"
table:base-cell-address="$&apos;March 1 to 15&apos;.$A$1"
table:expression="$#ref!.$f$1:$#ref!.[.$W$41]"/>
</table:named-expressions>

That was the problem!  

The last time I edited this document, I had rearranged several items
on it.  Apparently, that blew the print area, HOWEVER, it never
complained when I saved it.  Then, it couldn't load what it had saved.
 This is definitely a bug.

I removed all of the following, and it loaded fine!
<table:named-expressions>
<table:named-expression table:name="BuiltIn_Print_Area"
table:base-cell-address="$&apos;March 1 to 15&apos;.$A$1"
table:expression="$#ref!.$f$1:$#ref!.[.$W$41]"/>
</table:named-expressions>

Hi,

could you please attach the file in question ?

I think it's an double to Issue 11622 but to confirm this, I need to
check it.

Thanks

Frank

Created attachment 5023 [details]
the file in question

Hi,

thanks for the file.

But you're wrong. The fault is not the named expression in the
content.xml, it's the broken stored macro section. As you can see, the
XML files Module1.xml and script-lb.xml are empty. And this is the
bug. To track this one down, we need as much infos as possible.

Could you tell us exactly what you've done before you've encountered
the opening error the first time, have you opened more than one
document the last time you've saved the document and if what type of
document ? 

After saving the document the last time have you got an Unrecoverable
Error ?

Do you had an unrecoverable Error before storing the document, I mean
was this document recovered before you saved it ?

It would be nice to get as much Information about the document itself
and your working environment as possible.

Thanks for your cooperation.

Frank

Hi, 

to make it clear, the Module1 and the lb-script files are not empty at
all but contain NULL bytes.

Frank

Yikes.  Sorry.  I open and close files all day.  The file in question
is the file I use to keep track of my time for billing projects.  I
keep it open and use it all day.  However, I did NOT have any errors
on saving the file.  I only got an error when I tried to open it the
next day. 

I have only opened sxc and word doc files recently.

What other information would you like?

Hhhmmm, Andreas, Sascha. Do you need something special about this ?

Frank

Hi,

for me would it be interesting what macros were in the file. I think the problem 
hast something to do with the macros which are now gone. Perhaps we can reproduce it if 
we know the macros.

Sascha

Created attachment 5055 [details]
running version of file in question with macros intact

Hi all,

I've compared the size of the module1, script-lb and script-lc of the
documents and found that they are from the same size. Only the content
is different. Null bytes in the broken one and normal text in the good
one.

Mathias, is it possible that your construction site is involved, whta
do you think about it ?

Frank

*** Issue 11622 has been marked as a duplicate of this issue. ***

Hi Andreas,

please contact Sascha and Mathias for discussion there to search.

This is Prio 2 and should go into OOo1.0.3 !

Thanks

Frank

I don't think that I'm involved here.
IMHO there are two bugs: we shouldn't crash when we load such
corrupted documents (->AB). The other one (don't let this corruption
happen again) is much harder to attack, because nobody knows *how*
that happened.

AB->FST: I agree with Mathias and as this issue already covers the 
complete problem I propose, that you submit a new task to me for the
"Don't crash" aspect and try to reproduce the corruption for this
issue. Until the corruption itself is not reproducable we don't even
know whose bug this is and noone has a chance to fix it.

For now we can't reproduce the loss of the macros. Therefore I set the
Target Milestone to OOo Later.

I will observe this and try to reproduce it.

Frank

Maybe a stack helps.

Program received signal SIGABRT, Aborted.
0x40ba2df1 in kill () from /lib/libc.so.6
(gdb) where
#0  0x40ba2df1 in kill () from /lib/libc.so.6
#1  0x40a0e06d in pthread_kill () from /lib/libpthread.so.0
#2  0x40a0e5eb in raise () from /lib/libpthread.so.0
#3  0x40ba44d9 in abort () from /lib/libc.so.6
#4  0x405980e5 in osl_releaseVolumeDeviceHandle () from
/export/home/users/qscalc/staroffice6.0/program/libsal.so.3
#5  0x40598219 in osl_releaseVolumeDeviceHandle () from
/export/home/users/qscalc/staroffice6.0/program/libsal.so.3
#6  0x40a0e12b in pthread_sighandler () from /lib/libpthread.so.0
#7  <signal handler called>
#8  0x40ba2df1 in kill () from /lib/libc.so.6
#9  0x40a0e06d in pthread_kill () from /lib/libpthread.so.0
#10 0x40a0e5eb in raise () from /lib/libpthread.so.0
#11 0x40ba44d9 in abort () from /lib/libc.so.6
#12 0x40b47dd5 in __cxxabiv1::__terminate(void (*)()) ()
   from /export/home/users/qscalc/staroffice6.0/program/libstdc++.so.3
#13 0x40b47e10 in __cxxabiv1::__unexpected(void (*)()) ()
   from /export/home/users/qscalc/staroffice6.0/program/libstdc++.so.3
#14 0x40b47faa in __cxa_rethrow () from
/export/home/users/qscalc/staroffice6.0/program/libstdc++.so.3
#15 0x41d4307e in component_getDescriptionFunc () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#16 0x42011c52 in
SfxLibraryContainer_Impl::implLoadLibraryIndexFile(SfxLibrary_Impl*,
xmlscript::LibDescriptor&, SotStorageRef, rtl::OUString const&) ()
from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#17 0x4200ef9b in SfxLibraryContainer_Impl::init(rtl::OUString const&,
rtl::OUString const&, rtl::OUString const&, rtl::OUString const&,
rtl::OUString const&, SotStorageRef) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#18 0x420190c9 in SfxScriptLibraryContainer::init(rtl::OUString
const&, rtl::OUString const&, BasicManager*, SotStorage*) () from
/export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#19 0x420195cd in
SfxScriptLibraryContainer::SfxScriptLibraryContainer(rtl::OUString
const&, BasicManager*, SotStorage*) () from
/export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
---Type <return> to continue, or q <return> to quit---
#20 0x42070e1a in SfxObjectShell::InitBasicManager_Impl(SvStorage*,
String const*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#21 0x42070643 in SfxObjectShell::HasBasic() const ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#22 0x420705af in SfxObjectShell::GetBasicManager() const ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#23 0x420707cc in SfxObjectShell::GetBasic() const ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#24 0x459888f3 in ?? ()
#25 0x45989ff0 in ?? ()
#26 0x4598a34f in ?? ()
#27 0x459db1d3 in ?? ()
#28 0x45857f51 in ?? ()
#29 0x4585839f in ?? ()
#30 0x45af2f12 in ?? ()
#31 0x43686975 in SvXMLImport::endElement(rtl::OUString const&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libxo641li.so
#32 0x41d44acc in component_getDescriptionFunc () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#33 0x41d4c4a3 in component_getFactory () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#34 0x41d4b9ad in component_getFactory () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#35 0x41d4b68c in component_getFactory () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#36 0x41d4b639 in component_getFactory () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#37 0x41d43fbf in component_getDescriptionFunc () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#38 0x41d42ff9 in component_getDescriptionFunc () from
/export/home/users/qscalc/staroffice6.0/program/libsax.so
#39 0x45abd56d in ?? ()
#40 0x45abeaad in ?? ()
#41 0x4564eae8 in ?? ()
---Type <return> to continue, or q <return> to quit---
#42 0x4564f0b4 in ?? ()
#43 0x45b57703 in ?? ()
#44 0x42082206 in SfxObjectShell::LoadOwnFormat(SfxMedium&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#45 0x42079519 in SfxObjectShell::DoLoad(SfxMedium*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#46 0x42004df4 in LoadEnvironment_Impl::Load(SfxObjectFactory const*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#47 0x420067aa in LoadEnvironment_Impl::LoadDataAvailable() ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#48 0x420066f5 in LoadEnvironment_Impl::LoadDataAvailable() ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#49 0x420040c3 in LoadEnvironment_Impl::Start() () from
/export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#50 0x420c845f in
SfxFrameLoader::load(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>
const&, com::sun::star::uno::Reference<com::sun::star::frame::XFrame>
const&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#51 0x43cff3a0 in
framework::BaseDispatcher::implts_loadIt(com::sun::star::util::URL
const&,
com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>&,
rtl::OUString const&,
com::sun::star::uno::Reference<com::sun::star::frame::XFrame> const&,
com::sun::star::uno::Any const&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libfwk641li.so
#52 0x43d01407 in
framework::BlankDispatcher::dispatch(com::sun::star::util::URL const&,
com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>
const&) () from
/export/home/users/qscalc/staroffice6.0/program/libfwk641li.so
#53 0x41fd02dd in SfxApplication::OpenDocExec_Impl(SfxRequest&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#54 0x41fd364d in SfxStubSfxApplicationOpenDocExec_Impl(SfxShell*,
SfxRequest&) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#55 0x4210dee0 in SfxDispatcher::Call_Impl(SfxShell&, SfxSlot const&,
SfxRequest&, unsigned char) ()
---Type <return> to continue, or q <return> to quit---
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#56 0x4211069a in SfxDispatcher::PostMsgHandler(SfxRequest*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#57 0x421105cd in SfxDispatcher::LinkStubPostMsgHandler(void*, void*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#58 0x4212d33f in SfxHintPoster::Event(SfxHint*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#59 0x4212d2e3 in SfxHintPoster::LinkStubDoEvent_Impl(void*, void*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libsfx641li.so
#60 0x402f36b2 in ImplHandleClose(Window*) () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#61 0x402f3e09 in ImplWindowFrameProc(void*, SalFrame*, unsigned
short, void const*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#62 0x40349223 in
SalFrameData::HandleClientMessage(XClientMessageEvent*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#63 0x4034991a in SalFrameData::Dispatch(_XEvent*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#64 0x4036c7f1 in SalDisplay::Dispatch(_XEvent*) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#65 0x4036c54f in SalDisplay::Yield(unsigned char) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#66 0x40368365 in SalDisplay::~SalDisplay() () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#67 0x40366dc9 in SalXLib::Yield(unsigned char) () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#68 0x4036f77c in SalInstance::Yield(unsigned char) ()
   from /export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#69 0x401ffead in Application::Yield() () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#70 0x401ffde5 in Application::Execute() () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#71 0x080623a7 in Desktop::Main() ()
---Type <return> to continue, or q <return> to quit---
#72 0x402024d7 in SVMain() () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#73 0x40365eda in main () from
/export/home/users/qscalc/staroffice6.0/program/libvcl641li.so
#74 0x40b914a2 in __libc_start_main () from /lib/libc.so.6

*** Issue 13786 has been marked as a duplicate of this issue. ***

*** Issue 14133 has been marked as a duplicate of this issue. ***

*** Issue 14133 has been marked as a duplicate of this issue. ***

nothing for ms_interop., so no blocking of 21783
no crash anymore so no blocking of 21786

As we are now at OOo1.1.2 and after chnaging the saxwriter by SAB, this problem
seems to be solved. I never got an Issue like this one after changing this, Also
I was never able to reproduce it.

So I close this one as fixed. If you can still reproduce the elimination of
macro code by just saving a document, feel free to reopen this Issue. In case
give us as much information about how to reproduce as possible.

Frank

closed fixed

*** Issue 31112 has been marked as a duplicate of this issue. ***

.