[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 --- Additional comments from drk...@openoffice.org Fri Dec 3 15:58:17 + 2010 --- Thank you - I updated the function help wiki text accordingly. - 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 113872] N() should return 0 for a ll textual cell content
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113872 --- Additional comments from drk...@openoffice.org Fri Aug 13 20:38:41 + 2010 --- Eike, please see also: http://qa.openoffice.org/issues/show_bug.cgi?id=113739 which arose (later than my email to you) out of the same oooforum.org discussion - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from drk...@openoffice.org Tue Aug 25 07:20:40 + 2009 --- Our proposal for the function wizard:- function description: calculates the probability of a sample mean greater than the mean of the given sample. first parameter The given sample, drawn from a normally distributed population second parameter The known mean of the population third parameter The known standard deviation of the population. If omitted, the standard deviation of the given sample is used. - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from drk...@openoffice.org Mon Aug 24 12:50:11 + 2009 --- Regina and I are discussing this by private email and will come up with something - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from drk...@openoffice.org Sat Aug 22 21:27:20 + 2009 --- Hi Regina I think you mean 'z-score' rather than 'z-core'. For your short form version, we really should make clear that this is a sample, not the entire population. There's a real problem understanding the function, because Excel has described it incorrectly, and it also doesn't work as you might expect. So my inclination is to use more words, rather than try to be succinct. I do find the diagrams helpful for this, to highlight the difference between one-sided and one/two-tailed. I'd suggest that it's helpful to be very clear that this is not a one- or two-sided test - although I'd also be happy if we simutaneously avoided the 'one-sided' label. D - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from drk...@openoffice.org Fri Aug 21 07:59:41 + 2009 --- I'm not sure that's exactly right. The p-value can refer to the value on the vertical axis, whereas it's the area (cumulative probability) that is returned. Because Excel has got their description wrong in the past (and may well still have it wrong), and because the function returns an unconventional result it might be better to be *really* clear about this, with diagrams. The stuff I wrote in 2008 is here: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_ZTEST_function and you'd be very welcome to use it in ODFF of course - 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 84168] DCOUNT(..;0;..) counts tex t cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84168 --- Additional comments from drk...@openoffice.org Sun Aug 2 06:04:18 + 2009 --- Thanks, Regina. I wrote some improved help on the Wiki back in 07: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function It links back to this issue. - 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 36075] OO Calc PRICE output diffe rs from Excel PRICE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=36075 --- Additional comments from [EMAIL PROTECTED] Fri Oct 10 15:46:33 + 2008 --- Is there anyone who knows how this function exactly works? I've done a write-up on: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_PRICE_funct ion which links to a derivation of the formula. I've not had a chance to examine this issue itself - simply passing on what might be a helpful link. - 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 36075] OO Calc PRICE output diffe rs from Excel PRICE
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=36075 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 47740] annoying toolbars behavior
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47740 --- Additional comments from [EMAIL PROTECTED] Thu Oct 9 09:33:49 + 2008 --- @ starko Please check the comments above for how to enable/disable the toolbars, eg: Additional comments from pesala Sun Jan 27 20:20:34 + 2008 - 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 94406] range operator ':' not ful ly compatible with Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94406 Issue #|94406 Summary|range operator ':' not fully compatible with Excel Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Mon Sep 29 05:31:57 + 2008 --- A forum poster has imported from Excel: SMALL(INDEX(J2:AG2;;F2):AG2;1) where F2 contains a number which doesn't work in Calc, even as SMALL(INDEX(J2:AG2;1;F2):AG2;1) (in case the missing parameter is a problem) INDEX does return a reference - eg ROW(INDEX(...)) works OK. I _think_ that the range operator ':' is probably not understanding the single cell reference returned by INDEX(J2:AG2;1;F2) - 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 84266] =ISNUMBER(FALSE) returns T RUE; logical values converted to numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84266 --- Additional comments from [EMAIL PROTECTED] Sat Sep 20 07:27:42 + 2008 --- More information: A1: =TRUE displays 1 - not good A2: =TRUE() displays TRUE ISLOGICAL(A1) displays FALSE - good ISLOGICAL(A2) displays TRUE - good Change the format of A1:A2 to number; both show 1; ISLOGICAL does not change... ..until you hit hard recalculate Shift-Ctrl-F9 - then -FALSE Change the format of A1:A2 to boolean; both show TRUE; ISLOGICAL does not change... ..until you hit hard recalculate Shift-Ctrl-F9 - then -TRUE I see the absence of a separate type for logical values as a serious weakness; there are many similar examples. But of course it's a lot of work to remedy. - 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 46165] Regular expressions work i nconsistently or not at all when combined.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46165 User drking changed the following: What|Old value |New value CC|'cornouws,dowdenan,huw,kpa|'cornouws,dowdenan,drking, |lagin,sba'|huw,kpalagin,sba' - 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 87479] CELL function with argumen t FILENAME, does not update
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87479 User drking changed the following: What|Old value |New value Summary|CELL function with argumen|CELL function with argumen |t FILENAME, does not upd|t FILENAME, does not upd |ate |ate --- Additional comments from [EMAIL PROTECTED] Thu Sep 18 21:32:01 + 2008 --- Confirmed on Ooo2.4.1 Win XP =CELL(FILENAME;D2) does not update when the filename is changed with a Save As. However it does update on Ctrl-Shift-F9 and if the document is closed and re- opened. - 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 93422] MODE - calculation incorre ct
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93422 User drking changed the following: What|Old value |New value CC|''|'drking' --- Additional comments from [EMAIL PROTECTED] Thu Sep 18 21:55:44 + 2008 --- I think MODE is actually behaving as intended - as documented (a) in ODFF and (b) here: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MODE_functi on and also as Excel behaves. Might this be more of an enhancement request? You can find out if there is only one mode by: =MAX(A1:A8)-MODE(MAX(A1:A8)-A1:A8)=MODE(A1:A8) where A1:A8 contain the data, but I accept it's a bit messy - 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 93422] MODE - calculation incorre ct
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93422 --- Additional comments from [EMAIL PROTECTED] Thu Sep 18 22:15:28 + 2008 --- or better: =-MODE(-A1:A8)=MODE(A1:A8) that's more reasonable ;) - 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 86283] DELTA/GESTEP functions wit h non-numeric args are inconsistent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86283 --- Additional comments from [EMAIL PROTECTED] Tue Sep 9 08:02:24 + 2008 --- In MS Excel, DELTA/GESTEP functions don't exist. They're categorised as 'engineering functions' in Excel - so yes, Excel does have them. - 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 93534] PRICEDISC et al.: Basis 0 NASD implementation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93534 Issue #|93534 Summary|PRICEDISC et al.: Basis 0 NASD implementation Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sat Sep 6 06:30:17 + 2008 --- A number of functions, including PRICEDISC use GetDiffDate() to calculate the result. GetDiffDate() doesn't implement basis 0 (NASD) correctly - it makes no attempt to change month end dates. Example: PRICEDISC(2009-07-31;2009-08-5;2%;100;0) returns 99.9778 based on 30+5-31 = 4 days difference in dates (!) Excel correctly returns 99.9722 (5 days difference in dates) (note that the inverse function YIELDDISC uses a difference routine (!) - YEARFRAC - I have not investigated that yet) Reference: NASD implementation was also the subject of issue 84934 - for DAYS360. PS: GetDiffDate() also gives the days in the *first year* - this is often not what is required, and is different from Excel. I'm not yet sure how this should be specified. I guess there are ODFF implications 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 93534] PRICEDISC et al.: Basis 0 NASD implementation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93534 --- Additional comments from [EMAIL PROTECTED] Sat Sep 6 06:35:37 + 2008 --- My comment : GetDiffDate() also gives the days in the *first year* is really covered in: Issue 93527 so can possibly be ignored 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 93527] INTRATE and RECEIVED funct ions different to Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93527 Issue #|93527 Summary|INTRATE and RECEIVED functions different to Excel Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Fri Sep 5 16:40:03 + 2008 --- Both these functions involve deciding how many days are in a year (and more particularly, *which* year); Calc and Excel do it slightly differently in basis 1. Calc uses the year containing the settlement date. Excel is more subtle - I think it is documented in OOXML, but I'm not sure if Excel actually follows that exactly. David Wheeler has done some work on this for ODFF. It's something like 366 only if Feb29 is included, otherwise 365. Examples: INTRATE(2008-09-02; 2009-03-02; 1000; 1080;1) RECEIVED(2008-09-01; 2009-03-31; 1; 5%; 1) This is not of great importance - but worth making a note of I hope. - 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 92177] ODDFPRICE, ODDFYIELD, ODDL PRICE, ODDLYIELD all faulty
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92177 --- Additional comments from [EMAIL PROTECTED] Fri Aug 15 18:38:30 + 2008 --- The code for 2 of these functions has simply been commented out, and an error call inserted - which explains why they always return an error ;) - 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 84934] ODFF: DAYS360 compliance
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 21:40:11 + 2008 --- Adding a MS reference to this issue: http://support.microsoft.com/kb/916004 When you use the DAYS360 function to calculate the number of days between two dates, an unexpected value is returned. The article continues: when you use the DAYS360 function with a start date of February 28 and with an end date of March 28, a value of 28 days is returned. You expect a value of 30 days to be returned for every full month. and I point out that you do actually expect 28 days, not 30. Possibly MS are aware of their bug, but their authors have not explained it properly. - 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 92177] ODDFPRICE, ODDFYIELD, ODDL PRICE, ODDLYIELD all faulty
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92177 Issue #|92177 Summary|ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD all faulty Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Jul 27 07:42:18 + 2008 --- As documented in the June08 ODFF draft: ODDFPRICE(1990-06-01; 1995-12-31; 1990-01-01; 1990-12-31; 6%; 5%; 1000; 1; 1) gives an error. ODDFYIELD(1990-06-01; 1995-12-31; 1990-01-01; 1990-12-31; 6%; 790; 100; 1; 1) gives an error. ODDLPRICE(1990-06-01; 1995-12-31; 1990-01-01; 2%; 1.5%; 100; 4; 1) is inaccurate; gives same result as ODDLPRICE(1990-06-01; 1995-12-31; 1990-01-01; 2%; 1.5%; 100; 1; 1). ODDLYIELD(1990-06-01; 1995-12-31; 1990-01-01; 2%; 103; 100; 4; 1) is inaccurate; gives same result as ODDLYIELD(1990-06-01; 1995-12-31; 1990-01-01; 2%; 103; 100; 1; 1). It turns out that this was discussed in the forums at least as early as 2005, but no-one raised an issue. - 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 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 Issue #|91870 Summary|PMT function with extremely small rates - #VALUE! Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Jul 20 17:15:22 + 2008 --- The formula for PMT (payment at end) is [p(1+r)^n - f]r / ((1+r)^n-1) where n = number of periods p = principal (the capital sum borrowed) f = the final balance owing after n periods r = interest rate (fixed rate) per period derived here: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Derivation_ of_Financial_Formulas#PMT With extremely small values for r we get too close to divide by 0 Example: =PMT(1E-016;10;1000;0;0) gives #VALUE! Note that =PMT(4.567E-015;10;1000;0;0) is OK - larger, but with more displayed digits - so we have not run out of precision with the rate. Excel has the same problem, giving #DIV/0!. The solution may be to trap low values and apply another algorithm, also provided on the linked page. rate=0 is trapped anyway. This error will not arise in real life, so this should be low priority and I've marked it enhancement rather than defect. It is bad to have a function that can be beaten though, and there should be a record of the fact. - 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 91870] PMT function with extremel y small rates - #VALUE!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91870 --- Additional comments from [EMAIL PROTECTED] Sun Jul 20 22:22:20 + 2008 --- Thanks Regina I think you are the expert here - I'll leave it to you ;) - 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 91651] VDB function: Calc and Exc el produce different results; both wrong
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91651 Issue #|91651 Summary|VDB function: Calc and Excel produce different results |; both wrong Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Mon Jul 14 20:34:57 + 2008 --- This is an isolated problem - only affects the year when depreciation is capped. The function in most normal use is OK. VDB(10;2;10;7;8) returns 971.52 (correct) VDB(10;2;10;7.25;7.75) returns 3276.80 (incorrect - can't be more!) Excel97 returns 0 - that's wrong too. Should be 971.52/2 I think. I've just finished a writeup of this function that (I hope) clarifies it fairly well: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_functio n The graphs should help illustrate the situation. - 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 75987] regular expression in calc formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75987 --- Additional comments from [EMAIL PROTECTED] Sat Jun 28 04:34:00 + 2008 --- Further to drensink's workaround: =SUMPRODUCT(ISNUMBER(FIND(S;A1:A200))) in a cell will count cells containing capital 'S' (no need for another column B1:B200). (not a full solution of course, but might help someone) - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Tue Jun 17 07:30:37 + 2008 --- You have a good point. http://www.coventry.ac.uk/ec/~nhunt/pottel.pdf highlights a case where Excel's STDEV falls down. In fact Calc performs correctly with that data, so it might be better to simply call STDEV within ZTEST? - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Tue Jun 17 19:32:55 + 2008 --- Hi Regina Discussion moved to [EMAIL PROTECTED] - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Mon Jun 16 10:13:55 + 2008 --- Thanks, Leonard It's difficult to see exactly what R is calculating. I've tried to go back to basics to show that there is some logic/validity to Excel's method, and indeed that there is a clear bug with Calc, with the 3 parameter version. I've tried to get z.test to work in R but failed after a brief struggle. What happens if you set alternative (Direction of the alternative hypothesis) to 'greater', or 'less' or even 'two.sided'? I think Excel produces a 'one-sided' (not 'one-tailed') test which might correspond to 'greater'. - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Mon Jun 16 11:55:29 + 2008 --- Ah, I figured how to use z.test in R (over lunch ;). Yes, it does give the same results as Excel: z.test(x,100,5,'greater') Even with the mean on the other side y-c(110,105,105,100) z.test(y,100,5,'greater') I'm now convinced that 'one-sided' is the correct description for what Excel does - not one- or two- tailed. - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Mon Jun 16 12:09:00 + 2008 --- z.test does the two-tailed test by default:- = y-c(110,105,105,100) z.test(y,100,5) One Sample z-test data: y z = 2, n = 4.0, Std. Dev. = 5.0, Std. Dev. of the sample mean = 2.5, p-value = 0.0455 alternative hypothesis: true mean is not equal to 100 95 percent confidence interval: 100.1001 109.8999 sample estimates: mean of y 105 == p-value of 0.0455 is exactly twice what Excel gives - which is right, because when the sample mean is above the population mean Excel does the one-tailed test. In summary this all hangs together. - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Mon Jun 16 20:33:53 + 2008 --- Created an attachment (id=54518) ZTEST: one-sided or one-tailed; proposed bug 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Mon Jun 16 20:37:04 + 2008 --- I'm on a roll on this one... ;) Just attached a defence of my view that 'one-sided' is the correct term, plus a proposed bug 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 Issue #|90759 Summary|ZTEST not same as Excel Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Jun 15 20:43:49 + 2008 --- ZTEST produces different results to Excel. Attached file has a review. - 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 90759] ZTEST not same as Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90759 --- Additional comments from [EMAIL PROTECTED] Sun Jun 15 20:48:35 + 2008 --- Created an attachment (id=54497) Description of the ZTEST 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: [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 90628] LOOKUP: forced array param eters, as in ODFF Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90628 Issue #|90628 Summary|LOOKUP: forced array parameters, as in ODFF Excel Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Wed Jun 11 18:29:49 + 2008 --- ODFF defines the Searched and Results parameters as 'Forced Array'. Calc doesn't seem to handle for example =LOOKUP(4; A1:C1*2; A3:C3) where A1:C1*2 should be evaluated as an array formula. Gives error 504: function parameter is not valid. Excel does handle this OK. [It's possible that this could be added to issue 81214 ? ] - 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 15666] Search and Replace - can't substitute regular expression subexpression i n replace
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=15666 --- Additional comments from [EMAIL PROTECTED] Wed May 28 09:28:44 + 2008 --- @gudmund But: or $0 in the Replace box do not insert an empty paragraph mark I think that's how the thing works - you found an empty *paragraph* but tried to insert a *paragraph mark*. The Application Help is rather sparse on this topic; you might like to read the Wiki: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressio ns_in_Writer ? - 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 82808] Copy/paste of chart create s nonupdating chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82808 --- Additional comments from [EMAIL PROTECTED] Tue May 27 21:58:06 + 2008 --- In OOo2.4 WinXp I cannot now reproduce the bug. So agree it seems to be fixed somehow. i83762 may be irrelevant, as this was not ready for 2.4. - 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 71158] ODFF: Inconsistent GCD() a nd LCM() results for non-integers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71158 --- Additional comments from [EMAIL PROTECTED] Sat May 10 04:16:58 + 2008 --- @er Thank you! - 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 86658] OFFSET in array expression s
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86658 --- Additional comments from [EMAIL PROTECTED] Sat May 10 05:09:51 + 2008 --- Simply to make the note that further discussion of this issue took place on the [EMAIL PROTECTED] mailing list, starting: http://sc.openoffice.org/servlets/ReadMsg?list=devmsgNo=2922 - 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 89047] Regular expressions/whole cell matching in MATCH: recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89047 User drking changed the following: What|Old value |New value Summary|Regular expressions in fun|Regular expressions/whole |ction: recalculation |cell matching in MATCH: re | |calculation --- Additional comments from [EMAIL PROTECTED] Wed May 7 04:53:53 + 2008 --- Shift+Ctrl+F9 recalc all cells. Try the second mode. From my first post: Even if I recalculate manually using F9 or Ctrl-Shift- F9 the result does not change. I've now adjusted the subject, because this seems not to affect other functions that respond to regex, such as HLOOKUP and COUNTIF. These functions do recalculate following a change in regex setting. The problem also applies to changes in 'whole cell matching' (set on same dialog as regex): A1, A2 have Fred, red A3 has=MATCH(red;A1:A2;0) - 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 34417] Autocomplete should be off by default
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34417 --- Additional comments from [EMAIL PROTECTED] Mon May 5 08:25:36 + 2008 --- When I found Calc 'helping me' with AutoInput, I had no idea how to turn the feature off. Unless you already know the feature is called AutoInput, it's very difficult to find in the Help. So I vote to have it off by default. - 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 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=16786
--- Additional comments from [EMAIL PROTECTED] Mon May 5 11:21:30 +
2008 ---
I agree that being unable to enable/disable regex in a cell is a bad thing.
Same thing applies to 'whole cell matching'.
Possibly worse is that the regex setting is rather hidden away, so the user may
be unaware that his results are wrong.
One way around this would be to introduce a new function, say SETTINGS, similar
to STYLE. Whereas STYLE sets the cell colours etc, SETTINGS could control
regex, whole_cell_matching and maybe other things.
Unfortunately STYLE was designed to return 0, which means it has to be wrapped
in another function (eg T() or IF()) when used with text. STYLE appears to be
unique to Calc.
A typical construction with SETTINGS if it also returned 0 might be:
=IF(SETTINGS(1; 0); ; HLOOKUP())
An alternative if inline arrays were changed to be able to accept formulae:
={HLOOKUP(); SETTINGS(1; 0)} entered in scalar mode.
I'm not entirely sure this is all good - there might be implications with ODFF,
which has global regex/wildcard flags I think. I'm merely sharing an idea - a
possible solution.
-
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 16786] Need better control of reg exp in vlookup
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 89047] Regular expressions in fun ction: recalculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89047 Issue #|89047 Summary|Regular expressions in function: recalculation Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Mon May 5 23:10:24 + 2008 --- A1, A2 have blue, red A3 has =MATCH(r.d;A1:A2;0) This should return 2 if regular expressions are enabled and #N/A if not. In OOo2.4 WinXP I've found that if I enable/disable regular expressions the result does not change. Even if I recalculate manually using F9 or Ctrl-Shift- F9 the result does not change. (Other formulae, eg =RAND(), do recalculate). The only way to get the change seems to be to edit A1 or A2. I'm almost sure this did not happen in OOo2.3 - that recalculation always occurred. Another (experienced) user has confirmed the behaviour on a separate machine. Quite a serious problem I think - possibly P2. - 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 88967] PROB, FORECAST functions: scalar evaluation of array parameter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88967 Issue #|88967 Summary|PROB, FORECAST functions: scalar evaluation of array p |arameter Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sat May 3 11:16:32 + 2008 --- AB 1 30.7 2 40.3 =ABS(A1:A2) entered in cell C3 in scalar (non-array) mode correctly returns #VALUE! because there is no intersection between C3 and A1:A2 =PROB(A1:A2;B1:B2;A1:A2) entered in cell C3 in scalar (non-array) mode should surely also return #VALUE! for the same reason, but returns 0.7. It's as if A1:A2 is treated as an inline array not a range. A similar thing happens with FORECAST. These two functions have ForceArray parameters as well as a single parameter, which may be relevant. The only other function with this combination is TTEST. Not the most important issue, so I've suggested P4. However it doesn't seem to comply with ODFF so ought to be on the list. - 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 82185] Invalid formatting hangs F indAll/ReplaceAll with RegExp
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82185 --- Additional comments from [EMAIL PROTECTED] Mon Apr 21 15:55:07 + 2008 --- Couldn't reproduce the problem as described in the last description by drking (OOo3.0 dev build, dev300m7 on WinXP. On OOo2.4 WinXP, I also cannot reproduce the problem I described. Nor can I reproduce the problem with the invalid rtf file. Presumably something has changed. - 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 87855] ODFF: VARA and STDEVA with literal text arguments
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87855 --- Additional comments from [EMAIL PROTECTED] Thu Apr 10 09:58:47 + 2008 --- Yue, thank you! Seconded :) @er: Yes, looks like I misread Excel's Help text. It does seem to be almost deliberately unclear, and I agree we don't want to follow. - 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 88052] COMBINA function Help text is incorrect
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88052 User drking changed the following: What|Old value |New value Component|Spreadsheet |documentation QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED] Subcomponent|ui|Online help --- Additional comments from [EMAIL PROTECTED] Wed Apr 9 16:45:37 + 2008 --- Changed component to 'documentation', which I think is more appropriate - 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 88052] COMBINA function Help text is incorrect
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88052 Issue #|88052 Summary|COMBINA function Help text is incorrect Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Tue Apr 8 13:00:26 + 2008 --- One for the Help team (not sure that 'ui' is the right subcomponent?): I'm pretty sure that the existing Help text describes the function incorrectly and provides the wrong formula. It doesn't tie in with ODFF apart from anything else. The version at http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COMBINA_fun ction is I hope more accurate. - 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 82644] array constants fail with signed numbers
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82644
--- Additional comments from [EMAIL PROTECTED] Fri Apr 4 06:13:14 +
2008 ---
It's great that this is now working in OOo2.4
However, rather than ignoring spaces within inline arrays, spaces are now
removed.
So =SUM( { 1; -3; 2 } )
becomes =SUM( {1;-3;2} ) in the formula bar
This is a new behaviour for the user; for example
=SUM( ABS( -2 ); 9 )
preserves that formatting exactly in the formula bar.
I'd suggest that we should either allow the user's spaces or not - but that it
should be consistent.
I personally like to see some spaces sometimes - it makes the thing more
readable.
-
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 82644] array constants fail with signed numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82644 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 87855] ODFF: VARA and STDEVA with text arguments - error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87855
Issue #|87855
Summary|ODFF: VARA and STDEVA with text arguments - error
Component|Spreadsheet
Version|OOo 2.4.0
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P4
Subcomponent|programming
Assigned to|spreadsheet
Reported by|drking
--- Additional comments from [EMAIL PROTECTED] Fri Apr 4 07:38:07 +
2008 ---
=STDEVA(red;1;2) gives Err:504 (parameter)
=STDEVA(0;1;2) gives 1 (OK)
=MAXA(red;1;2) is OK
=COUNTA(red;1;2) is OK
=AVERAGEA(red;1;2) is OK
=VARA(red;1;2) gives Err:504 (parameter)
ODFF (Dec07) is unclear what should happen, but it is fairly consistently
unclear:-
STDEVA( { Any sample }+ )
cells with text are converted to 0; other types are ignored.
AVERAGEA( { Any N }+ )
Cells containing text values are treated as if they contained number 0.
MAXA( { Any N }+ )
cells with text are converted to 0
The implication is that a text parameter should be treated as 0, the same as a
cell containing text. Really ODFF should be more specific - but whatever, Calc
should treat text in these xxxA functions in the same way.
This is not a burning issue - but I think is worthwhile sorting out. People
experimenting with these functions to find out how they work could easily try
the examples I give.
Many thanks
-
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 87855] ODFF: VARA and STDEVA with literal text arguments
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87855 --- Additional comments from [EMAIL PROTECTED] Fri Apr 4 11:52:50 + 2008 --- note the difference between cells with textual content and literal text arguments yep, thought I had ;) Excel97 also fails with eg STDEVA(red,1,2). Also, the online Help ref for Excel 2007 says it only allows text representations of numbers (and converts them), but Excel97 converts any text *in a cell* (including numbers) into 0 - so I think there has been a change in behaviour there. - 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 87353] RANK sometimes gives a ran k to text
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87353 Issue #|87353 Summary|RANK sometimes gives a rank to text Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Mar 23 18:07:05 + 2008 --- In A1:A3 we have 0, 1, dog RANK(A3;A1:A3) returns 2 change A1 to 1 and RANK(A3;A1:A3) returns #VALUE! Excel returns #VALUE! in both cases. Happily Calc does *not* change the ranking of other numbers in either case. The text is still ignored, so this is a minor issue. However (probably not relevant but interesting) Excel (97) has very similar odd behaviour with logical values (it includes TRUE only if there is another 1 in the numberlist). Calc always includes logical values. - 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 87268] labels doesn't work in arr ay formulas
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87268
--- Additional comments from [EMAIL PROTECTED] Thu Mar 20 17:15:56 +
2008 ---
With a column headed Result containing {9|4|16}:
{=SQRT('Result')}
will return an array {3|2|4}
The trouble is that if you then add a number onto the end of the column, Result
is a different size, but the output array size of course remains unchanged.
It's horribly messy from a user's viewpoint - are you really *really* sure you
want to attack this? ;)
You might consider simply not allowing labels in array formulae - is that what
Excel does? The whole concept of arrays seems to me to be inelegant and messy
(yes, we can blame 'the other spreadsheet'), so there has to be a realistic
limit on what the user can expect from them.
David
-
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 87268] labels doesn't work in arr ay formulas
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87268 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 87219] ISLOGICAL fails in array f ormula
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87219
Issue #|87219
Summary|ISLOGICAL fails in array formula
Component|Spreadsheet
Version|OOo 2.3.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|drking
--- Additional comments from [EMAIL PROTECTED] Tue Mar 18 23:18:30 +
2008 ---
{=ISLOGICAL({TRUE;cat;dog})} (ie as an array formula) returns
{FALSE;TRUE;TRUE}
In fact ISLOGICAL seems to return FALSE then a sequence of TRUEs when in an
array formula with any size array_parameter.
ref: brief discussion with er on sc-dev mailing list
-
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 86758] Improve categorisation of Calc functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86758 Issue #|86758 Summary|Improve categorisation of Calc functions Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Thu Mar 6 06:18:07 + 2008 --- I raise this for the User Experience team to review, as discussed with Eike and Uwe. Functions are allocated to categories in the Help and in the Function Wizard. I am re-writing the Help in the Wiki: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_l isted_by_category and it is clear that the current categories need revision. For example: 'Spreadsheet' does not describe the contents of that category; some functions appear in different categories in the existing Help and the Function Wizard. There are two candidate models for categories: Excel: http://office.microsoft.com/en-us/excel/CH100645021033.aspx ODFF (not yet stable): http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula I prefer ODFF - with the functions listed on one page in the Wiki it's easy to find what you want, whether or not you know the function name. But this should be a formal decision. Would the User Experience team put this on their list of things to look at please ? Thank you - 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 86658] OFFSET in array expression s
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=86658
Issue #|86658
Summary|OFFSET in array expressions
Component|Spreadsheet
Version|OOo 2.3.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|drking
--- Additional comments from [EMAIL PROTECTED] Mon Mar 3 20:51:30 +
2008 ---
A1 = 6
A2 = 5
A3 = 9
{=OFFSET($A$1;ROW(A1:A3)-1;0)} as an array expression correctly returns
{6|5|9}
But
{=OFFSET($A$1;ROW(A1:A3)-1;0;1;1)} as an array expression returns
{6|#VALUE!|#VALUE!}
The only difference is the inclusion of the row/col size - which default to 1
if omitted.
=
{=ROWS(OFFSET($A$1;0;0;ROW(A1:A3);1))} as an array expression should (I'm
fairly sure) return
{1|2|3} but returns {3}
Excel97 gets it wrong (differently) too.
[yes, this isn't a sensible thing to do ;) - but is a simpler demonstration of
something that stopped me doing what I wanted to.]
-
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 86658] OFFSET in array expression s
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=86658
--- Additional comments from [EMAIL PROTECTED] Tue Mar 4 05:37:52 +
2008 ---
Later thought on the last case:
{=ROWS(OFFSET($A$1;0;0;ROW(A1:A3);1))} may fail at least partly because ROWS is
not array-aware.
eg
{=INDIRECT(AROW(A1:A3))} produces an array result, but
{ROWS( INDIRECT(AROW(A1:A3)) )} does not. Should give {1|1|1} I think.
I don't know if ROWS *should* be able to handle arrays... ODFF does not seem to
list functions that do and don't. By rumour Microsoft have a list of which
functions are array-aware in Excel - but it's well hidden.
-
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 46681] Repeat values of single ar ray vector if used in second array dimension
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=46681
--- Additional comments from [EMAIL PROTECTED] Sun Mar 2 19:54:33 +
2008 ---
In the ODFF draft 28Dec07 page 42 is:
2.2.3.2) If the argument data is 1 column wide the value in the corresponding
row is used to evaluate all columns in the result matrix.
= {1|2} + {10;20|30;40} = {11;21|32;42}
whereas Calc returns {11|32}
Is this the same issue? Meaning it needs flagging for ODFF compliance?
-
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 46681] Repeat values of single ar ray vector if used in second array dimension
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46681 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 77280] ODFF: ISERROR(undefinednam e) results in #NAME! error, should be TRUE ins tead.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77280 --- Additional comments from [EMAIL PROTECTED] Thu Feb 28 16:06:37 + 2008 --- Created an attachment (id=51791) suggested extra test cases for issue 77280 - 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 77280] ODFF: ISERROR(undefinednam e) results in #NAME! error, should be TRUE ins tead.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77280 --- Additional comments from [EMAIL PROTECTED] Thu Feb 28 16:24:33 + 2008 --- ocIf you are the opinion that the TCS is incomplete please feel free to enhance it. This arises because in the course of rewriting the Calc Function help I have come across issues that should have been caught by qa. I don't like raising new issues :( - there are too many already. My suggestions include the core examples already mentioned in this issue, plus some more complex ones. Hope that's useful. - 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 84266] =ISNUMBER(FALSE) returns T RUE; logical values converted to numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84266 --- Additional comments from [EMAIL PROTECTED] Fri Feb 29 01:10:23 + 2008 --- Another case where Calc and Excel do not behave the same: cell A1 0 cell A2 =TRUE() AVERAGE(A1:A2) returns 0.5 in Calc and 0 in Excel Excel ignores logical values in AVERAGE by design. Calc cannot, because it has no distinct type. - 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 77280] ODFF: ISERROR(undefinednam e) results in #NAME! error, should be TRUE ins tead.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77280 --- Additional comments from [EMAIL PROTECTED] Wed Feb 27 09:19:27 + 2008 --- I wonder if it would be useful if the qa test was a little more rigorous? For instance: *the OP's attachment shows an undefined name nested within a function *my own comment about ISERROR(CHOOSE(0;Apple;Orange)) It might be useful to try to break the thing rather than prove it works - 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 86283] DELTA/GESTEP functions wit h non-numeric args are inconsistent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86283 User drking changed the following: What|Old value |New value Summary|DELTA function with non-nu|DELTA/GESTEP functions wit |meric args is inconsistent|h non-numeric args are inc | |onsistent --- Additional comments from [EMAIL PROTECTED] Sun Feb 24 07:42:05 + 2008 --- In addition: =GESTEP(xxx;-2) correctly returns an error, as specified in ODFF, but =GESTEP(A1;-2) where A1 contains xxx (text) returns 1. Presumably the same thing. - 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 86283] DELTA function with non-nu meric args is inconsistent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86283 Issue #|86283 Summary|DELTA function with non-numeric args is inconsistent Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Wed Feb 20 19:25:04 + 2008 --- If cell A1 contains dog (text) and cell B1 contains 0: DELTA(A1;B1) returns 1 DELTA(B1;A1) returns Err:502 OK, this is not the most important issue in the world, but for my money this function ought to trap *any* non-numeric parameter and give an error. The function is mathematical (Kronecker delta), defined just for numbers I believe. In ODFF it seems to be defined just for numbers, but I can't figure out if that means it *must* give an error for non-numbers. DELTA(dog;0) does return an error. - 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 77280] ODFF: ISERROR(undefinednam e) results in #NAME! error, should be TRUE ins tead.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77280 User drking changed the following: What|Old value |New value CC|'pagalmes'|'drking,pagalmes' --- Additional comments from [EMAIL PROTECTED] Tue Feb 12 07:51:10 + 2008 --- Does this also solve: =ISERROR(CHOOSE(0;Apple;Orange)) which in OOo2.3 returns Err:502 rather than TRUE? Many thanks - 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 67777] CHOOSE function cannot ret urn a cell reference
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=6 User drking changed the following: What|Old value |New value CC|'atdsm,muthusuba,nn' |'atdsm,drking,muthusuba,nn | |' --- Additional comments from [EMAIL PROTECTED] Tue Feb 12 07:30:17 + 2008 --- There may be some confusion here? In Calc CHOOSE *will* return a reference: =SUM(CHOOSE(1;B4:B5;B5)) works fine I think the difficulty may be that Calc does not expect a function after the colon in a range: =SUM(b4:indirect(b5)) gives a #NAME? error, even though INDIRECT always returns a reference. Calc seems to be trying to recognise indirect as a named cell. - 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 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 User drking changed the following: What|Old value |New value CC|''|'drking' --- Additional comments from [EMAIL PROTECTED] Tue Jan 29 08:38:33 + 2008 --- I am unable to name a range that includes non-consecutive cells. From issue 25769: Calc doesn't allow a multi-selection to be defined as a name I also lose any ranges that are named when importing from excel. I am able to import ranges from Excel97 to OOo2.3.1 (WinXP). They do not show in the Data-Select Range... dialogue - but they do work in formulae. This even applies to non-contiguous ranges, so having imported an Excel generated file with a non-contiguous range called 'myxlrange' I can do =AREAS(myxlrange) to count the number of non-contiguous ranges. Unfortunately, I can then enter the same name 'myxlrange' in the Data-Define range dialogue, which enables me to select that new range via Data-Select Range... - however any formulae still use the Excel defined range. webweaver64, are you able to confirm that you get this behaviour too? I'm anxious to be sure that this is not just my system. - 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 47740] annoying toolbars behavior
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47740 --- Additional comments from [EMAIL PROTECTED] Mon Jan 28 12:05:18 + 2008 --- You can turn it off. I tried everything, including View-Toolbars in context, but since my post I've upgraded a notch and reinstalled, and it now does turn off. So withdraw my comment. I do still hate the default behaviour - which assumes that the context of a click in a bullet is that of editing (rather than the surely more common navigation or review), but it's apparently not going to change. - 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 25769] Non-contiguous selections don't transport to the 'Define Names' dialog
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25769 --- Additional comments from [EMAIL PROTECTED] Tue Jan 29 06:26:04 + 2008 --- Calc doesn't allow a multi-selection to be defined as a name Yes, I know, but the OP said: Presently, the only way of defining a non-contiguous named range is to enter the range's specification into the 'Assigned to' box manually. which is wrong, isn't it? There isn't a way within Calc. Actually a non-contiguous named range imported from Excel does seem to work, more or less. eg AREAS(mynamedrangefromexcel)1 --- The implementation of the union operator per issue 32341 doesn't change that a multi-selection isn't accepted by the Names Define dialog. That's a shame. I was hoping to reduce the number of outstanding issues. - 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 84922] regex backreference for do uble words does not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84922 --- Additional comments from [EMAIL PROTECTED] Sat Jan 26 08:45:47 + 2008 --- + means match one or more of preceding character - not one or more of () group Sorry, that is nonsense - + can apply to a group. Too early in the morning. But I think the problem is still with that bit of it \(.)+\ \1 \(.)+\ will match everything it can, creating a large number of groups, each one being a single character - which is not what is wanted. - 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 84922] regex backreference for do uble words does not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84922 --- Additional comments from [EMAIL PROTECTED] Sat Jan 26 08:25:05 + 2008 --- Just to be clear: I've assumed the purpose of the regex is to find repeated words. An alternative in the Regex HowTo Tips and tricks: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressio ns_in_Writer#Tips_and_Tricks is: \([^ ]+)[ ]+\1 - 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 84922] regex backreference for do uble words does not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84922 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 25769] Non-contiguous selections don't transport to the 'Define Names' dialog
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25769 User drking changed the following: What|Old value |New value CC|''|'drking' --- Additional comments from [EMAIL PROTECTED] Fri Jan 25 20:31:11 + 2008 --- I believe that up to now Calc has been unable to specify unions between ranges, even by entering the range's specification into the 'Assigned to' box manually. There hasn't been a union operator. However ODFF requires this and it seems to be targetted for OOo3.0 under issue 32341, with the work having already been done. The new union operator would appear to be ~, as ODFF. This issue and issues 25770, 25771 could therefore disappear. Just trying to tie things together; hope that's helpful. - 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 84922] regex backreference for do uble words does not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84922 --- Additional comments from [EMAIL PROTECTED] Sat Jan 26 07:35:27 + 2008 --- I'm not convinced that this is a valid issue. We should leave expressions with ([:space:]) out of it, as this is not a valid regex syntax - it works, but shouldn't, and is a known bug in OOo (see Regex Howto) With \(.)+\ \1 + means match one or more of preceding character - not one or more of () group. If we use \(.+)\ \1 the thing works correctly (yes it does find all 4 the's together, which it should being greedy) Hope to help - 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 84828] Regular expressions with | (pipe / OR) not all evaluated
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84828 User drking changed the following: What|Old value |New value CC|'mike_hall' |'drking,mike_hall' - 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 84168] DCOUNT(..;0;..) counts tex t cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84168 --- Additional comments from [EMAIL PROTECTED] Thu Jan 10 12:55:08 + 2008 --- Excel2003 probably produces #VALUE because it doesn't understand 0 as a parameter? When someone looks at this, it would be useful to know exactly what field=0 is *supposed* to do.. does it count any row which has a number in any column, or any cell containing a number, or ... many thanks - 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 84903] ODFF: DATEVALUE compliance
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84903 --- Additional comments from [EMAIL PROTECTED] Mon Jan 7 16:59:57 + 2008 --- OK - I've evidently misunderstand the aim of ODFF, which is seemingly not that documents can be interchanged between apps, but merely that formulas are the same. No prob now I know, although the Help has to be more wordy: returns a date-time serial number which may be formatted as a date, as opposed to the expected returns a date. - 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 84903] ODFF: DATEVALUE compliance
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84903 Issue #|84903 Summary|ODFF: DATEVALUE compliance Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Fri Dec 28 19:12:42 + 2007 --- @er (sorry to burden you further...) ODFF 15Nov07 says: Syntax: DATEVALUE( Text D ) Returns: Date Calc seems to return the serial number as a number, not a date. This is different from say TODAY and DATE which should and do return the serial number as a date - and which Calc displays automatically as a date. cf EDATE which should and does return a serial number as a number (don't know why, but that's what ODFF says. NB the Calc Help is wrong here, but I'm dealing with that). Just to be clear - the calculation of the serial number is correct - this is purely about the expected display format and ODFF compliance. - 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 84884] Calc: DAYS() not ODFF comp liant
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84884 Issue #|84884 Summary|Calc: DAYS() not ODFF compliant Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Thu Dec 27 16:52:06 + 2007 --- @ er OOo Calc Help: DAYS(Date_2;Date_1) Date_1 is the start date, Date_2 is the end date. ODFF (15Nov07): Syntax: DAYS( DateParam StartDate ; DateParam EndDate ) So Calc has the parameters round the wrong way - but this does not appear on the Calc/ODFF Implementation/Schedule at http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Schedule I've classed this a defect as it will become one when Calc claims to be ODFF compliant in OOo3.0. Don't know what can be done, as many existing spreadsheets will use DAYS already. - 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 84266] =ISNUMBER(FALSE) returns T RUE; logical values converted to numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84266 --- Additional comments from [EMAIL PROTECTED] Mon Dec 10 06:23:11 + 2007 --- Reading the ODFF spec (as at 15Nov07) it seems that this arises because Calc does not have distinct number and logical types. The spec allows a 'level 1' application to return TRUE from ISNUMBER(TRUE) - but the implication is that a level 3 app like Calc should handle this as Excel (if my assumption that level 1 = 'small group' and level 3 = 'large group' is correct - the spec is not clear, at least to me...). - 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 84266] =ISNUMBER(FALSE) returns T RUE; logical values converted to numbers
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84266 User drking changed the following: What|Old value |New value Priority|P4|P3 Summary|logical function =NOT(TRUE|=ISNUMBER(FALSE) returns T |) displays as =NOT(1) |RUE; logical values conver | |ted to numbers --- Additional comments from [EMAIL PROTECTED] Thu Dec 6 16:25:46 + 2007 --- It's worse than I thought: =ISNUMBER(TRUE) displays in the input bar as =ISNUMBER(1), and returns the result TRUE. Similarly =ISLOGICAL(TRUE) returns FALSE. Also =ISNUMBER(A1), where A1 contains TRUE, returns the result TRUE. Excel correctly returns FALSE, because A1 contains a logical value not a number. However =ISLOGICAL(A1) works correctly. As this is now a compatibility issue, I have changed the Summary (was: logical function =NOT(TRUE) displays as =NOT(1) ) and raised priority to P3 - 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 84266] logical function =NOT(TRUE ) displays as =NOT(1)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84266 Issue #|84266 Summary|logical function =NOT(TRUE) displays as =NOT(1) Component|Spreadsheet Version|OOo 2.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Wed Dec 5 14:49:44 + 2007 --- Enter =NOT(TRUE) in a cell. The result is FALSE (correct) but the display in the formula bar is =NOT(1). This is a small matter, but anyone trying this would most likely be trying to learn, and would be confused. Excel correctly displays =NOT(TRUE). Same bug in other logical functions: AND, OR, IF - 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 81686] new formula proposed: last entry
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81686 User drking changed the following: What|Old value |New value CC|'tbe' |'drking,tbe' --- Additional comments from [EMAIL PROTECTED] Wed Dec 5 16:39:54 + 2007 --- With B1:B10, starting at B1, and filling in numbers consecutively: =OFFSET(B1;SUMPRODUCT(ISNUMBER(B1:B10))-1;0) returns the last number filled in. Does that help? There are 2 hidden costs when adding new functions: 1. confuses the user (there are hundreds of functions already for a user to wade through) 2. introduces incompatibilty - so the spreadsheet cannot be exported to say Excel I'd be very cautious about any new function... - 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 84168] DCOUNT(..;0;..) counts tex t cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84168 Issue #|84168 Summary|DCOUNT(..;0;..) counts text cells Component|Spreadsheet Version|OOo 2.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Dec 2 13:10:57 + 2007 --- DCOUNT should only count cells with numbers, same as COUNT A B 1 pet name 2 dog fido 3 cat meow 4 dog rover 5 6 pet name 7 dog DCOUNT(A1:B4;0;A6:B7) returns 1, with not a number in sight although DCOUNT(A1:B4;2;A6:B7) returns 0, correctly The use of 0 here is poorly explained in the Help (I'm re-writing it currently), and it is not compatible with Excel, at least with older versions. But in any event it should only count numbers. - 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 47740] annoying toolbars behavior
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47740 --- Additional comments from [EMAIL PROTECTED] Wed Nov 28 05:41:51 + 2007 --- Even more annoying than not being able to pin this toolbar, is not being able to turn it off. Infuriating, it appears and covers up the text so you can't read what you've written as you try to edit a bullet. - 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 82808] Copy/paste of chart create s nonupdating chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82808 User drking changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 13:16:48 + 2007 --- @kla I believe that regina's point is that she has also found the bug: If you do not use F9 at least one time, it is not updated. So two of us can reproduce it. If you can't reproduce it, it may be specific to some systems? I'm using XP, and have again verified the bug exists. If you decide that this is acceptable behaviour (ie that the chart does not update until F9 or an edit) I shan't fight you ;) but for now I've re-opened the issue for re-consideration. Many thanks. - 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 82808] Copy/paste of chart create s nonupdating chart
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82808 --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 16:14:49 + 2007 --- @kla Thank you - 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 15666] Search and Replace - can't substitute regular expression subexpression i n replace
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=15666 --- Additional comments from [EMAIL PROTECTED] Sat Nov 10 18:35:50 + 2007 --- @er Thank you - that will be useful when explaining the rationale. @gudmund There are close to 40 issues about regex, and they're all treated separately, so no - I'm afraid the other issues you mention are not fixed. The good news is that if OOo migrates to the ICU regex engine, many of the existing issues may be resolved at a stroke. Although (looking at the ICU regex spec) probably not all of them. - 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 15666] Search and Replace - can't substitute regular expression subexpression i n replace
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=15666 User drking changed the following: What|Old value |New value CC|'akrioukov,cheyrich,danm,e|'akrioukov,cheyrich,danm,d |castro,er,gudmund,gurubert|rking,ecastro,er,gudmund,g |,schaber,st' |urubert,schaber,st' --- Additional comments from [EMAIL PROTECTED] Sat Nov 10 07:30:41 + 2007 --- Any volunteers for doing the specification? It looks as if this needs someone who has done one before, and knows what is required. btw note that the 3rd example on page 4 (Detail Spec) should be ([1-9]+) not ([1-9]). I'll volunteer to update the wiki regex HowTo, unless someone beats me to it. But I am very puzzled why $1 - $9 has been chosen, rather than /1 - /9 as in the Search For box. In the HowTo this is going to look silly - along the lines of, well when you want a backref in the Search For you use /1 but in the Replace with box Could someone enlighten me if there's a good reason? Or will $1 - $9 now work in the Search For box as well? Not knocking the effort - it's a good step forward. Thank you. - 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 82473] Regular Expressions that r eplace-all can match the result of the replace
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82473 --- Additional comments from [EMAIL PROTECTED] Wed Nov 7 05:22:59 + 2007 --- What I actually wrote in the regex HowTo http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressio ns_in_Writer was: Please be careful when using the Replace All button. There are a few rare occasions when this will give unexpected results. For example to remove the first character of every paragraph you might 'Search for' ^. and 'Replace with' nothing; clicking 'Replace All' now will wipe out *all* your text, instead of just the first character of each paragraph. Issue 82473 discusses this. The workaround is to 'Find All', then 'Replace'; perhaps the safest way is not to use the 'Replace All' button at all with regular expressions. I'm afraid it does make OOo regex look rather silly... but the point of the HowTo is to describe what regex actually do - because people keep re- discovering all the woes for themselves. At some point someone will have to bite the bullet and tackle the Great Regex Rethink - if that is likely to be soon then work on the existing code might be wasted - so that must influence any decision to work on this issue now. - 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 41706] space class in regular exp ression do not cover tab
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41706 --- Additional comments from [EMAIL PROTECTED] Sun Nov 4 08:37:18 + 2007 --- I'm sorry to disagree, but the 2.3 Help says: [:space:] represents a whitespace character such as space and the implementation does not do that. So it *is* a bug, either with Help or the implementation. Someone needs to do something! How about in Help: [:space:] represents a space character (but not other whitespace characters) as a temporary measure, to inform people who use other regex like in Perl that do it differently. - 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 41706] space class in regular exp ression do not cover tab
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41706 User drking changed the following: What|Old value |New value CC|''|'drking' - 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 83289] Regex: empty Writer table cells not found with ^$
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83289 Issue #|83289 Summary|Regex: empty Writer table cells not found with ^$ Component|Word processor Version|OOo 2.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|programming Assigned to|mru Reported by|drking --- Additional comments from [EMAIL PROTECTED] Sun Nov 4 10:06:56 + 2007 --- From the regex wiki HowTo: ^$ will match an empty paragraph, which can be replaced by say nothing, in order to remove the empty paragraph. Note that ^red$ matches a paragraph with only 'red' in it - replacing this with nothing leaves an empty paragraph - the paragraph marks at either end are not replaced. It may help to regard ^$ on its own as a special syntax, unique to OOo. Unfortunately, because OOo has taken over this syntax, it seems you cannot use ^$ to find empty cells in a table (nor empty Calc cells). We ought to be able to find empty table cells, hence this enhancement request. I guess this might be destined for the Great Regex Rethink when and if that happens. (Note that issue 44688 is about this behaviour in Calc. I raise this as a new issue, because the response to issue 44688 is that the behaviour is by design and otherwise might cause performance troubles - there is no such worry here with Writer table cells.) - 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 44688] Searching with regular exp ression ^$ does not find empty cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44688 --- Additional comments from [EMAIL PROTECTED] Sun Nov 4 10:21:14 + 2007 --- Please note that I've raised issue 83289 about ^$ not finding empty table cells in Writer. I've raised it as a new issue, because the behaviour seems to be by design in Calc. - 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]
