Download it now!
Bug 68752 - Error while "Save as"/Export as XML using "LibreOffice Calc" if there are 3 empty rows
Summary: Error while "Save as"/Export as XML using "LibreOffice Calc" if there are 3 e...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 121496 (view as bug list)
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
 
Reported: 2013-08-30 13:06 UTC by arnosn
Modified: 2019-12-02 10:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description arnosn 2013-08-30 13:06:38 UTC
The error occurs in LibreOffice 3.6 and also 4.X
I try to write in readable english ;-)
aditional system information
Windows 7 64bit
LibreOffice 3.6.X or 4.X

Its an rpeatable effor Problem
Steps

First problem:
1) save empty "LibreOffice Calc" document as XML 
  (this happens as well as it is saved in odf file befor changing in XML)
2) write some content in first column/row 
  (could also be any other column/row)
3) save(works)
4) write in row 5
  (3 emty lines under the first row)
5) save -> error message: "error during save filr:"name of file" file could not  be written"

Everytime if there are 3 empty rows or mor under a row with content an error occurs

Second problem:
1) same as above
2) writing one or more entries in the column
3) click with the right mouse button at the column letter (in this case column A)
4) change format of the column activate automatic line break for the whole
   column A  
5) save file again and close LibreOffice
6) try to open the XML file whith LibreOffice
7) LibreOffice try to start/load about 1 minute and display error message: 
   "error during read or writ. general I/O error"
8) the file could not be loadet whith LibreOffice

