[sc-issues] [Issue 103456] Complex formula would not work for .xls, Formula Wizard fixes it.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103456 User regina changed the following: What|Old value |New value CC|'fst' |'fst,regina' --- Additional comments from reg...@openoffice.org Thu Aug 20 12:42:44 + 2009 --- I think that it is the same problem as reported in issue 99075 and earlier in issue 79854. The function BASE is unknown in Excel. For me the error is, that after saving to ods-format you need to reload the document and that 'Hard Recalculate" does not remove the #MACRO? remark on the now ods-document. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103456] Complex formula would not work for .xls, Formula Wizard fixes it.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103456 --- Additional comments from kpala...@openoffice.org Thu Aug 20 06:23:09 + 2009 --- Created an attachment (id=64259) See cells J2:O33 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103456] Complex formula would not work for .xls, Formula Wizard fixes it.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103456 User kpalagin changed the following: What|Old value |New value CC|''|'fst' --- Additional comments from kpala...@openoffice.org Thu Aug 20 06:21:37 + 2009 --- Here is simplistic file - base(a1;32) will display #MACRO? when round-triping to .xls. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103456] Complex formula would not work for .xls, Formula Wizard fixes it.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103456 Issue #|103456 Summary|Complex formula would not work for .xls, Formula Wizar |d fixes it. Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|kpalagin --- Additional comments from kpala...@openoffice.org Fri Jul 10 14:29:29 + 2009 --- (File is confidential and will be sent to fst). Open supplied file - in column G you get #MACRO?. Click in, say, G8 and bring up Formula Wizard, click OK - you get a date result. Saving to .ods and reopening fixes the problem too. Problem first discovered in 2.4.1 and still exists in m51. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org