Bug#282536: marked as done (calculating inside tables in documents is broken)
Your message dated Tue, 23 Nov 2004 08:50:51 +0100 (CET)
with message-id <Pine.LNX.4.61.0411230847310.4051@localhost>
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 tpo@sourcepole.ch Mon Nov 22 13:21:25 2004
Return-path: <tpo@sourcepole.ch>
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 <tpo_deb@sourcepole.ch>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: calculating inside tables in documents is broken
X-Mailer: reportbug 2.63
Date: Mon, 22 Nov 2004 22:20:47 +0100
Message-Id: <[🔎] E1CWLc7-0001i5-00@localhost>
Sender: Tomas Pospisek <tpo@sourcepole.ch>
Delivered-To: submit@bugs.debian.org
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 tpo@sourcepole.ch Mon Nov 22 23:51:24 2004
Return-path: <tpo@sourcepole.ch>
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 <tpo_deb@sourcepole.ch>
X-X-Sender: tpo@localhost
To: 282536-close@bugs.debian.org
cc: Jim Watson <jim@amarooas.com.au>
Subject: Re: Bug#282536: calculating inside tables in documents is broken
In-Reply-To: <[🔎] 20041122222247.GA22490@amarooas.com.au>
Message-ID: <Pine.LNX.4.61.0411230847310.4051@localhost>
References: <[🔎] E1CWLc7-0001i5-00@localhost> <[🔎] 20041122222247.GA22490@amarooas.com.au>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Sender: Tomas Pospisek <tpo@sourcepole.ch>
Delivered-To: 282536-close@bugs.debian.org
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
--------------------------------------------------------
Reply to: