Issue 40604 - writer table: footnote disturbes table calculation
Summary: writer table: footnote disturbes table calculation
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: 680m69
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-13 18:43 UTC by harald.schilly
Modified: 2013-08-07 14:38 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description harald.schilly 2005-01-13 18:43:30 UTC
summary: a footnote(-number?) in a table with numbers disturbes a 
[F2]-calculation.

example to reproduce:
open writer, new table, 3 colums or what you like.
A1: 10
B1: 10
C1: [F2] ---> = sum <A1:B1>
C2: [F2] ---> = mean <A1:B1>
now:
C1 = 20, C2 = 10 as it should be. okay.

here it comes, set the cursor after the "10" in A1 and insert>footnote.
it adds a little 1 as expected and enter some footnote text (like a comment
to some results in a protocol some tests)
now click into C1 to update the calculation
it tells me the sum is 10 and mean value is 5.

i've tried this with various situations and i cannot see a common pattern. it
also happens in 1.1.x and with 1.9m65@linux

so, there should be some checks if the considered values in cells for those
very handy functions are some special fields like footnotes (or an error 
message)
Comment 1 stefan.baltzer 2005-02-07 12:07:18 UTC
SBA: Broken. This worked in OOo 1.1.4/SO 7_PP4.
SBA->FME: As discussed, please have a look.
Reassigned to FME.
Comment 2 stefan.baltzer 2005-02-07 12:08:33 UTC
SBA: Adjusted component= Wordprocessor, Subcomponent= Code.
Comment 3 stefan.baltzer 2005-02-07 13:21:09 UTC
SBA: Reassigned to FME.
Comment 4 frank.meies 2005-02-07 14:40:00 UTC
FME->SBA: As discussed, this is not broken. Therefore I'll set this to 'OOo later'.