[www-issues] [Issue 92602] wiki and user.services.ope noffice.org offline

2008-08-09 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92602 User terrye changed the following: What|Old value |New value

[www-issues] [Issue 92601] services.openoffice.org no t reachable

2008-08-09 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92601 User terrye changed the following: What|Old value |New value

[www-issues] [Issue 92602] wiki and user.services.ope noffice.org offline

2008-08-08 Thread terrye
general issues Assigned to|[EMAIL PROTECTED] Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Fri Aug 8 15:49:22 + 2008 --- The wiki and user forum servers are both down (192.18.196.109 and 192.18.196.107) nodes are both offline. Our named

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-16 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84979 --- Additional comments from [EMAIL PROTECTED] Wed Jan 16 17:46:53 + 2008 --- I'm not convinced of using the regex engine though (besides that I wouldn't

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-12 Thread terrye
, but until then this one is with you. TerryE - 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

[sw-issues] [Issue 76465] RTF to ODT, then cannot op en ODT

2008-01-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76465 --- Additional comments from [EMAIL PROTECTED] Fri Jan 11 03:00:52 + 2008 --- Created an attachment (id=50796) More Specific Test Case

[sw-issues] [Issue 76465] RTF to ODT, then cannot op en ODT

2008-01-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76465 --- Additional comments from [EMAIL PROTECTED] Fri Jan 11 03:02:10 + 2008 --- Created an attachment (id=50797) Odt version of second test case

[sw-issues] [Issue 76465] RTF to ODT, then cannot op en ODT

2008-01-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76465 --- Additional comments from [EMAIL PROTECTED] Fri Jan 11 03:56:59 + 2008 --- See http://user.services.openoffice.org/en/forum/viewtopic.php?f=5t=1532 for

[sw-issues] [Issue 76465] RTF to ODT, then cannot op en ODT

2008-01-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76465 User terrye changed the following: What|Old value |New value

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-09 Thread terrye
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] Wed Jan 9 15:40:22 + 2008 --- Eike, I could give you a diff file for this, but I don't have a CVS acct to give

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-09 Thread terrye
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] Wed Jan 9 22:22:31 + 2008 --- Created an attachment (id=50766) Ditto + 3 extra sheets givien 30E/360 test

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-09 Thread terrye
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] Wed Jan 9 22:39:59 + 2008 --- However, to produce a cvs diff -pu you don't need a CVS account, anoncvs does

[www-issues] [Issue 85096] SSH2 key for Terry Ellison

2008-01-08 Thread terrye
to|[EMAIL PROTECTED] Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 05:43:06 + 2008 --- Could I please have CVS access for me with the attached key. I have signed the JCA. I only need read access to the repository at this stage. kpalagin's

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-07 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84979 --- Additional comments from [EMAIL PROTECTED] Tue Jan 8 02:36:55 + 2008 --- Having spent 30 mins running through various test cases the Excel validation

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-07 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84979 --- Additional comments from [EMAIL PROTECTED] Tue Jan 8 02:54:54 + 2008 --- Sorry there is an extraneous space in the last regexp above -- a typo. Also I

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-06 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84979 --- Additional comments from [EMAIL PROTECTED] Sun Jan 6 16:08:45 + 2008 --- The enum convention (address.hxx:255) defines 5 types (CONV_OOO, CONV_XL_A1,

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-06 Thread terrye
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] Sun Jan 6 18:51:26 + 2008 --- Here's the patch which makes Calc 100% compatible with Excel on this one:

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-06 Thread terrye
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] Mon Jan 7 00:09:52 + 2008 --- Already signed the JPA, as this isn't my first fix. I'll submit the patch. One

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-03 Thread terrye
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 Jan 3 14:04:23 + 2008 --- Created an attachment (id=50643) Version 2 of test cases

[sc-issues] [Issue 84934] ODFF: DAYS360 compliance

2008-01-03 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84934 User terrye changed the following: What|Old value |New value

[sc-issues] [Issue 84979] Logic flaw in Create Names range checking

2008-01-03 Thread terrye
Assigned to|spreadsheet Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Fri Jan 4 04:41:03 + 2008 --- http://user.services.openoffice.org/en/forum/viewtopic.php?f=33t=1343 refers Insert-Names-Create calls ScAddress::Parse in sc/source/core/tool

[sc-issues] [Issue 84934] Bug in DAYS360 Algo

2008-01-02 Thread terrye
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] Wed Jan 2 15:27:10 + 2008 --- Having read the documentation and looked at the test data again, I feel that Calc

[sc-issues] [Issue 84934] Bug in DAYS360 Algo

2008-01-01 Thread terrye
to|spreadsheet Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Wed Jan 2 01:17:00 + 2008 --- Mail Reader Message Refers: http://www.openoffice.org/servlets/ReadMsg?list=devmsgNo=21247 User Forum Message Refers: http://user.services.openoffice.org/en/forum

[sc-issues] [Issue 84934] Bug in DAYS360 Algo

2008-01-01 Thread terrye
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] Wed Jan 2 01:18:19 + 2008 --- Created an attachment (id=50619) Spreadsheet showing bug and Basic for correct

[graphics-issues] [Issue 84927] Impress Animation time out

2007-12-31 Thread terrye
to|cgu Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Tue Jan 1 02:20:15 + 2008 --- Reported by usOOo user PSpeak. See http://user.services.openoffice.org/en/forum/viewtopic.php?f=10t=1065 Verified by TerryE. See Attached ODP for test case

[graphics-issues] [Issue 84927] Impress Animation time out

2007-12-31 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84927 --- Additional comments from [EMAIL PROTECTED] Tue Jan 1 02:21:12 + 2008 --- Created an attachment (id=50612) Test Case to show bug

[graphics-issues] [Issue 84927] Impress Animation time out

2007-12-31 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84927 --- Additional comments from [EMAIL PROTECTED] Tue Jan 1 02:46:51 + 2008 --- Sorry on further checking, I suspect that this is a duplicate of Issue 54019 --

[api-issues] [Issue 62081] Userdefined function doesn 't work anymore after it appears as pure text in the spreadsheet

2007-12-22 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62081 --- Additional comments from [EMAIL PROTECTED] Sun Dec 23 01:41:25 + 2007 --- By the way, this is particularly a pitfall because (unlike Excel) this automagic

[sc-issues] [Issue 76137] cannot access two dimensio nnal array

2007-12-17 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76137 --- Additional comments from [EMAIL PROTECTED] Mon Dec 17 19:43:21 + 2007 --- This isn't a bug. It's a feature by design. The getDataArray method returns a

[sc-issues] [Issue 76137] cannot access two dimensio nnal array

2007-12-17 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76137 --- Additional comments from [EMAIL PROTECTED] Mon Dec 17 19:44:16 + 2007 --- This isn't a bug. It's a feature by design. The getDataArray method returns a

[sc-issues] [Issue 82501] Cell Names Lost When Copyi ng Work Sheets

2007-12-17 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82501 --- Additional comments from [EMAIL PROTECTED] Mon Dec 17 20:01:08 + 2007 --- I was just scanning the lists and came acoss this one. Isn't this just how Calc

[www-issues] [Issue 81568] access to user.services.op enoffice.org

2007-09-26 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81568 --- Additional comments from [EMAIL PROTECTED] Wed Sep 26 19:31:03 + 2007 --- No I am in on my user account. I had to unlock it. Wonders of Solaris. Gerd,

[www-issues] [Issue 81568] access to user.services.op enoffice.org

2007-09-18 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81568 --- Additional comments from [EMAIL PROTECTED] Tue Sep 18 12:55:26 + 2007 --- In on root. Bounced on terrye. Will work out why after OOoCon. Thks. Terry

[tools-issues] [Issue 70256] Using Solver: obtaining / maintaining logfiles of reference build

2007-09-14 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70256 User terrye changed the following: What|Old value |New value

[www-issues] [Issue 81568] access to user.services.op enoffice.org

2007-09-13 Thread terrye
issues Assigned to|ssh2key Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Fri Sep 14 02:13:58 + 2007 --- SSH2 access to the new box set up as user.services.openoffice.org as agreed with Clayton. Thanks

[www-issues] [Issue 81568] access to user.services.op enoffice.org

2007-09-13 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81568 --- Additional comments from [EMAIL PROTECTED] Fri Sep 14 02:15:13 + 2007 --- Created an attachment (id=48225) TerryE public key

[sc-issues] [Issue 63500] Calc ought to use shared s trings for cells

