[sc-issues] [Issue 86171] ODFF: MINA(range)=MIN(rang e): text should equal zero also for formulas r eturning text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86171 --- Additional comments from [EMAIL PROTECTED] Thu Feb 21 13:07:08 + 2008 --- Confirmed to be the same on Linux TEXT is OK Formulae returning TEXT is not OK - 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 86171] MINA(range)=MIN(range): te xt should equal zero
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86171 Issue #|86171 Summary|MINA(range)=MIN(range): text should equal zero Component|Spreadsheet Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|aliby --- Additional comments from [EMAIL PROTECTED] Mon Feb 18 08:48:02 + 2008 --- The solution to MINA(range) and MIN(range) is currently the same MINA() should treat text as a zero value as per the function description even if part of a range. if A1=3; A2=2; A3=1; A4=text then MIN(A1:A4) =1 as it ignores text entries MINA(A1:A4)=1 where it should be zero NOTE however that ... MINA(A1:A3;A4)=0 as it recognizes the text in the single entry Also on Linux OOo Calc 2.3.0 (don't have 2.3.1) ... MINA(A1:A4)=0 as it should be. - 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]
[installation-issues] [Issue 85880] Customizations lost on upg rade
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85880 User aliby changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|INVALID | Summary|Customizations and User pr|Customizations lost on upg |eferences are lost on upgr|rade |ade | --- Additional comments from [EMAIL PROTECTED] Mon Feb 18 07:44:34 + 2008 --- This is a valid issue relating to the settings under Tools/Customize/Keyboard/Shortcut Keys. Any customizations by the user are replaced by the default shortcut set during an upgrade or re-install. - 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 85984] Relative reference shortcu t not working in function wizard
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85984 --- Additional comments from [EMAIL PROTECTED] Mon Feb 18 07:51:56 + 2008 --- With large formulae the Function Wizard enables you to view or access parts of the formula at a time. Being able to then apply relative reference rules then ensures that you are doing so to the correct section of the formula. - 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 38759] ODFF: MIN/MINA MAX/MAXA sh ould return 0 if all parms are empty
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=38759 --- Additional comments from [EMAIL PROTECTED] Sun Feb 10 15:53:14 + 2008 --- This is actually an issue that nullifies compatibility between Excel and OOo. Fancy IF statements are required at present to ensure backwards compatibility. The argument against a fix remains academic, but the solution ensures that a formulae remains error free and can provide a solution even before all values are populated. The main frustration is compound MIN/MAX as the error is carried through. viz: =MIN(MIN(A1:A4),MIN(A10:A14)); will error if A10:A14 is empty even if A1:A4 has a valid solution. It seems to be an issue that can and has been resolved with Patches. Surely it doesn't have to wait until version 3.0? This bug and 71776 both confirm the need for a Fix. - 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 85984] Relative reference shortcu t not working in functin wizzard
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85984 Issue #|85984 Summary|Relative reference shortcut not working in functin wiz |zard Component|Spreadsheet Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|aliby --- Additional comments from [EMAIL PROTECTED] Sun Feb 10 16:09:51 + 2008 --- In OOoCalc relative references can be quickly defined using the shortcut key Shift+F4. However, when in the function wizzard this shortcut key becomes disabled. - 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]
[installation-issues] [Issue 85880] Customizations and User pr eferences are lost on upgrade
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85880 Issue #|85880 Summary|Customizations and User preferences are lost on upgrad |e Component|Installation Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|of Reported by|aliby --- Additional comments from [EMAIL PROTECTED] Tue Feb 5 12:04:35 + 2008 --- Customizations and User preferences are lost or overwritten on upgrade. LOST: Custom shortcut keys Dictionaries OK: Toolbar's seems to be OK - 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]
[framework-issues] [Issue 85852] Over-write Dictionary Sett ings
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85852 Issue #|85852 Summary|Over-write Dictionary Settings Component|framework Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|tm Reported by|aliby --- Additional comments from [EMAIL PROTECTED] Mon Feb 4 10:04:54 + 2008 --- ON install the dictionary.lst file is over written so that any custom dictionaries are no longer available until the file is edited and restored. The settings configuration should be maintained during installation or should at least be an option during the install process? - 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]
[graphics-issues] [Issue 73779] Allign / Arrange in Edit points / Edit glue points
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73779 Issue #|73779 Summary|Allign / Arrange in Edit points / Edit glue points Component|Drawing Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|wg Reported by|aliby --- Additional comments from [EMAIL PROTECTED] Mon Jan 22 23:33:39 -0800 2007 --- Enable allignment (top, middle, bottom, left, center, right) and ditribution between end point (equal, biased) so that it is easier to create mirrored freehand sketches and create new glue points evenly distibuted accross one side of an object. Currently alignmnet wants to move the object relative to the page. We want alignment to be able to manipulate the selected points or glue points. - 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]
[sw-issues] [Issue 25177] Regular expressions in fin d and replace many combinations not available
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25177 --- Additional comments from [EMAIL PROTECTED] Wed Jun 28 02:43:00 -0700 2006 --- To my disdaine, I still have to open MS Word to do effective Find Replace. The regular expressions just doesn't provide simple formatting tag replacement. I sedom use it any more, but Word even has a more drop-down button where you can select an item (eg. non-breaking space, section break) and it will insert the correct coe (in our OOo case regular expression). Regular Expressions DO have the potential to be VERY powerful, but it has overlooked the simple searches that most people will use. That reduces it and people no longer apprecate the possibilities. Please this needs to be addressed ASAP! OOo 2.0.3? - 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]