Michael C. Toren on 29 Nov 2005 15:43:39 -0000

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: Open Office vs. ms word

On Tue, Nov 29, 2005 at 08:36:55AM -0500, edack@kengel.com wrote:
> Well, I use OO 2.0 [...]

Speaking of OO 2.0, after upgrading recently I was rather frustrated to
learn that a number of spreadsheet formulas I had written for OO 1.1 no
longer worked.  I was able to narrow it down to the following builtin
function now behaving differently than in the previous version:

	=ADDRESS(1; 1; 1; "sheet1")

In 1.1, this would return "sheet1.$A.$1".  In 2.0, this now returns an
error of "Invalid Argument".  As far as I can tell the documentation for
the ADDRESS function has not changed.  Am I mistaken, or is anyone aware
of a workaround?


perl -e'$u="\4\5\6";sub H{8*($_[1]%79)+($_[0]%8)}sub G{vec$u,H(@_),1}sub S{vec
($n,H(@_),1)=$_[2]}$_=q^{P`clear`;for$iX){PG($iY)?"O":" "forX8);P"\n"}for$iX){
forX8){$c=scalar grep{G@$_}[$i-1Y-1Z-1YZ-1Y+1ZY-1ZY+1Z+1Y-1Z+1YZ+1Y+1];S$iY,G(
/,\$_/xg;s/X/(0..7/g;s/P/print+/g;eval' #     Michael C. Toren <mct@toren.net>

bclug.org mailing list
This message was sent to historian@netisland.net