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

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Calc crash
Calc crash
 
   NeoOffice Forum Index -> NeoOffice Beta Releases
View previous topic :: View next topic  
Author Message
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Mon Jan 25, 2010 7:14 am    Post subject:

Well, the catalog error came afterwards, when it was repairing. After it completed, it did another run, and that turned out clean Smile.

But in addition to the little bug regarding document recovery, I have a similar crash occurring in a different part of the spreadsheet. Oddly enough, it did not happen on the first time I went through the spreadsheet, only when I opened it a second time. Then when I restarted NeoOffice, it crashed in the same way again..

I am attaching the crash log, and I am pasting the relevant parts of the console log.

Code:
25-01-10 14:57:30   [0x0-0x1b51b5].org.neooffice.NeoOffice[13828]   objc[13828]: Class AWTFont is implemented in both /Applications/NeoOffice.app/Contents/MacOS/../basis-link/program/libvcljava2.dylib and /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Libraries/libawt.jnilib. One of the two will be used. Which one is undefined.
25-01-10 14:57:40   [0x0-0x1b51b5].org.neooffice.NeoOffice[13828]   OOO_CALC_USE_ENGLISH_FORMULAS=1 => UI uses English function names and separators in formulas.
25-01-10 14:57:42   soffice.bin[13828]   JavaNativeFoundation: GetGlobalVM: JNI_GetCreatedJavaVMs() failed to get any VM.
25-01-10 14:58:23   soffice.bin[13828]   Application will become active - Using remote controls
25-01-10 14:58:59   soffice.bin[13828]   Application will resign active - Releasing remote controls
25-01-10 15:04:20   soffice.bin[13828]   Application will become active - Using remote controls

25-01-10 15:06:15   [0x0-0x1bb1bb].org.neooffice.NeoOffice[13871]   objc[13871]: Class AWTFont is implemented in both /Applications/NeoOffice.app/Contents/MacOS/../basis-link/program/libvcljava2.dylib and /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Libraries/libawt.jnilib. One of the two will be used. Which one is undefined.
25-01-10 15:06:40   [0x0-0x1bb1bb].org.neooffice.NeoOffice[13871]   OOO_CALC_USE_ENGLISH_FORMULAS=1 => UI uses English function names and separators in formulas.
25-01-10 15:06:41   soffice.bin[13871]   JavaNativeFoundation: GetGlobalVM: JNI_GetCreatedJavaVMs() failed to get any VM.
25-01-10 15:07:06   soffice.bin[13871]   Application will become active - Using remote controls
25-01-10 15:07:23   [0x0-0x1bb1bb].org.neooffice.NeoOffice[13871]   terminate called after throwing an instance of 'std::bad_alloc'
25-01-10 15:07:23   [0x0-0x1bb1bb].org.neooffice.NeoOffice[13871]     what():  std::bad_alloc
25-01-10 15:07:29   com.apple.launchd.peruser.501[220]   ([0x0-0x1bb1bb].org.neooffice.NeoOffice[13871]) Job appears to have crashed: Abort trap
25-01-10 15:07:32   ReportCrash[13882]   Saved crash report for soffice.bin[13871] version 3.0.2 (3.0.2 Patch 0 Intel (pluby:guibomacmini.local.)) to /Users/oscarvanvliet/Library/Logs/DiagnosticReports/soffice.bin_2010-01-25-150732_macbook.crash
25-01-10 15:07:37   system_profiler[13886]   SPFWR ERROR: Hardware drivers did not load. No FireWire hardware detected.
25-01-10 15:07:37   [0x0-0x1bc1bc].com.apple.ProblemReporter[13884]   2010-01-25 15:07:37.592 system_profiler[13886:903] SPFWR ERROR: Hardware drivers did not load. No FireWire hardware detected.

