Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Dynamic Lists are treating blank cells as having 0s in them. See the attached files | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | ken_burnside <ken.burnside> | ||||
Component: | configuration | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P2 | CC: | issues, kpalagin | ||||
Version: | 680m223 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | Windows XP | ||||||
URL: | http://www.adastragames.com/downloads/OpenOffice/Dynamic_List_Eval_Glitch_OO-dev-m223-calc.zip | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
ken_burnside
2007-08-08 22:21:05 UTC
Created attachment 47408 [details]
Two simple files that show the dynamic list population difference between Excel and Calc.
Seems to be fixed for 2.3. Only difference is that we show 0 instead of a blank cell which is intended. Frank closed fixed I need to clarify something: ==== Seems to be fixed for 2.3. Only difference is that we show 0 instead of a blank cell which is intended. ==== The fact that it shows 0 rather than a blank cell is exactly the problem I need addressed, and renders OO.o 2.3 useless for a lot of spreadsheets that I use. A blank cell is evaluated very differently from a cell with a zero in it for a lot of spreadsheet uses, including several that I use regularly. Having blank=0 breaks a lot of text form formatting, and prevents dynamic lists from error checking properly. Please fix this so that blank is distinct from 0. Hi Niklas, please comment on this one. Frank I have not seen any further action on this. To re-iterate, I need a blank cell evaluating as "empty", not as "0", for a lof of functions I run to work. Any progress to report? ken_burnside, I do not see any difference between Calc 2.3 and Excel 2003 with your files. Please elaborate. I've duplicated this to the point where I see the discrepency ken_burnside seems to be talking about. Steps (using either of his files): 1 - Use the drop-down menu in B2 to set that element to '3'. 2 - C2, D2, and E2 will automatically be set to '3', '2', and '1' respectively. 3 - Now click on the drop-down menu at F3. Only one option shows up for the value. Doing this in Excel, the option that shows up in step 3 is blank (or, rather, there is no option). In OO Calc, it is '0'. This difference will show up in more cells, depending on how B2 is set. If set to 2, then E3 and F3 will behave differently. If set to '1', then D3, E3, and F3 will all behave differently, based on whether the cell above them is empty. Hope that clears it up. I've duplicated this on Linux (Ubuntu 7.10) for OO Calc (OpenOffice 2.3), and Windows (Vista, Office 2007 SP1). Confirming as per mcintoshcraig. Reset assigne to the default "issues@openoffice.apache.org". |