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

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



Your message dated Thu, 15 Mar 2007 12:41:31 +0100
with message-id <20070315114131.GJ5377@rene-engelhard.de>
and subject line Bug#414962: openoffice.org-calc: formula will not evaluate between multiple worksheets; #NAME? =max(w1.b2,w2.b2)
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---
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



--- End Message ---
--- Begin Message ---
Hi,

supaplex wrote:
> 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!

Use =MAX(....;....)
         ^ semicolon, not comma.

Closing.

Regards,

Rene
-- 
 .''`.  Ren�ngelhard -- Debian GNU/Linux Developer
 : :' : http://www.debian.org | http://people.debian.org/~rene/
 `. `'  rene@debian.org | GnuPG-Key ID: 248AEB73
   `-   Fingerprint: 41FA F208 28D4 7CA5 19BB  7AD9 F859 90B0 248A EB73


--- End Message ---

Reply to: