Apache OpenOffice (AOO) Bugzilla – Issue 69512
Spreadsheet crashes when closing a file opened as a tilde delimited file
Last modified: 2006-09-24 15:27:32 UTC
I can open and display a file consisting of tilde separated columns (test file is below). The application crashes when the file is closed even though no attempt is made to alter the data. I notice that fields consisting of a number followed by a slash (e.g. '18/') are converted to dates using the current month and year ('18/' to '09/18/06', e.g). This behavior may be an intended "smart" conversion. It seemed strange to me and I mention it in case the conversion is relevant to the failure. To recreate... 1. Start the spreadsheet 2. File | open | browse for file (in my case v.csv) 3. Specify '~' as delimiter character 4. File | close - spreadsheet will close with no apparent failure 5. Click on 'File' button and crash report appears as below Test file is ... -rw-r--r-- 1 oracle oinstall 1193 Sep 13 13:36 v.csv Content of my test file is... TEST1NAME~TEST2NAME~TEST3NAME~TEST4NAME~TEST5NAME~TEST6NAME~TEST7NAME~TEST8NAME~TEST9NAME~TEST10NAME~TEST1RESULTS~TEST2RESULTS~TEST3RESULTS~TEST4RESULTS~TEST5RESULTS~TEST6RESULTS~TEST7RESULTS~TEST8RESULTS~TEST9RESULTS~TEST10RESULTS EXT~ISO~RATING~TAN~CHANGE~~~~~~18/~15/~10~2.05~N/A~~~~~ EXT~ISO~RATING~TAN~CHANGE~~~~~~21/~17/~11~1.67~N/A~~~~~ EXT~ISO~RATING~TAN~CHANGE~~~~~~22/~18/~13~1.38~N/A~~~~~ EXT~ISO~RATING~TAN~CHANGE~~~~~~23/~22/~16~1.74~N/A~~~~~ EXT~ISO~RATING~TAN~CHANGE~~~~~~24/~20/~15~2~N/A~~~~~ EXT~ISO~RATING~TAN~CHANGE~~~~~~24/~21/~15~1.47~N/A~~~~~ EXT~ISO~RATING~TAN~WPA~SMALL~WPC~~~~25/~22/~19~1.41~ENCL~14~15~~~ EXT~ISO~RATING~TAN~~~~~~~17/~15/~13~1.56~~~~~~ EXT~ISO~RATING~TAN~~~~~~~19/~16/~11~2.66~~~~~~ EXT~ISO~RATING~TAN~~~~~~~19/~16/~14~1.9~~~~~~ EXT~ISO~RATING~TAN~~~~~~~20/~17/~13~2.04~~~~~~ EXT~ISO~RATING~TAN~~~~~~~20/~18/~13~1.15~~~~~~ EXT~ISO~RATING~TAN~~~~~~~20/~18/~14~1.63~~~~~~ EXT~ISO~RATING~TAN~~~~~~~20/~18/~14~2.22~~~~~~ EXT~ISO~RATING~TAN~~~~~~~21/~15/~11~2.06~~~~~~ EXT~ISO~RATING~TAN~~~~~~~21/~19/~17~2.06~~~~~~ EXT~ISO~RATING~TAN~~~~~~~22/~19/~16~1.56~~~~~~ EXT~ISO~RATING~TAN~~~~~~~23/~19/~15~1.64~~~~~~ EXT~ISO~RATING~TAN~~~~~~~23/~20/~16~1.7~~~~~~ Traceback is... Video Driver is probably: ati Desktop is: GNOME libgcj version is: libgcj-4.1.1-1.fc5 kernel is: Linux 2.6.17-1.2174_FC5 #1 Tue Aug 8 15:30:55 EDT 2006 i686 i686 i386 OpenOffice.org core rpm version is: openoffice.org-core-2.0.2-5.17.2 accessibility is: false ...start sestatus details ... SELinux status: disabled ...end sestatus details ... 0x9c3640: /usr/lib/openoffice.org2.0/program/libuno_sal.so.3 + 0x1e640 0x9c3e80: /usr/lib/openoffice.org2.0/program/libuno_sal.so.3 + 0x1ee80 0x56e420: + 0x420 (__kernel_sigreturn + 0x0) 0x5b5671: /lib/libc.so.6 + 0x29671 (abort + 0x101) 0x5e8a4b: /lib/libc.so.6 + 0x5ca4b 0x5eff18: /lib/libc.so.6 + 0x63f18 0x5f33ef: /lib/libc.so.6 + 0x673ef (__libc_free + 0x78) 0x2cd03a8: /lib/libdb-4.3.so + 0xc43a8 (__os_free + 0x38) 0x2cdfdca: /lib/libdb-4.3.so + 0xd3dca 0x2bf8b77: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x35b77 0x2bebae7: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x28ae7 0x2bed961: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x2a961 0x2bed9b1: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x2a9b1 0x2bdf9c3: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x1c9c3 0x2bdfafc: /usr/lib/openoffice.org2.0/program/libucpchelp1.so + 0x1cafc 0x4ae1911: /usr/lib/openoffice.org2.0/program/libucbhelper3gcc3.so + 0x1c911 0x4ae2f23: /usr/lib/openoffice.org2.0/program/libucbhelper3gcc3.so + 0x1df23 (ucb::Content::getPropertyValuesInterface(com::sun::star::uno::Sequence<rtl::OUString> const&) + 0xaf) 0x4ae2fa2: /usr/lib/openoffice.org2.0/program/libucbhelper3gcc3.so + 0x1dfa2 (ucb::Content::getPropertyValues(com::sun::star::uno::Sequence<rtl::OUString> const&) + 0x24) 0x4ae309d: /usr/lib/openoffice.org2.0/program/libucbhelper3gcc3.so + 0x1e09d (ucb::Content::getPropertyValue(rtl::OUString const&) + 0x43) 0x5803db6: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xcadb6 0x5804911: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xcb911 0x58049e1: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xcb9e1 (SfxHelp::CreateHelpURL(String const&, String const&) + 0x37) 0x5804a51: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xcba51 0x5804b38: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xcbb38 (SfxHelp::GetHelpText(String const&, Window const*) + 0x3e) 0x4da5024: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1af024 0x4da8546: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1b2546 (ToolBox::GetHelpText(unsigned short) const + 0x10) 0x4da6227: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1b0227 (ToolBox::RequestHelp(HelpEvent const&) + 0x181) 0x4dc5473: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1cf473 0x4dc6491: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1d0491 0x4dc7b99: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1d1b99 0x4dc6948: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1d0948 0x8d1820: /usr/lib/openoffice.org2.0/program/libvclplug_gtk680li.so + 0x30820 0x8cf9f2: /usr/lib/openoffice.org2.0/program/libvclplug_gtk680li.so + 0x2e9f2 0x737d58e: /usr/lib/libgtk-x11-2.0.so.0 + 0x12358e 0xf1cf8b: /usr/lib/libgobject-2.0.so.0 + 0x8f8b (g_closure_invoke + 0x12b) 0xf2de3d: /usr/lib/libgobject-2.0.so.0 + 0x19e3d 0xf2f10f: /usr/lib/libgobject-2.0.so.0 + 0x1b10f (g_signal_emit_valist + 0x68f) 0xf2f509: /usr/lib/libgobject-2.0.so.0 + 0x1b509 (g_signal_emit + 0x29) 0x7468858: /usr/lib/libgtk-x11-2.0.so.0 + 0x20e858 0x7376f63: /usr/lib/libgtk-x11-2.0.so.0 + 0x11cf63 (gtk_propagate_event + 0x183) 0x73781b7: /usr/lib/libgtk-x11-2.0.so.0 + 0x11e1b7 (gtk_main_do_event + 0x317) 0xe3a85a: /usr/lib/libgdk-x11-2.0.so.0 + 0x4085a 0xf7815d: /usr/lib/libglib-2.0.so.0 + 0x2515d (g_main_context_dispatch + 0x16d) 0xf7b3ef: /usr/lib/libglib-2.0.so.0 + 0x283ef 0xf7b955: /usr/lib/libglib-2.0.so.0 + 0x28955 (g_main_context_iteration + 0x65) 0x8b4c23: /usr/lib/openoffice.org2.0/program/libvclplug_gtk680li.so + 0x13c23 0x10281a9: /usr/lib/openoffice.org2.0/program/libvclplug_gen680li.so + 0x431a9 (X11SalInstance::Yield(unsigned char) + 0x27) 0x4c80aba: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8aaba (Application::Yield() + 0x48) 0x4c80b3e: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8ab3e (Application::Execute() + 0x26) 0x6681f73: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x24f73 (desktop::Desktop::Main() + 0x15af) 0x4c8496a: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8e96a 0x4c84a1d: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8ea1d (SVMain() + 0x2b) 0x667be53: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x1ee53 (sal_main + 0x57) 0x667be9f: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x1ee9f (main + 0x27) 0x5a1724: /lib/libc.so.6 + 0x15724 (__libc_start_main + 0xdc) 0x80484d1: /usr/lib/openoffice.org2.0/program/scalc.bin + 0x4d1
Created attachment 39128 [details] Traceback generated by OO
Using the test file provided, I changed the delimiter to tab (\t) with no affect. Changing to comma (',') remove the problem. It appears that the issue is related to the input parser. I also tried prefixing the numbers followed by slashed ("'18/", e.g.) which defeated the "smart" date conversion. This had no affect. It does not appear that "smart" conversion is related to the problem.
I replaced the tildes with commas in the first (header) line, only, then opened the file specifying the tilde as the delimiter. I expected that all the headers in the first row would be parsed as the header for column 1, only. I was surprised to see, both in the import preview and in the spreadsheet that the headers were separated at the commas, even though the tilde was specified as the separator. This, however, did not affect the failure. The app still crashed on closing.
I checked a self created file with contents from report with "2.0.2 German version WIN XP: [680m5(Build9011)]" : No Crash or similar problem, everything works fine! Special LINUX problem?
No crash with OOo 2.0.4 (680m3) on Linux (Fedora Core 5). jnavratil (jnavratil): You are using a version of OpenOffice.org that is both modified and outdated. Could you please test with an up-to-date, official version from http://download.openoffice.org ? Version 2.0.3 has been out for some months, and version 2.0.4 is due soon. >5. Click on 'File' button and crash report appears as below By button, I assume you meant menu?
Original problem appeared in FC5 system built several months ago and kept up to date via Smart and standard repositories. I rebuilt another FC5 system and updated it to latest distributed RPMs (which includes OO 2.0.2) and could NOT recreate the problem. It is clearly a problem with my configuration and NOT with OO. Sigh! I had hoped my days of rebuilding systems when they got "stale" were behind my when I abandoned Microsoft.
and closed
actually this happened because on FC-5 db4 was upgraded, showed that there was a bug in OOo, and downgraded again
mark as dup of 69213 *** This issue has been marked as a duplicate of 69213 ***
close as dup