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

Bug#414962: openoffice.org-calc: formula will not evaluate between multiple worksheets; #NAME? =max(w1.b2,w2.b2)



Package: openoffice.org-calc
Version: 2.0.4.dfsg.2-5
Severity: normal

Included (uuencoded) is a sample OO calc document.  On the "Losses"
worksheet, cell B2 only shows #NAME?, not the expected result.  I've
tried various work arounds, but something short of a few less worksheets
doesn't seem to address it.  If this is my doing, let me know what I've
done wrong. :)  Thanks!

-- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (900, 'testing'), (800, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686-bigmem
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages openoffice.org-calc depends on:
ii  libc6                     2.3.6.ds1-11   GNU C Library: Shared libraries
ii  libgcc1                   1:4.1.1-21     GCC support library
ii  libstdc++6                4.1.1-21       The GNU Standard C++ Library v3
ii  libstlport4.6c2           4.6.2-3        STLport C++ class library
ii  libufsparse               1.2-7          collection of libraries for comput
ii  openoffice.org-core       2.0.4.dfsg.2-5 OpenOffice.org office suite archit

openoffice.org-calc recommends no packages.

-- no debconf information

*** bts-sample.ods.gz.uue
begin 644 bts-sample.ods.gz
M'XL("'O1^$4``V)T<RUS86UP;&4N;V1S`)59!SA<R_L67:+W&B4(@M5[B1J=
M*-'+8K'*KMA=HH1$@A`MB!`UHD>T$)U$B=Z#("R6:-%;]!]R<V_DGWN?_,\\
ML\_9F>]]YSMGSOG.O//IJ&-@DJ.='JWL4)$`9_$0WI/STXI[4EW`+B"XIRL(
MZ.KJ#+8!PL%0",`=8LL+!<+`,%ZH*PAB"[5!N(`@<%Z8JQL(:`MS`('@.N<X
MT7XZ:$^J`A1B![9'N)VQP00`,#@0CH!9`]T`WW&X)^57W-7?X(`V-B!GT,E?
MJ!O`!N'F=NK$'1=G##0==9Q3W]'0_P+_NSO4OZ&U<X8"X:`?SOSI1;A"71&N
M)_<!\1\X^M_AW*#V;B#83Y?_IWZ>#O;_1\&A4.?_1C'^!@5V`=J#8`!Y,-P%
MZ`K[CWFZ=%)MH!#X7W.Q9/P>@A(AKMFYAD_!,9(6DR8&=AEP+^P4"6*QX'X.
M*;K>@\$3YNS.ILO$>>UH/RJ-52\\J052?=6<G&@W<$/,1T&W;?H+IR:VTX0_
MGP3"9Z>>!HW`6''.;<%G;Y$P+#%A6)2,LIGU(9,U,!G]*8>M?FX=QHRFDI57
MEE87^%TA$TNJ&!9)"Y\53<_(M<)>.9KV$MP*58FJ9U:CIO717Q?RBG@LJ^<N
M5V".CI,T*QG:AQFHEH[9#`[LJK)RV'$M@@/9AH%K,<1[H(6\]`[T[FLA]3R!
MO"CU;L:(9HOA46)".K/8C71%I1<X>'-6]1OFR%=%G"J?GZ9\&(EQ2.:]YZ%%
M$/MM.#=DJ_@-RV`[1@Z>89S'H#(>!+#"MU!;W="RK5EDQF`4_434,&G&QK=N
M`%V[ZD/?IUNY\EK%7?U"#J,I_(,Z`X29U]4KGU%1&287\<#76*HG%-'+)B8?
MKQ)?!4;?CEU6?UZ_FRS/9.04+U(_%$R,0\\KW3]V3PGN.M>]L1_DBL4Y[M^Z
M:*68'1FWT*%O:N+$F#20D*E:OOH\T,@EF>,#<RINO6('N_*!YL:[3UXD65W>
MWZB.DX@N\U$\,%6^DHK.8I\J9"F9SCJLD;3B^J&QP+LWLYVFI-X!4()Y,3%[
MBP2+)"V@Y1'^4_^A.+*:)?%Q/*'#LMD*$M*^H4=>0:3FI2@S`8-45L49L<Z+
M,=V#)?)?1-_GXL5DW1N!1DEE:"V!1=-"KR7!5*_C6U-RBTT`'"ZHA3E>9ZB\
M7.1/Q=KGW10@26MI06:B]6X*%D<OJQC^QCHHWK$(',\[5HY>;*;*,,:X6QMR
M)#!CAF8=S\JI%;G$ZTDX%JQ>G7)G+"X7A2;6MDJJPU-`/1O\.?ZI\!68R`U%
M6[QQ?9_<WDW?="V+F&*5L!A75JKN'"^<C)L(;J.2X5AXI@!Y,,6]1$V-N77C
M7KY$6:ZFW'*M`:/PH#S,N"^A9+FDU"C%>_VT>5']EW=TGQIDKZ>_3D6_W8*F
MKF,Z5JBLR([@>,@JM\V!T*IQUR_-\Y9W?+U4J(?R[$YX7D-\59RIHC7F3:39
M5?G[6UO7$@[OSS>^\GW%*'DE4>0+`[<%??]H/&H^>KG^"Y!AKUES[>E,-7P[
M((PL$%1U0ZYY^9N7>H90A$;8F)O11,I#KAZ+\9IJ[80IWS63>FGMAY,B]:L^
MH+6LVMPO3'OK<^TO-Y8++(W6%6L0B\\RK?:,N%H/E]93&!E?M3\4J4S!'')<
M1!;W#8X6598:CUUN<!1ROS&XJ_]\]EJC-_L>R]?'JWXM2:2>.$P:#")LP^8K
M#==VVB1@,5N9)9"RDG"N!B?DX?`(?0PBEB613*U/:LFIL.!]P3ZM$+VI?8I`
M%ZQ1W^#3JRK#'4.#LN/'3C5<X$7NO<&R+(NQFDKMNNP.Y-VCHZ):S+G'_=H1
MG35F";)?!WR4,I<%V'-+CI>"/#:0T+<:87?)#5>VHK+K<,MJMP;#OCBYNBP=
MF?IL,YX&=RR7)0(]3#0T0\8?P?UWL>CB287!/9U!L--0-&:$A(Z*$/LB+9DY
M%'K1H]F&M<BJBC8*K3\U2)`O57HHI]GFDW-&QC"L%""?D(-:B\EY%GL0A)&*
MTQZRW\;6EJ>K]IO]O;RY62>=4<UO6G;XU.^H&=6NR1YNZ[DN(J%U52AC9=)J
M+4]=BKB<Z[E7FOHP@.Q#[C"4H?]K\2C%?!JN0K-7MIWJ'8D]E6$6='KN31P)
M7)!W+N``Q@%]8-A22UK0?"Q!.4_217@<5U[1.["I%$HO@)&-0.`R:S7'$Q9[
M"RG=>AGH09+NC`0^45##U\*XVT^"UAQ++W9"4*Y]$VUJ.@_4HHGU\L):^9*;
M7C10&KW(.0([C[+=HB`RTLC$YOSX./?S;+2@=0J13O37R+A$.NS/!"LL29?'
ME49B>2)'"!JG17QP$KX,55EJ53"%Y+P5>JM@P*(BOAM'.18[FRB:[WC!6RZL
M:H/#)'"[(D`FM)[(GX/;9-66/)GIN5#HQA0I^-YCA>N8=PKZ/^XLD/9QFIH:
MOA0@W.)4P"/43=2IJ'E3,<#MO6T,*UE#3LGVK#S=(>&?/VPQ#HEOS%F14Q._
M[]^#^N!W7XT7::8XRH-<C.O5E0NGH<0,!Q`IMA&FL7+=QQR^(@<W6&NP+Z?Q
M\Y2-T)V<XKS1P)RVB!BE^WQ?-_%%R"!#`SB_1IA"6(4OH_9!2JR_[O5:7*74
M;C$#/$YB9QT^+M&C`T738,PV+"Z/NYP]N!\\:=(5N1KA+T/LAAXF/408SK7'
MH\+L5#\,D1=5RXM;\0E>PBN((W5]J\UX"%.Z8*;5J)P&GM#*4'!J<L\:7!+A
M->Y!1$XUMXK0^B#5WF"YPS\"'L*\[:_=-5^5Y'_;<9@+L,.9'M#&`EX`7IQE
M>A:5R('KX(QOWC,\I\+%;"4C;B%`<:-]YXED4[+>'$YEQ;6;P&-_?YNU=SD;
MF70W@ER:W/;OHC[%A]S?V(I&'$Q#1*FJN3HW0?10DC[I?7VU@Q?<HJUJXB7S
MK[@?3[QT&9`0=J<3BNU$B7:DLJ5>!T5/<;.UE81+IU'X[BXHY8\[/Y^6`ZDZ
MR3S0<@M3;%#;MED=M*#V*]\,:*AG+*1_MO5\?4AC1FYH6>6;YG!V$#2-F"VX
MW_X=A3[!!=05=^I63E4<)IRHA6`<@Q`BI@5;0>7.8U]4PX5H'QPR_&GYD5QA
M;3ZGUGC9QTF\15[H2P'>W+RR-NG(R%H-*V6)Y!?$Z-%OKJ^KS8T_?7(CRVR"
M](HFNQD6]B;HD=J!HC9FF[::J"^Z/U\>P=MZ=O66%"M)7W,N/P[8D3&?DS+*
M_N9"/7^`[GN*/D/9>UX98Y9*=Z\VO%'-]/W82O!`6M5_^9'>@I9:[Q/#7%AF
M\:/#2W&UVEZVV,</_+.8E)52+VLQ#[^?U+I;^";V-F&OY.-GO.%5$MB]SK65
MM<SN0IR1+<"(*8T5.)52V$J^C&O&ILKESK2!I;YPC<E"PU))RP:]N!7>RF$$
MY]>FJ7GBKF-[YH_>1&;I>X?TE%3M0P\],XN]#9_L4JL$Z^XS$%NE)7S"2YM^
M`RG@1LP<<`5O:BOH7KK0*=E<$SK/\&U4)>>8UT4[ZXZ84=U"&'JK<H!4F+K=
M32=:.H>1LC3+[;R=4<F-)E/CXZ>2H3QWO/W\_*B2`8/79FAP[->&7L`/$U2H
M22-J"!URP'EU0S=R&$N&W*-&/W19.+V>]=<;F/3Y&%!X`Z77X?N.C>IE8Y=W
M8Z4JTQ"/YOZ&:,6VA4DB2\A;YNU=@XB@\(RNJ`HE^T%@8?T#04H-"`$''TRL
MXYNKD[\#2>/J."E/_9V<NH.*G)J>=TM$R3#JZI3NH:%V1+5C8FV,M/EQK8F:
M)Y#.83ST[2L#.H>AHXR/EP#(K=5UT?W1NK-E=QOIJV?66&AH--2_+KM=EQZ8
MY&"@H9W6,V4!@@-/X[*4[,D/DSO(#7:RU)1FX>?E8V$"06R@MF"(O32+@;XR
MCQB+K,Q%*:B='=@&)/%#;O"<XIE.H!"8Q/<N:1:$&T3B3)A(0(`N()@$W$;B
M9X4B\;.UQ-E`WUON.(,A3M(L#G"XJP0`X.'AP>LAR`MULP?PBXN+`\YZ?YC:
MVOQMYXIP<SZSLK4!G.B0TQ%@`'Y>?L`/VU,/_]2I4]N?78)"H7\/=&K^W>FS
MX03X^(0`W_^S,/UU,>=NG\R/>W5**B-U1FT/@GQ72C+:)VS:/['Q\K%J@"&(
M.TSG.RQ/A(DCR`8.$!'C<Q%FE4>`G6UYQ/E$!:4`OQ!^'\#F1/R=B@4>VQ/Q
M)'/BHR@/GR`/OY"^@("$D+@$O\A?N/-V4K8V$K\!"`M)\(M+`7YTGEHY`R'V
MB!,1(@."\!CHG?7]W?3=`Y`M&'[RS/#8>-J<?/)E!/X:\)?F\[:V?TD<&1U]
M84U!O5\@?_=^!R%@(#<>6Y`=&`*R93IK.9U1:195B!V4B9\%\"=F`G]F)OAG
M9D)_F_W]6IR*:3`,#K;Y;@P'6CN#>&R@"`A<FD64Y7OCB6QV_M$F>,8!./?$
M`'[WKLG\^T+K5&?J.R!<K"%`L#,,`/]QRNL*L5_$7X7-SD1-65M936QMNN*A
M]V5<K[[W@$"%]J[A+2LKJ]O;\-OX.7$;VX$URBXU'6L12,9UAMNXN@*)/;W%
M8/E&<K;.*YQJVH=54>CP1*&*I(_I!-)=<'H#58+-]:F+&OQQWDCWW:JR=F1!
M@??>0=?"XHJ?HQ!5F1]2?,4[;,QGZ6K5((.TSYQ.=&G\\)LK2MVU/L,"WB,E
M)6_LNP.Q,*7$&*GH3/?V=U:FN3QO++]LDM5*_IK'RZDJ[G?D8Z2O/]B=(ELP
M5LZ\IG#4',$H^NW;M^5$B1D#\YM%DW,WAY;H1,SF!BF$+*D<H/99-D[>.V-5
M'DZ#!;*,-`R=YF[]#4,>BXW!_O/"PA[PK<W:X7T5-;7GPY^J>WN'9)-]H]HG
MNUA>U=K"8!M@03N5KQ2F->[O<PVROKU$QR!K:FHZUHP-6507*:;T9MW<0M9Y
MEVYMC0(LJK/])+;E$?"+Q_NB4*\N\,+B!E5&(_W-SO6-1;*WHVZLN^U^6:'3
MTPVE`P,)?H>Y4['/=@U)X(_,BZ6D#[^5@/L7\KG89V93RDK+D$?3JFW'*^VQ
M.3,W?.]:&IGY["Z6=1QT%?BL$0T`H"/5N\>S=<M@$!N;:+*,N0E@\':@Z**Q
M9WNUY\8@M[';],<</?L\A%I;.U36I]SU>*MF?_M0P.]HT*L.ZKZ],!$9>76V
M*Z7N<'$H_\ULUV&NQ=X!JOEQT`C%,5)01&300-]G+ODR%>-*\O)Z:.?FF]+H
MPD)78^-A06-^!I>E?M#,C--0OG25R^C;Q(>8`=K)=>H#1"FR*Y86YG>K<G,=
MM>>>I*:F*BTJ-#3X67:W=8WO2T].#I`Y?_VZ)=Z=+&4LX#%>71G?9]A5/9M-
MWM'=/30P)'N\,/`J,324S&!@`":+.1X1%GKPZ7AE?,><L1@YO)A\[&#K^'QA
M?GY7>ZXY2SLB'%GC5R<EP:7&[K?0C'C=OV3?G;A[>QQ[M^)I1D8.&9O'\N==
MP.C:UY3:>PL+R'Z,Y4/OW?6!5_GE!Z&AX1$5?AX8&4M+I.SYAL+"PEO[+XZ`
M=H<^<JD*$A:C[9=6N:=T33+XU'HBC`I3@'N&/&OR14'Y[W0#WO</=(.2].3)
MSKZFR%O#`^(GWTL?S/_2.?BG.@<$/PU99TIG*<%<;TJ"NGFE.\O*RUN9<VZJ
MGD,2B^H]1=-ZE[G#E>E(]C'6C(_:?KH7)4URK#D%9\4F`]^J'G7W5Q^LC[0S
M7L.9C8V\K=CZ]);80"D]*V4I2;PY^-`"-5VU_7)OB.VNESQEWJ>/Z_0JC7A!
M\BT<4E>CR2R"_0N$(IY<Q*)?NWB!<)H":)!]J57$>`;TM6W$:-,V@,38#`QC
M_JPFL[)_E./GKC;,;<GQK'T7,2>2J]1*]GS)B2ODL(\\8S/B!9_<=,>(T<VA
M[HW>FMA1L5TNI]Q1GT^UOEMN-DQ[DG+H$L#Q:9$(A:%\(7!QL6+/<;332#Z\
MH!^?^(8>/@&V7$3EB(@.9CZ^HJ*#P:'`\:UIO7J/557Z&YZ/G/F1;.:5Y6*R
M1C5X)^N__@VW26O++3*<\JN//KEB+96SS:WPIB%HC2N,"B/J>J##_%<KK(H/
M2AVIC;[%9+UPZ.B^'+F[]N1E0?3GFUUD4=7A1CO467D*XJ3%VQ'N,UOC1W59
M4ETZ%:HT7IF*:)\1_*0NC@UWMKLY)5-]%=@C$=Q;<3NC^&W%=VLWCW'W`MEZ
M2/,'-*_;X0WK:5RMW1*UL7,!=;*FT6<G\%25Y0IS82)DF*M1D_O<ZN@J="33
M=\+E'YT5%=J'<.KBP0=,2L1G)5*;+%T[TN&Z<,1-W-.B&D1,:/O>KCXBAD)N
M3>&DH/PZ(UR%#?@5SPHKCX)&^</&=D?>EV)I)V6=32R*O'H<=[QL8LBT$<^[
MI]=B]3U!@S4YBM.JU?0H(T;RB$PM*?EC:XEJ4!K&O9IR1TQQ:1>V2%:BG4VD
M`2"#?*4KAY$VFQ^7D@&[X24K_R%G!C5ZFD$*VA>^FG@\6_B2K+8`4YS'O2-I
MBN:H6B"'[P@+QHQ.J18_B!^LT<"NSQ';%=($S<!OV\*MZ,,TJUP6;TSW)4.G
M*T91SW<QDT<)W="!KN%H6RE:B;IFDF_PAGK@QE//DTYL9^.5WUOS[TH#*=7S
MU(K7PX4NL4\75T=353ZFXL0C?X:4EI?2J5W4="E1E$(A]D2GC`FAIE)1HK<>
M>6!8=]*PS=%DHMULZWWW!6UT&9<^Y)"(0YE("KL>_:A#56D`ZE/DBR)\HH0L
MO7^OE2Q7<(`MAU<5H6I9J;[7$C6)9X+S:;U046E[G4%<\^G*;0"4U*Y0-/)Z
M8-YG]B]R=K:"VU/MZ'KO@//5@;A6]V\Q=#_WFT70:2?)H04N&==Y+FH%![^.
M7TLYV$)4]3:4+D^@LA4:'.CJ1$5W#W8">^,V9V:L]QRHS;-".Q("999I7TGD
MM'H<9VHKORXVIK\3W?M:DM`Q(O:!]+X=\<>D8GS&EL5`PD!0@6`V#X\U-HIY
M<+'KL*_R_2>OP8RN0UG4Y$4/+]G#MY,A:W.Q*F--=^8H\P3U--+#M+HGEBI7
MD.9T=1^:!%*2QWC97SXGS-^:&'>]^ZJ\_JW@A,#XX]5@2=[M=MV-HN/^ZF1*
M!<M9V>8K,(OFTMUTL;G[3QXS4@JX"')5Q3Q%(F[WS$::8UPH+CC8$K=Z%[55
MK,7P3.ZR+LM&:23E,18-OQAZ.HI$_8Y5\X(-N_HE*SR<WB`AHO1P3EGE(#("
M8]I0">FY\A7^>;0KV!_<5BE84+%:B_>,B!F!:,KW7=IZ2=C$5-8(@_7N'R04
M/%M712(,CK%.0Z,NAM?JY$E8I!'YK]!(<5(UE?3E>%2UE`$N0`C8#@0[VY@N
M?:KNV,!'?'U'.J!W_-:H`?]M=)Y-S/D+[.N?2.:"[,BC1@T)I_M%8C*-)`E4
M5L*4:<%%(Z9Z2WQ1V_EDVITOLWLXD4ZB[E,VAQ9UCP;6@<#W\Q>"1_M3VQ;I
MDQJTTN=,B-)S$%9/3&Z])IKS*HA2:EX:VEVR-9'1IUI-)1CTM);2IZ+9IG64
MP?R*^="J!+W+LRUI,>'EJXI;0N0L\MJFBI14+9&A.1BK;\ET6ZH2RSBAXP1>
M&FMQEZ35K2<4Z1Z!5E/):3M>1.AF4&<E?;&F]*`@P?^`8<-\9Y4YP(=,E]EG
MTT:1RZ-/;Z%IXFL-)_80I3+K;NZP?&I:N.0P,H5`#;*0S#ZO;'[I*+8AR>V#
M='N.(;3^3<KQ4$<=+)@(&^R>IQ0X?#EY2V0X#,-%91W\"5.TBR"EK+`E\;@)
M!J9:;RXK/\`\G80.;$T[^0MH:#=Q3B?A`CHYVK]GDLX?/_)*OZ)^MJ$]A]#_
M35KBY\S1=YZ?'X(?Z9^KYWA"?\/S+YFD_W*.^APIZC>D_^21_O02:2[\=U[I
MWWGHS_'<_!W/N3S3GU[7X]\P_9-W^E.6][]A^2</]>\LC.=8=G[#\G_R4N>?
M@I_WB2^=(Q-"/Y>G^A7X\S;&Q7/`=]@_;RK_ZOVOFQS_'";X_VQY_#K:S\N\
M\W>.D_C?E=6O+#]'1/QS+-EDYQ>(OR)_?HTISB$;J/\E?NJH8V&?&A"=E.43
/UU7.GN3_`=9$0LE,'@``
`
end




Reply to: