NOTICE: This version of the NSF Unidata web site (archive.unidata.ucar.edu) is no longer being updated.
Current content can be found at unidata.ucar.edu.
To learn about what's going on, see About the Archive Site.
Hi John, >In order make it more useable I have had to change the source code of >SpreadSheet.java, as it does not lend itself to being easily extended. As I mentioned to Peter Cao, if you have any specific suggestions about how to make the SpreadSheet easier to use or more extensible, feel free to mention them. I am interested in any ideas you might have to make the Spread Sheet a friendlier piece of software. >I am also extending FancySSCell - as such, i also needed to change the >source code of the SpreadSheet to allow a SSCell other than FancySSCell >to be used. I had to make one other change to the VisAD source. The >FormulaManager used by BasicSSCell, as it is written, must be the one >created by the createStandardManager() method of FormulaUtil. The >FormulaManager created by this method is not suitable for my needs. An easy solution to this problem would be for me to add constructors to BasicSSCell and SpreadSheet that take a FormulaManager object. Then, you could easily write a short method to create your desired FormulaManager and spawn a Spread Sheet UI. >making "Save SpreadSheet" really save the SpreadSheet Do you mean that this feature was broken and you fixed it, or that you modified it to save serialized data from each cell? If the feature isn't working for you, I'd of course like to determine why and provide a bug fix to anyone else who may be affected by the bug. If you modified it, then I'll consider adding a menu item to the Setup menu called "Save entire spreadsheet," or something like that, since you are not the first person to express interest in such a feature. >making formulae and frequently used mappings more accessible. If you have usability improvements to the GUI that you are willing to share and that you think would benefit the VisAD community at large, I am very interested in adding them to the Spread Sheet source. >One signifigant step that needs to be made is to make cell >resizing work correctly. maybe this problem does not come up on >Solaris, but on NT the relationship between the locations yellow resize >tabs and the actual size of the cells quickly breaks down. eventually, >cell resizing stops working altogether, especially if you try to use >many cells. also, the cells do not redraw themselves when a resize >occurs, meaning the user has to go around and click in every cell in >order to force a resize. I developed the Spread Sheet on NT, and have seen the redraw problems with the cells after a resize, but I haven't experienced the resizing mechanism actually breaking down. I admit that the layout manager for the Spread Sheet is a bit flaky, and I am going to overhaul it in the next month or so. Maybe I'll eliminate the problem you describe in the process of fixing the other bugs I've noticed in the resizing logic. >There is another problem, and, again, maybe this is just on NT: I can't >seem to get the cursor to "pan." It should pan when you drag with the >middle mouse button, but instead, it rotates the scene with the cursor >on, as is supposed to happen when you hold down control when you are >draggin with the middle mouse button. Actually, panning the scene is accomplished by holding Shift and dragging with the left mouse button. The middle mouse button turns the cursor on, letting you examine data values. Within the next month, I will be working to implement a lot of the suggestions given by Peter Cao and John Brecht, as well as fixing many of the long-standing Spread Sheet bugs, such as the problems John has described with the resizing logic. If anyone else has bug reports or suggestions for extending the Spread Sheet, the next couple of weeks would be a great time to let me know. -Curtis
visad
archives: