[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User gercokees changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Wed Jul 18 12:14:12 + 2007 --- Hi, I tried your examples, and found no problem. Unless you provide more information, the exact steps to reproduce wich lead to the problem, what you expected the software to do, what it actual did and so on (please read the information given in the post above) we realy cannot fix the problem. I will close this now as a works-for-me. Feel free to reopen anytime... Greetz - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User rainerbielefeld changed the following: What|Old value |New value Status|RESOLVED |CLOSED Keywords|needmoreinfo |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Wed Jul 18 20:02:57 + 2007 --- Closed due to reporter's inactivity - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User cmc changed the following: What|Old value |New value Platform|Opteron/x86_64|All --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 07:01:08 + 2007 --- i386, not x86_64. So a standard 32bit OOo. It might be the case the 2.0.2 is showing its age, though I've no evidence to support that it is fixed for 2.0.4 (e.g. FC-6) or 2.2.0 (e.g. FC-7) - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 08:26:55 + 2007 --- as per request from rainerbielefeld, my XLS is attached - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User bugbear changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44770) invalid Excel file --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 08:28:13 + 2007 --- Created an attachment (id=44770) invalid Excel file - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 08:37:43 + 2007 --- @bugbear: I can's see any differences between your xls and your ods Please contribute a detailed and comprehensible description of your problem! Avoid such weak phrases like does not work and replace them by exact descriptions as per http://www.openoffice.org/bugs/bug_writing_guidelines.html What is your _real_ problem? The formula looks changed in EXCEL? EXCEL has an other result of the calculation? ... ? - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User rainerbielefeld changed the following: What|Old value |New value CC|'cmc,kendy,kpalagin' |'cmc,kendy,kpalagin,rainer | |bielefeld' --- Additional comments from [EMAIL PROTECTED] Sun Apr 29 07:47:36 + 2007 --- I checked with 2.2.0RC4 German version WIN XP: [680m14(Build9134)] / 2.0.2 German version WIN XP: [680m5(Build9011)]: not reproducible, I see the same results in OOo and in the exported .xls in MS EXCEL Viewer. @bugbear: Please attach your xls export result. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User rainerbielefeld changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44757) comparision ods / x | |ls --- Additional comments from [EMAIL PROTECTED] Sun Apr 29 07:49:05 + 2007 --- Created an attachment (id=44757) comparision ods / 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 --- Additional comments from [EMAIL PROTECTED] Thu Feb 15 09:39:30 + 2007 --- with apologies: a yum whatprovides ooffice gave me: openoffice.org-core.i386 1:2.0.2-5.20.2 installed BugBear - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User pjanik changed the following: What|Old value |New value CC|'kpalagin'|'cmc,kendy,kpalagin' --- Additional comments from [EMAIL PROTECTED] Wed Feb 14 20:30:07 + 2007 --- kendy,cmc: can you please try this? - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 --- Additional comments from [EMAIL PROTECTED] Wed Feb 14 20:43:11 + 2007 --- I was working with OOo 2.0.2 under FC5, saving as Excel 97/2000/XP there was no fedora native 64bit FC-5 x86_64 OOo, so if this is the fedora provided OOo, then it's just a standard 32bit one. There doesn't seem to be any reason to suspect a 64bit OOo here. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User pjanik changed the following: What|Old value |New value Assigned to|pjanik|bugbear --- Additional comments from [EMAIL PROTECTED] Wed Feb 14 20:47:42 + 2007 --- bugbear: please provide exact version of the OOo you were using. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 Issue #|74446 Summary|nested IFs do not appear to export correctly to Excel Component|Spreadsheet Version|OOo 2.0.2 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|bugbear --- Additional comments from [EMAIL PROTECTED] Mon Feb 12 12:05:56 + 2007 --- I don't know why, since I'm not deep techy enough to read the Excel files. But: But, it appears (on brief exploration) that nested if's are not converted correctly. This works =IF(B3 ; 78;900) This doesn't work (nested ifs) =IF(B4; IF(B3; 3; 5); 17) Surprisingly, this works (nesting other than if) =(IF(B4; SUM(1;3); 999)) This doesn't work: =SUM(3; IF(B3 ; 34; 56)) So it appears that inner IFs are some kind of special case for save as. I was working with OO 2.0.2 under FC5, saving as Excel 97/2000/XP, and opening under Windows XP, Excel 2002. BugBear - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User bugbear changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42945) fails to export --- Additional comments from [EMAIL PROTECTED] Mon Feb 12 12:07:06 + 2007 --- Created an attachment (id=42945) fails to export - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |pjanik --- Additional comments from [EMAIL PROTECTED] Mon Feb 12 13:05:01 + 2007 --- Hi, could not reproduce with 32 bit version of upcomming 2.2. Pavel could you check with a 64 bit version please ? Thanks Frank - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74446] nested IFs do not appear t o export correctly to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74446 User kpalagin changed the following: What|Old value |New value CC|''|'kpalagin' Keywords| |needmoreinfo --- Additional comments from [EMAIL PROTECTED] Mon Feb 12 15:19:09 + 2007 --- Can't repro with 2.2m5 on either WinXP or Suse10.2 (32bit). bugbear, please try 2.1 or at least attach resulting .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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
