* Ennio-Sr <[EMAIL PROTECTED]> [300305, 21:05]:
> [using either OOo-1.1.4 or Beta2(1.9.79) under Debian/Sarge]
>
> Hi all!
>
> I opened an .xml spreadsheet that has a few '@subtotal(Xn..Xnn)'.
>
> The cells where these subtotals were defined in the original .123 file
> now display:
> <@SUBTOTAL(Xn..Xnn);resulting_sum>
> instead of showing the resulting sum only; moreover, any attempt to
> create new subtotals fails. I tried to interpret the relative help but
> couldn't get much out of it ;(
>
OK, I did find a solution in the end: it was just a question of wording
and the function 'subtotal' has nothing to do with it: it suffice using
=sum(Xn:Xnn) or clicking on the sum sign (left of the cell edit window).
BTW, what is achieved with the '@grandtotal' (i.e. sum all and only the
subtotals in this column) command in Lotus 123, is done again by 'sum'
in OOo.
May I suggest that a note be included in the Help?
Thanks for your attention.
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