2007-06-02 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63500 --- Additional comments from [EMAIL PROTECTED] Sun Jun 3 00:19:47 + 2007 --- A general Q here as I haven't trawled through the Calc code yet. How do you

[api-issues] [Issue 73457] Memory Leak in all Basic t ype void Method calls

2007-05-05 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 --- Additional comments from [EMAIL PROTECTED] Sun May 6 00:48:57 + 2007 --- I've done quite a lot of work on the analysis here, but it's the old problem --

[api-issues] [Issue 73457] Memory Leak in all Basic t ype void Method calls

2007-02-21 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 User terrye changed the following: What|Old value |New value

[sc-issues] [Issue 74556] Link External data needs g raphical user interface

2007-02-15 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74556 --- Additional comments from [EMAIL PROTECTED] Thu Feb 15 10:57:18 + 2007 --- Functionally the issue here is that the import routine lists the tables in the

[api-issues] [Issue 73457] Memory Leak in all Basic t ype void Method calls

2007-02-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 User terrye changed the following: What|Old value |New value

[api-issues] [Issue 73457] Memory Leak in all Basic t ype void Method calls

2007-02-10 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 --- Additional comments from [EMAIL PROTECTED] Sat Feb 10 12:54:32 + 2007 --- By the way, the diff header line should read @@ -2057,7 +2057,7 @@ I removed a

[framework-issues] [Issue 73511] Mismatch between Rnd / Ran domize Help and implementation

2007-02-08 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73511 --- Additional comments from [EMAIL PROTECTED] Thu Feb 8 15:33:44 + 2007 --- Andreas, one side effect of tracking down issue 73457 is that I now really

[api-issues] [Issue 73457] Memory Leak in Basic Argum ent Handling

2007-02-02 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 --- Additional comments from [EMAIL PROTECTED] Fri Feb 2 13:35:13 + 2007 --- Almost there. This one has taken more effort to get to the bottom of than I

[api-issues] [Issue 73457] Memory Leak in Basic Argum ent Handling

2007-01-28 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 --- Additional comments from [EMAIL PROTECTED] Sun Jan 28 13:24:24 -0800 2007 --- If A is a subroutine, then the method call A(0) generates the Pcode statements

[framework-issues] [Issue 73511] Mismatch between Rnd / Ran domize Help and implementation

2007-01-17 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73511 --- Additional comments from [EMAIL PROTECTED] Wed Jan 17 18:20:20 -0800 2007 --- Thinking about this, going for full functional equivalence of the VBA rnd function

[api-issues] [Issue 73457] Memory Leak in Basic Argum ent Handling

2007-01-17 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 --- Additional comments from [EMAIL PROTECTED] Wed Jan 17 18:16:28 -0800 2007 --- I've created a comparison test case, and hooked in the Ref Class series

[framework-issues] [Issue 73511] Mismatch between Rnd / Ran domize Help and implementation

2007-01-16 Thread terrye
Subcomponent|scripting Assigned to|kr Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Tue Jan 16 03:10:49 -0800 2007 --- Sorry but another one thrown up by answering an oooforum topic: http://www.oooforum.org/forum/viewtopic.phtml?t

[api-issues] [Issue 69930] Functions allowed as LVALU ES in Basic

2007-01-15 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69930 --- Additional comments from [EMAIL PROTECTED] Mon Jan 15 01:28:24 -0800 2007 --- Andreas, I've checked the source. SbiRuntime::StepSTMNT even contains an explicit

[api-issues] [Issue 69930] Functions allowed as LVALU ES in Basic

2007-01-15 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69930 --- Additional comments from [EMAIL PROTECTED] Mon Jan 15 01:28:48 -0800 2007 --- Andreas, I've checked the source. SbiRuntime::StepSTMNT even contains an explicit

[tools-issues] [Issue 70256] Using Solver: obtaining / maintaining logfiles of reference build

2007-01-14 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70256 --- Additional comments from [EMAIL PROTECTED] Sun Jan 14 04:12:28 -0800 2007 --- @vg: Thanks for your constructive comment. I am now getting a better handle on

[api-issues] [Issue 73457] Memory Leak in Basic Argum ent Handling

2007-01-14 Thread terrye
Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Sun Jan 14 05:46:06 -0800 2007 --- Every basic subroutine call leaks approximately 216+24N bytes of memory where N is the number of arguments in the call *IF* N0. The following code fragment demonstrates

