I have filed an RFE http://www.openoffice.org/issues/show_bug.cgi?id=70778 Please vote for it if you find it useful.
Thanks a lot. WBR, K. Palagin. > -----Original Message----- > From: Kirill S. Palagin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 24, 2006 11:40 AM > To: users@openoffice.org > Subject: RE: [users] Calc, _easily_ summing sparsely > populated columns? > > So this makes me ask - does current Calc's behavior (see > below) make any sense? > > (when clicking "Sum" with x*y selection, Calc just randomly generates > formulas (like "=SUM(#REF!3:D3)") > > > > > -----Original Message----- > > From: arnold huzen [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, October 24, 2006 1:06 AM > > To: users@openoffice.org > > Subject: Re: [users] Calc, _easily_ summing sparsely populated > > columns? > > > > After reading all of the answers and workarounds that were > passed on > > through the list it's save to say that the answer to the > OP's question > > is NO. Calc behaves different from Excel in this matter. > > > > Arnold Huzen > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]