Issue 17251

Summary:

sum function can get confused and go to "###"

Product:

Calc

Reporter:

Unknown <non-migrated>

Component:

code

Assignee:

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1 RC

Target Milestone:

---

Hardware:

OS:

Linux, all

URL:

http://pixel.fairyden.net/amps.sxc

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
spreadsheet, flaw in sum, only shows in 1.1rc	none

Description Unknown 2003-07-22 17:34:34 UTC

im using 1.1rc in slackware 9 with the stock kernel. the spreadsheet is on the
url above (i dont see a place to attach files on this form)

in this spreadsheet i usually "move" items by selecting the name of the item and
its value (number of amps it draws) and moving the whole to a new "circut" which
is really just a pair of colums. if you move the mac to another "circut", the
value of circut "A" becomes "###" and will stay that way until "A" gets the mac
back. any other device that ive tried can be moved and its total amps left will
update as it should. 

the bug seems to only affect 1.1rc, 1.0.2 and 1.1beta2 both worked correctly.

Comment 1 Unknown 2003-07-22 17:39:50 UTC

Created attachment 7932 [details]
spreadsheet, flaw in sum, only shows in 1.1rc

Comment 2 Unknown 2003-07-22 17:50:58 UTC

removing the "bold" font on the value of circut A, fixes the problem,
but the other two circuts also have bold fonts in there (amp) values
and are unaffected by it.

Comment 3 frank 2003-07-23 11:51:18 UTC

Hi Pixel,

this is not a bug but a support request. For such questions please use
the mailing lists.

### will indicate that the result of a formula or the value itself is
wider then the cell it contains. So just drag the cell boundaries
wider and you get your numbers.

Frank

Comment 4 frank 2003-07-23 11:51:33 UTC

closed invalid