[api-issues] [Issue 73457] Memory Leak in Basic Argum ent Handling

2007-01-14 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73457 User terrye changed the following: What|Old value |New value

[tools-issues] [Issue 70256] Using Solver: obtaining / maintaining logfiles of reference build

2006-12-31 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70256 --- Additional comments from [EMAIL PROTECTED] Sun Dec 31 14:42:51 -0800 2006 --- Nonetheless for the solver builds to be usable you need to know the context that

[sc-issues] [Issue 67774] Odd handling of DataArray pseudoProprty

2006-12-19 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67774 --- Additional comments from [EMAIL PROTECTED] Tue Dec 19 14:59:51 -0800 2006 --- The subroutine Sub assign(s,d) d.DataArray = s.DataArray End Sub

[api-issues] [Issue 69930] Functions allowed as LVALU ES in Basic

2006-12-19 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69930 --- Additional comments from [EMAIL PROTECTED] Tue Dec 19 15:10:40 -0800 2006 --- Having had a look at the compiler output, the code generator generate the same

[tools-issues] [Issue 70256] Using Solver: obtaining / maintaining logfiles of reference build

2006-10-10 Thread terrye
Priority|P3 Subcomponent|configure Assigned to|rene Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Tue Oct 10 01:32:58 -0700 2006 --- I want to use the OOC680_m7 reference source and solver to rebuild OOo after minor tweaks to one

[framework-issues] [Issue 58089] oo Basic: static variables looses content

2006-09-28 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58089 --- Additional comments from [EMAIL PROTECTED] Thu Sep 28 00:09:58 -0700 2006 --- Andreas, This isn't how declarations work in VBA. In VBA joerg's comments would

[api-issues] [Issue 69930] Functions allowed as LVALU ES in Basic

2006-09-28 Thread terrye
Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Thu Sep 28 00:35:00 -0700 2006 --- In OO Basic functions are tolerated as Lvalues (This is not the case in VBA). Sub main() b = 1 MsgBox b End Sub Function b() b = 3 End Function This prints out 3

[api-issues] [Issue 69252] Inconsistent handling of B asic With Statements

2006-09-04 Thread terrye
to|ab Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Mon Sep 4 18:13:22 -0700 2006 --- Another incompatibity between VBA and OOoBasic FYI: i=1 With ThisComponent.Sheets(i) ' or ActiveWorkbook.Sheet(i) in VBA MsgBox .Name i = 2 MsgBox .Name End

[api-issues] [Issue 68059] Basic Option Compatible + opt args bug

2006-09-04 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68059 --- Additional comments from [EMAIL PROTECTED] Mon Sep 4 18:25:18 -0700 2006 --- Andreas, ignore the comment about ParamArray -- I didn't have Option Compatible

[api-issues] [Issue 68059] Basic Option Compatible + opt args bug

2006-08-25 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68059 --- Additional comments from [EMAIL PROTECTED] Fri Aug 25 10:15:06 -0700 2006 --- Actually the ability to drop earlier parameters is something that people do do

[sc-issues] [Issue 30215] Further thoughts on row li mits

2006-08-23 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30215 --- Additional comments from [EMAIL PROTECTED] Wed Aug 23 05:48:39 -0700 2006 --- This came up on an OOoForum debate, where a newbie was asking why charting only

[sc-issues] [Issue 67774] Odd handling of DataArray pseudoProprty

2006-08-20 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67774 User terrye changed the following: What|Old value |New value

[sc-issues] [Issue 67774] Odd handling of DataArray pseudoProprty

2006-08-20 Thread terrye
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67774 User terrye changed the following: What|Old value |New value

[api-issues] [Issue 68059] Basic Option Compatible + opt args bug

2006-08-01 Thread terrye
to|jsc Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Tue Aug 1 18:01:35 -0700 2006 --- Options Compatible + Optional Arguments still don't work properly. (1) ParamArray is Still not supported (2) IsMissing gets confused if there arePositional Args

[sc-issues] [Issue 67774] Odd handling of DataArray pseudoProprty

2006-07-25 Thread terrye
Assigned to|spreadsheet Reported by|terrye --- Additional comments from [EMAIL PROTECTED] Tue Jul 25 15:13:04 -0700 2006 --- I wrote a macro which included the use of DataArray access to convert columns containing formulas to their literal equivalent (as in copy/paste value