[sc-issues] [Issue 101991] Calc - conditional format ting not working properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101991 --- Additional comments from wolfgang...@openoffice.org Mon May 18 03:06:45 + 2009 --- Hallo Regina, Thanks a lot for looking into this. What I'm trying to do is to have a different color for a given column depending on the condition. So if my cell value = Yes, the color should change to Yellow. If the cell value is blank or has no value it should remain white. However currently it also changes to yellow as outlined in the attachment. The single quotes have been added by the system, I only added Yes. If the way I performed the conditional formatting is wrong please advise, but don't make me read the Help again, since this is not clear or intuitive. Thanks Wolfgang - 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 101991] Calc - conditional format ting not working properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101991 Issue #|101991 Summary|Calc - conditional formatting not working properly Component|Spreadsheet Version|OOo 3.1 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|wolfgang311 --- Additional comments from wolfgang...@openoffice.org Sat May 16 17:29:21 + 2009 --- Hello development team, Tried to perform a conditional formatting task, but this didn't work as expected. 1. Created a new cell style = Yellow, works fine 2. Selected a column range for E2-E5 3. Selcted conditional formating with the following statement: If cell value equal to Yes, then apply cell style 'Yellow' The cell which contained Yes shows as yellow, however empty cells are also showing as yellow. See screenshot attached. /Users/w_herbel/Desktop/screen-capture-1.png - 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 101991] Calc - conditional format ting not working properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101991 --- Additional comments from wolfgang...@openoffice.org Sat May 16 17:30:16 + 2009 --- Created an attachment (id=62314) Conditional formatting problem - 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
[framework-issues] [Issue 90473] Add Persian language to Au toCorrect window setting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90473 --- Additional comments from wolfgang...@openoffice.org Mon Apr 6 03:08:16 + 2009 --- Hello Development team, Thanks for fixing the 509 error. However when I opened the same file I now get #Name? error, which means the linkage to the tab I'm using is broken. I'm currently running ver. 3.0.1 M15 build 9379 Please advise if I should open a new issue or if this will be handled under this one. Thanks Wolfgang - 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...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96019] Cell Reference lost when o pening Excel 2008 spreadsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96019 Issue #|96019 Summary|Cell Reference lost when opening Excel 2008 spreadshee |t Component|Spreadsheet Version|OOO300m9 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|wolfgang311 --- Additional comments from [EMAIL PROTECTED] Mon Nov 10 03:30:39 + 2008 --- Hi when I open an existing Excel 2008 document some of my cell references are lost. Example: When opening in Excel the cell ref is: ='Macintosh HD:Users:w_herbel:Documents:Private:Condo Trust:[Condo Plan 2007.xlsx]DebitsCredits'!$G$65 When opening in Calc: ='[1]debitscredits'!$g$65 - 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 96020] Calc crashed while I tried to add formatting options with open Spreadshe et
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96020 --- Additional comments from [EMAIL PROTECTED] Mon Nov 10 03:53:30 + 2008 --- Created an attachment (id=57810) Hang msg before forced quit - 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 90743] ERR:508 when opening a Exc el 2008.xlsx file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90743 --- Additional comments from [EMAIL PROTECTED] Fri Jul 25 01:53:05 + 2008 --- Download of Beta 2 re-tested. Issue still not resolved: The cell contains in Excel 2008 a ref. to a file (='Macintosh HD:Users:w_herbel:Documents:Private:Condo Trust:[Condo Plan 2007.xlsx]DebitsCredits'!$G$65) however when opening via Spreadsheet the cell ref. only shows: ='[1]debitscredits'!$G$65. Therefore the whole link to the ref. file is missing. - 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 90743] ERR:509 when opening a Exc el 2008.xlsx file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90743 User wolfgang311 changed the following: What|Old value |New value Summary|ERR:508 when opening a Exc|ERR:509 when opening a Exc |el 2008.xlsx file |el 2008.xlsx file --- Additional comments from [EMAIL PROTECTED] Fri Jul 25 01:53:21 + 2008 --- Download of Beta 2 re-tested. Issue still not resolved: The cell contains in Excel 2008 a ref. to a file (='Macintosh HD:Users:w_herbel:Documents:Private:Condo Trust:[Condo Plan 2007.xlsx]DebitsCredits'!$G$65) however when opening via Spreadsheet the cell ref. only shows: ='[1]debitscredits'!$G$65. Therefore the whole link to the ref. file is missing. - 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 90743] ERR:509 when opening a Exc el 2008.xlsx file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90743 User wolfgang311 changed the following: What|Old value |New value Version|OOo 3.0 Beta |OOo 3.0 Beta 2 - 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 90743] ERR:508 when opening a Exc el 2008.xlsx file
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=90743
Issue #|90743
Summary|ERR:508 when opening a Excel 2008.xlsx file
Component|Spreadsheet
Version|OOo 3.0 Beta
Platform|Macintosh
URL|
OS/Version|Mac OS X
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|wolfgang311
--- Additional comments from [EMAIL PROTECTED] Sun Jun 15 03:03:47 +
2008 ---
When I open an existing Excel file it seems that the formulas are not
interpreted correctly.
Excel formula:
=-SUMIF('debitscredits'!H$2:H$64;Insurance;'debitscredits'!F$2:F$64)
Tab name in Excel file: Debits Credits
Error msg: ERR:508
Operating System OS X 10.5.3
File format: Excel 2008, *.xlsx
-
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 90743] ERR:508 when opening a Exc el 2008.xlsx file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90743 --- Additional comments from [EMAIL PROTECTED] Sun Jun 15 03:10:13 + 2008 --- Created an attachment (id=54485) Error message in Formula field and Tab name - 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]
