[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.

[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

[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

[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

[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

[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

[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:

[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

[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

[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,

[sc-issues] [Issue 94406] range operator ':' not ful ly compatible with Excel

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

[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

[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

[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

[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

[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 ;)

[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

[sc-issues] [Issue 93534] PRICEDISC et al.: Basis 0 NASD implementation

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

[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

[sc-issues] [Issue 93527] INTRATE and RECEIVED funct ions different to Excel

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

[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

[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

[sc-issues] [Issue 92177] ODDFPRICE, ODDFYIELD, ODDL PRICE, ODDLYIELD all faulty

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

[sc-issues] [Issue 91870] PMT function with extremel y small rates - #VALUE!

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

[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 ;)

[sc-issues] [Issue 91651] VDB function: Calc and Exc el produce different results; both wrong

|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

[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

[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

[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]

[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

[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

[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)

[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

[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

[sc-issues] [Issue 90759] ZTEST not same as Excel

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

[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

[sc-issues] [Issue 90628] LOOKUP: forced array param eters, as in ODFF Excel

|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

[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

[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

[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!

[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

[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

[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

[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

[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

[sc-issues] [Issue 89047] Regular expressions in fun ction: recalculation

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

[sc-issues] [Issue 88967] PROB, FORECAST functions: scalar evaluation of array parameter

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

[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

[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

[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

[sc-issues] [Issue 88052] COMBINA function Help text is incorrect

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

[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

[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

[sc-issues] [Issue 87855] ODFF: VARA and STDEVA with text arguments - error

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

[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

[sc-issues] [Issue 87353] RANK sometimes gives a ran k to text

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

[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

[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

[sc-issues] [Issue 87219] ISLOGICAL fails in array f ormula

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

[sc-issues] [Issue 86758] Improve categorisation of Calc functions

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

[sc-issues] [Issue 86658] OFFSET in array expression s

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

[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

[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

[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

[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

[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

[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

[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

[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

[sc-issues] [Issue 86283] DELTA function with non-nu meric args is inconsistent

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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[sc-issues] [Issue 84903] ODFF: DATEVALUE compliance

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

[sc-issues] [Issue 84884] Calc: DAYS() not ODFF comp liant

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

[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

[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

[sc-issues] [Issue 84266] logical function =NOT(TRUE ) displays as =NOT(1)

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

[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

[sc-issues] [Issue 84168] DCOUNT(..;0;..) counts tex t cells

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

[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

[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

[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

[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

[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

[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

[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

[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

[sw-issues] [Issue 83289] Regex: empty Writer table cells not found with ^$

|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

[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

  1   2   >