25-01-10 15:08:02   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]   objc[13891]: Class AWTFont is implemented in both /Applications/NeoOffice.app/Contents/MacOS/../basis-link/program/libvcljava2.dylib and /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Libraries/libawt.jnilib. One of the two will be used. Which one is undefined.
25-01-10 15:08:08   soffice.bin[13891]   JavaNativeFoundation: GetGlobalVM: JNI_GetCreatedJavaVMs() failed to get any VM.
25-01-10 15:08:37   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]   OOO_CALC_USE_ENGLISH_FORMULAS=1 => UI uses English function names and separators in formulas.
25-01-10 15:08:39   soffice.bin[13891]   Application will become active - Using remote controls
25-01-10 15:09:12   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]   terminate called after throwing an instance of 'std::bad_alloc'
25-01-10 15:09:12   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]     what():  std::bad_alloc
25-01-10 15:09:13   com.apple.launchd.peruser.501[220]   ([0x0-0x1be1be].org.neooffice.NeoOffice[13891]) Job appears to have crashed: Abort trap
25-01-10 15:09:15   ReportCrash[13910]   Saved crash report for soffice.bin[13891] version 3.0.2 (3.0.2 Patch 0 Intel (pluby:guibomacmini.local.)) to /Users/oscarvanvliet/Library/Logs/DiagnosticReports/soffice.bin_2010-01-25-150915_macbook.crash
25-01-10 15:09:17   system_profiler[13914]   SPFWR ERROR: Hardware drivers did not load. No FireWire hardware detected.
25-01-10 15:09:17   [0x0-0x1bf1bf].com.apple.ProblemReporter[13912]   2010-01-25 15:09:17.509 system_profiler[13914:903] SPFWR ERROR: Hardware drivers did not load. No FireWire hardware detected.

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Mon Jan 25, 2010 7:54 am    Post subject:

The following lines in your Console log caught my eye:

Code:
25-01-10 15:08:37   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]   OOO_CALC_USE_ENGLISH_FORMULAS=1 => UI uses English function names and separators in formulas.
25-01-10 15:08:39   soffice.bin[13891]   Application will become active - Using remote controls
25-01-10 15:09:12   [0x0-0x1be1be].org.neooffice.NeoOffice[13891]   terminate called after throwing an instance of 'std::bad_alloc'


Basically, this means that I need to enable the OOO_CALC_USE_ENGLISH_FORMULAS to reproduce this crashing bug. I will also run NeoOffice with my machine set to use Dutch to better replicate your machine.

Can you remind my where you enable the OOO_CALC_USE_ENGLISH_FORMULAS setting? Also, when you disable that setting and open the file, does the crashing stop?

Patrick
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Mon Jan 25, 2010 8:06 am    Post subject:

GRrr. When I enter HTML tags that are not allowed, and I hit 'go back', the contents of my message is erased..

Anyway, you can find instructions in this thread.

And it seems like I have to log out or reboot to make this change happen so I will have to try that later.

Best wishes,
Oscar

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Tue Jan 26, 2010 7:47 am    Post subject:

Unfortunately, I still cannot reproduce the crashing even if I boot into Snow Leopard, enable OOO_CALC_USE_ENGLISH_FORMULAS, set my machine to Dutch, open your file, and page down through that TTW_FA tab so I don't think that enabling OOO_CALC_USE_ENGLISH_FORMULAS is the cause.

Can you check if one or more of your NeoOffice preferences might be what is causing the crash by doing the following steps?:

1. Quit NeoOffice

2. Move the following two folders if they exist to your Desktop. Note: "~" means your Home folder:

~/Library/Preferences/NeoOffice-3.0
~/Library/Preferences/NeoOffice-2.2

If the crashing stops, can you attach a .zip file of the NeoOffice-3.0 folder that you moved to your Desktop?

Patrick
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Tue Jan 26, 2010 8:16 am    Post subject:

Well whaddayaknow..

I stopped crashing.

I am sending the zip file to you by email because the preference contain my name, adress, etc. Smile.

