Re: Open Office vs. ms word

["Michael C. Toren" <mct@toren.net>]

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?

Thanks,
-mct

-- 
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(
$iY)?$c=~/[23]/?1:0:$c==3?1:0}}$u=$n;select$M,$C,$T,.2;redo}^;s/Z/],[\$i/g;s/Y
/,\$_/xg;s/X/(0..7/g;s/P/print+/g;eval' #     Michael C. Toren <mct@toren.net>

_______________________________________________
bclug.org mailing list
bclug.org@lists.sitelink.com
http://lists.sitelink.com/mailman/listinfo/bclug.org
This message was sent to historian@netisland.net