If i try to activate the automatic line break in an predefined space like column/row 1 to row 50 it works
But if i load the file again the automatic line break is disappeared
Comment 1 Mikko Ahlroth 2013-08-30 13:11:36 UTC Comment hidden (obsolete)
Comment 2 arnosn 2013-08-30 13:13:21 UTC
(In reply to comment #1)
> What do you mean with "Save as XML"? Do you mean Flat ODS (.fods), Office
> Open XML (.xlsx), MS Office 2003 XML (.xml) or something else?

oh sorry it is "MS Office 2003 XML (.xml)"
Comment 3 Mikko Ahlroth 2013-08-30 13:21:54 UTC
Confirmed on Windows 7 x64, LO version 3.6.3.2 (Build ID: 58f22d5). Following the 5 steps results in file being unsaveable. If the content below the first row is removed, the file can be saved again.
Comment 4 arnosn 2013-08-30 13:38:17 UTC
> Confirmed on Windows 7 x64, LO version 3.6.3.2 (Build ID: 58f22d5).
> Following the 5 steps results in file being unsaveable. If the content below
> the first row is removed, the file can be saved again.

yes of course i forgot to mention it i tried this also one of the tests i describe below. 
How to fix it in the case that i want to save the document with 3 or more empty rows?

addendum:
it appears only if 3 rows completely empty also with 2 or more column
for example is column 1 has entries from row 1-10 and the column 2 from 1-3 and from row 7-10 no error occurred(In reply to comment #3)
Comment 5 Joel Madero 2015-05-02 15:41:39 UTC Comment hidden (obsolete)
Comment 6 Mikko Ahlroth 2015-05-02 20:50:35 UTC
Can still confirm on LO 4.4.2 on OS X 10.10.3 by using the original steps to reproduce. It has changed from being a save error to a total crash. Possibly relevant parts from crash dump:

Exception Type:        EXC_BAD_ACCESS (SIGBUS)
Exception Codes:       KERN_PROTECTION_FAILURE at 0x000000011671ffc8

Thread 15 Crashed:
0   libsystem_malloc.dylib        	0x00007fff829e9959 _nano_malloc_check_clear + 111
1   libsystem_malloc.dylib        	0x00007fff829e98cc nano_malloc + 35
2   libsystem_malloc.dylib        	0x00007fff829e9877 malloc_zone_malloc + 71
3   libsystem_malloc.dylib        	0x00007fff829e8395 malloc + 42
4   libxml2.2.dylib               	0x00007fff882b0173 xmlXPathObjectCopy + 42
5   libxml2.2.dylib               	0x00007fff882b8068 xmlXPathCompOpEval + 3087
6   libxml2.2.dylib               	0x00007fff882b7dd2 xmlXPathCompOpEval + 2425
7   libxml2.2.dylib               	0x00007fff882b68da xmlXPathRunEval + 328
8   libxml2.2.dylib               	0x00007fff882b65f0 xmlXPathCompiledEvalInternal + 405
9   libxml2.2.dylib               	0x00007fff882b6451 xmlXPathCompiledEval + 27
10  libxslt.1.dylib               	0x00007fff882f821d xsltCopyOf + 230
11  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
12  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
13  libxslt.1.dylib               	0x00007fff882f5322 xsltApplyXSLTTemplate + 1414
14  libxslt.1.dylib               	0x00007fff882f89a7 xsltCallTemplate + 390
15  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
16  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
17  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
18  libxslt.1.dylib               	0x00007fff882f5322 xsltApplyXSLTTemplate + 1414
19  libxslt.1.dylib               	0x00007fff882f89a7 xsltCallTemplate + 390
20  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
21  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
22  libxslt.1.dylib               	0x00007fff882f58ad xsltApplySequenceConstructor + 541
23  libxslt.1.dylib               	0x00007fff882f5322 xsltApplyXSLTTemplate + 1414
24  libxslt.1.dylib               	0x00007fff882f89a7 xsltCallTemplate + 390

...

The last 5 lines are repeated very many times. Possibly an infinite recursion and stack overflow?
Comment 7 QA Administrators 2016-09-20 09:37:29 UTC Comment hidden (obsolete)
Comment 8 Mikko Ahlroth 2016-09-20 09:51:48 UTC
Still able to reproduc on LO 5.2.1 on OS X 10.11.5. Crashes LO completely.

Relevant parts from error report:

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_CRASH (SIGILL)
Exception Codes:       0x0000000000000000, 0x0000000000000000
Exception Note:        EXC_CORPSE_NOTIFY

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib        	0x00007fff9169ddb6 __psynch_cvwait + 10
1   libsystem_pthread.dylib       	0x00007fff8847e728 _pthread_cond_wait + 767
2   libuno_sal.dylib.3            	0x000000010b225da1 osl_waitCondition + 193
3   libxsltfilterlo.dylib         	0x000000012efdb8d5 XSLT::XSLTFilter::endDocument() + 37
4   libxolo.dylib                 	0x000000010fdd941f SvXMLExport::exportDoc(xmloff::token::XMLTokenEnum) + 3007
5   libsclo.dylib                 	0x000000012959a498 ScXMLExport::exportDoc(xmloff::token::XMLTokenEnum) + 1032
6   libxolo.dylib                 	0x000000010fdd53d8 SvXMLExport::filter(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) + 472
7   libsclo.dylib                 	0x000000012959a701 ScXMLExport::filter(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) + 65
8   libxmlfalo.dylib              	0x000000012aaac6e3 XmlFilterAdaptor::exportImpl(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) + 3651
9   libxmlfalo.dylib              	0x000000012aaacbb3 non-virtual thunk to XmlFilterAdaptor::filter(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) + 19
10  libsfxlo.dylib                	0x000000010be2441f SfxObjectShell::ExportTo(SfxMedium&) + 3695
11  libsfxlo.dylib                	0x000000010be1f522 SfxObjectShell::SaveTo_Impl(SfxMedium&, SfxItemSet const*) + 4226
12  libsfxlo.dylib                	0x000000010be2842b SfxObjectShell::DoSave_Impl(SfxItemSet const*) + 939
13  libsfxlo.dylib                	0x000000010be288aa SfxObjectShell::Save_Impl(SfxItemSet const*) + 442
14  libsfxlo.dylib                	0x000000010be4a486 SfxBaseModel::storeSelf(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) + 1846
15  libsfxlo.dylib                	0x000000010bdf99a1 SfxStoringHelper::GUIStoreModel(com::sun::star::uno::Reference<com::sun::star::frame::XModel> const&, rtl::OUString const&, com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>&, bool, rtl::OUString const&, SignatureState) + 1473
16  libsfxlo.dylib                	0x000000010be10306 SfxObjectShell::ExecFile_Impl(SfxRequest&) + 3334
17  libsfxlo.dylib                	0x000000010bce55d5 SfxShell::ExecuteSlot(SfxRequest&, SfxInterface const*) + 101
18  libsclo.dylib                 	0x00000001299e7a87 ScTabViewShell::ExecuteSave(SfxRequest&) + 119
19  libsfxlo.dylib                	0x000000010bcc61dc SfxDispatcher::Call_Impl(SfxShell&, SfxSlot const&, SfxRequest&, bool) + 796
20  libsfxlo.dylib                	0x000000010bcc8b4e SfxDispatcher::PostMsgHandler(SfxRequest*) + 318
21  libsfxlo.dylib                	0x000000010be800a8 SfxHintPoster::LinkStubDoEvent_Impl(void*, void*) + 24
22  libvcllo.dylib                	0x000000010da373f8 ImplWindowFrameProc(vcl::Window*, SalEvent, void const*) + 1736
23  libvcllo.dylib                	0x000000010dcb4c90 AquaSalInstance::DoYield(bool, bool, unsigned long) + 400
24  libvcllo.dylib                	0x000000010dc3634e Application::Yield() + 78
25  libvcllo.dylib                	0x000000010dc362e8 Application::Execute() + 296
26  libsofficeapp.dylib           	0x000000010b2802a0 desktop::Desktop::Main() + 7152
27  libvcllo.dylib                	0x000000010dc3a4af ImplSVMain() + 79
28  libvcllo.dylib                	0x000000010dcb48d4 AquaSalInstance::handleAppDefinedEvent(NSEvent*) + 84
29  libvcllo.dylib                	0x000000010dd081d4 -[VCL_NSApplication sendEvent:] + 324
30  com.apple.AppKit              	0x00007fff87539df2 -[NSApplication run] + 796
31  com.apple.AppKit              	0x00007fff87503368 NSApplicationMain + 1176
32  libvcllo.dylib                	0x000000010dcb3bad ImplSVMainHook(int*) + 397
33  libvcllo.dylib                	0x000000010dc3b13a SVMain() + 26
34  libsofficeapp.dylib           	0x000000010b2aae8b soffice_main + 219
35  org.libreoffice.script        	0x000000010b1f8f20 main + 16
36  libdyld.dylib                 	0x00007fff950e75ad start + 1
Comment 9 Xisco Faulí 2017-09-29 08:49:25 UTC Comment hidden (obsolete)
Comment 10 Timur 2018-11-01 17:54:45 UTC Comment hidden (obsolete)
Comment 11 Timur 2018-11-21 14:21:18 UTC
*** Bug 121496 has been marked as a duplicate of this bug. ***
Comment 12 Timur 2018-11-21 14:24:29 UTC
Likely duplicate attachment 146725 [details] from Bug 121496.
Comment 13 QA Administrators 2019-11-23 03:43:54 UTC Comment hidden (obsolete)
Comment 14 Timur 2019-12-02 10:28:53 UTC
Repro 6.5+. It's not Save anymore, now it's Export, but error remains.