Issue 17251 - sum function can get confused and go to "###"
Summary: sum function can get confused and go to "###"
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL: http://pixel.fairyden.net/amps.sxc
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-22 17:34 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
spreadsheet, flaw in sum, only shows in 1.1rc (6.15 KB, application/octet-stream)
2003-07-22 17:39 UTC, Unknown 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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