Your message dated Tue, 23 Nov 2004 08:50:51 +0100 (CET)
with message-id <[EMAIL PROTECTED]>
and subject line Bug#282536: calculating inside tables in documents is broken
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)
--------------------------------------
Received: (at submit) by bugs.debian.org; 22 Nov 2004 21:21:26 +0000
>From [EMAIL PROTECTED] Mon Nov 22 13:21:25 2004
Return-path: <[EMAIL PROTECTED]>
Received: from mail1.bluewin.ch [195.186.1.74]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CWLcj-0003VT-00; Mon, 22 Nov 2004 13:21:25 -0800
Received: from localhost (83.76.62.125) by mail1.bluewin.ch (Bluewin AG
7.0.030.2)
id 41863EE9002129C1; Mon, 22 Nov 2004 21:20:54 +0000
Received: from tpo by localhost with local (Exim 3.36 #1 (Debian))
id 1CWLc7-0001i5-00; Mon, 22 Nov 2004 22:20:47 +0100
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Tomas Pospisek <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: calculating inside tables in documents is broken
X-Mailer: reportbug 2.63
Date: Mon, 22 Nov 2004 22:20:47 +0100
Message-Id: <[EMAIL PROTECTED]>
Sender: Tomas Pospisek <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
Package: openoffice.org
Version: 1.1.2dfsg1-1
Severity: important
How to reproduce:
Create new text document. Create a table in it. Type "=round(1;2)" inside the
table.
Result:
"Expression is faulty". It should be OK.
Another try:
"=floor(1)*1"
Result:
"Expression is faulty"
Calculating inside tables is IMO completely borken in 1.1.2dfsg1-1. If at all
avoidable,
1.1.2dfsg1-1 should not with the next Debian release. I'll try -3 from unstable
in a
minute and report back.
*t
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing'), (50, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.4.22
Locale: LANG=C, LC_CTYPE=C
Versions of packages openoffice.org depends on:
ii dictionaries-common [openo 0.22.40sarge7 Common utilities for spelling dict
hi openoffice.org-bin 1.1.2dfsg1-1 OpenOffice.org office suite binary
hi openoffice.org-debian-file 1.1.2-5+1 Debian specific parts of OpenOffic
hi openoffice.org-l10n-de [op 1.1.2dfsg1-1 German language package for OpenOf
hi openoffice.org-l10n-en [op 1.1.2dfsg1-1 English (US) language package for
ii ttf-opensymbol 1.1.2dfsg1-1 The OpenSymbol TrueType font
-- no debconf information
---------------------------------------
Received: (at 282536-close) by bugs.debian.org; 23 Nov 2004 07:51:24 +0000
>From [EMAIL PROTECTED] Mon Nov 22 23:51:24 2004
Return-path: <[EMAIL PROTECTED]>
Received: from mail15.bluewin.ch [195.186.18.63]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CWVSO-0007An-00; Mon, 22 Nov 2004 23:51:24 -0800
Received: from localhost (83.77.61.200) by mail15.bluewin.ch (Bluewin AG
7.0.032)
id 41868D4F001035A1; Tue, 23 Nov 2004 07:50:53 +0000
Received: from tpo (helo=localhost)
by localhost with local-esmtp (Exim 3.36 #1 (Debian))
id 1CWVRr-00017Y-00; Tue, 23 Nov 2004 08:50:51 +0100
Date: Tue, 23 Nov 2004 08:50:51 +0100 (CET)
From: Tomas Pospisek <[EMAIL PROTECTED]>
X-X-Sender: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: Jim Watson <[EMAIL PROTECTED]>
Subject: Re: Bug#282536: calculating inside tables in documents is broken
In-Reply-To: <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Sender: Tomas Pospisek <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-4.5 required=4.0 tests=BAYES_10,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
On Tue, 23 Nov 2004, Jim Watson wrote:
> On Mon, Nov 22, 2004 at 10:20:47PM +0100, Tomas Pospisek wrote:
>> How to reproduce:
>> Create new text document. Create a table in it. Type "=round(1;2)" inside
>> the table.
>> Result:
>> "Expression is faulty". It should be OK.
>
> I can reproduce this in my upstream build of 1.4. But is that function style
> correct?
>
> I find this in the "Help-Tables-Calculating in text":
>
> ROUND
> Rounds a number to the specified decimal places.
> Example: 15.678 ROUND 2 displays 15.68
>
> So if I type "= 15.678 ROUND 2" this works correctly upstream. Is it
> docmented somewhere that the calc style of functions should work too?
You are right. The problem lies within the documentation (and the syntax).
Everything is working as advertized, it's just not trivial to find the
advertisement (I was searching the documentation and only happened to
find references to the syntax for spreadsheets).
Thanks a lot for your insightful hint,
*t
--
--------------------------------------------------------
Tomas Pospisek
http://sourcepole.com - Linux & Open Source Solutions
--------------------------------------------------------