NeoOffice Bugzilla - View Bug

Bug #3587 - Crash in Calc when formula Syntax set to Excel A1 - Return to bug list

Reporter:	******	Created:	01-27-2010
Project:		Priority:
Component:		Severity:
Version:	Patchlevel:	Operating System:
To be closed in version
Closed in version
Summary:		Status:
URL:		Resolution:
Assigned to:	******	Add CC:
Depends on bugs: Blocks bugs: Add dependency: Remove dependency:		Remove selected CCs:

Additional comments:

You must login to modify this bug

Attachments:

Name	Size	Type	Created

No attachments found for this bug

Vote for this bug | View votes (0) | View bug history

Comments:

Posted by: ******
Date: 1:56 PM 01-27-2010

See the following formula topic for more information:

http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=7830

From a post by pluby in the above topic:
"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."

Posted by: ******
Date: 11:36 AM 01-28-2010

FYI. I fixed this bug by disabling use of the Excel A1 and R1C1 Formula Syntax settings. The fix has been included in NeoOffice 3.0.2.