Good luck debugging this one Embarassed.

-Oz

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Wed Jan 27, 2010 11:18 am    Post subject:

I found the specific preference that triggers this bug and now I can trigger it with a clean set of preference files by opening a Calc document, selecting the Tools :: Options menu and in the dialog that appears, selecting the NeoOffice Calc :: Calculate item, changing the Formula Syntax setting to "Excel A1". After doing that, I can reproduce the crashing repeatedly in both NeoOffice and my Go-oo build.

Apparently OpenOffice.org 3.0.1 does not have the Formula Syntax setting in that dialog so this is a bug in the Go-oo modications that we have included in NeoOffice 3.0.1.

I will investigate this bug further. In the meantime, you can use move your old preferences back into place if you want but you will need to change the Formula Syntax setting to "Calc A1" to stop the crashing.

Patrick
Back to top
narf
The Anomaly


Joined: Jan 21, 2007
Posts: 1075

PostPosted: Wed Jan 27, 2010 12:57 pm    Post subject:

I have created bug 3587 to track this issue.

-- fran
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Wed Jan 27, 2010 4:59 pm    Post subject:

I have good news and bad news.

The good news is that I fixed the bug. The bad news is that I fixed the bug by removing the entire Formula Syntax setting from the dialog and forcing all documents to use the Calc A1 format.

It may seem a bit radical to solve a crashing bug like this by removing the special functionality that causes the crash., but in this case I found that Novell's Go-oo engineers have removed the Formula Syntax feature in all of their post-OpenOffice.org 3.0.1 releases. I assume that they removed it because they also found similar crashing bugs and they were unable to fix the bugs with that feature enabled.

Since Novell removed it in their newer versions, it is clear that the feature would go away whenever we upgrade the OpenOffice.org code and, because of that, it seems logical to remove the feature from NeoOffice 3.0.2 to fix the stability issues that the feature causes.

I can only hope that this Go-oo feature is used by very few NeoOffice donors. Sad

I am rebuilding NeoOffice 3.0.2 now and I should have the new build ready for Oscar to test in a couple hours.

Patrick
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Wed Jan 27, 2010 7:36 pm    Post subject:

FYI. The new (and hopefully final) NeoOffice 3.0.2 build is in now available from the test server. If the crashing is fixed for you (set the Formula Syntax setting back to "Excel A1" before you install the new build), I will release the new build to the Early Access Program members.

Patrick
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Thu Jan 28, 2010 7:58 am    Post subject:

Dear Patrick,

I am in Paris right now and unable to do testing. I can look at it on monday at the earliest.

Feel free to release with or without the fix, as the number of users that is affected by the crash is pretty small (me, so far) and the number of users of the disabled features is unknown.

Bonne chance,
Oscar

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Thu Jan 28, 2010 11:32 am    Post subject:

OK. I have included the fix in NeoOffice 3.0.2 which we released today. Members and subscribers of the current NeoOffice Early Access Program can download NeoOffice 3.0.2 from the NeoOffice Early Access Program download page.

Important note for Calc users who are using "Excel A1" or "Excel R1C1" as the formula syntax: in order to fix this bug, we had to remove the ability to use "Excel A1" or "Excel R1C1" as the formula syntax. This feature was an experimental feature developed by Novell's Go-oo engineers that we have included in NeoOffice 3.0.1 and 3.0.2 Early Access. Unfortunately, we have found that Novell's experimental feature makes NeoOffice Calc unstable and since Novell's engineers have removed this feature from their Go-oo releases, we were unable to fix the stability bugs in their code. As a result, we had to remove this feature.

Patrick
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Mon Feb 01, 2010 4:21 pm    Post subject:

I can verify that your fix works, and that I will not miss the R1C1 syntax.

Best wishes,
Oscar

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Beta Releases All times are GMT - 7 Hours
Goto page Previous  1, 2, 3
Page 3 of 3

 
You can post new topics in this forum
You can 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.