On May 13, 2007, at 11:22 AM, [EMAIL PROTECTED] wrote:
>> The ability for adjacent cells to act as a single cell in terms of
>> having a continuous content area horizontally or vertically.
>
> OK, I can see how that would be handy sometimes. This *can* be done
> with the current listbox, sort of, but it's a lot of work and (as you
> said earlier) is a kludge.
>
It would be hard because the graphics regions are linked to
individual cells.
>> Joe you miss the point... It's not the calculations but the
>> flexability and ease with with large amounts of data can be displayed
>> and viewed. Where i work people use excel for databases for storage,
>> review and reporting of data because of that.
>
> I've seen lots of people using spreadsheets for databases, but I've
> always observed it to be mainly because that's the tool they already
> know.
My point is not the excel DB capability but the flexibility in data
display and scrolling that the ListBox does not have.
> But that's probably an argument for another time... more specifically,
> how would you use this in one of your RB apps?
>
Lets say you are reviewing test results for a many lots of a material
retrieved from a database
You may want a scrollable (in two dimensions) table like (view in
monospaced font):
_____________________________________________________________________
| Lot 1 | Lot 2 | ... | Lot n |
Test |--------------|--------------|--------------|--------------|
|values | Ave |values | Ave |values | Ave |values | Ave |
--------------------------------------------------------------------|
| 10.3 | | 10.3 | | 10.3 | | 10.3 | |
| 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 |
Test 1 | 10.3 | | 10.3 | | 10.3 | | 10.3 | |
| 10.3 | | 10.3 | | 10.3 | | 10.3 | |
---------------------------------------------------------------------
Test 2 | 15.1 | | 15.1 | | 15.1 | | 15.1 | |
| 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 |
---------------------------------------------------------------------
... | | | | | | | | |
---------------------------------------------------------------------
| 10.3 | | 10.3 | | 10.3 | | 10.3 | |
| 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 |
Test n | 10.3 | | 10.3 | | 10.3 | | 10.3 | |
| 10.3 | | 10.3 | | 10.3 | | 10.3 | |
| 10.3 | | 10.3 | | 10.3 | | 10.3 | |
---------------------------------------------------------------------
Where
1) you need to scroll on screen in both directions keeping the header
rows and right hand rows in view
The header need to be multi-line with headings and sub headings.
2) user can hide and show lots or hide values to show only averages
3) Sort by average vales for a specific test
4) allow data entry for for more lots
5) have everything lines up/centers nicely across cells or rows
where needed
6) Hide or show individual tests
7) The data is not stored in the control itself
The existing RB list can some of it but can not do all of it well.
And yes you can code these type of things as one offs... But a a well
designed grid control would make it much quicker and for DB type
stuff one often needs this functionality.
I find myself needing to do this type of stuff often
- karen
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
