xGrid - Spreadsheet Control

Xombie · Post by **Xombie** » Fri Mar 28, 2008 12:17 am

Howdy,

I'm releasing a demo version of xGrid. I finally had time to work on it a bit so I figured I'd let y'all try it out. I used PureLIB to build the installer for the library and I've included the cursors. This is not bug-free at all and is extremely restricted in what it's going to allow you to do. Basically just move around, resize things and type in text. Typing in the cells was just added so expect lots of bad behavior there.

Be sure to extract the cursors included in the zip file to your program directory. I haven't taken the time to figure out a nice way to get them stored in memory so for the demo you have to do this. Sorry.

There's a little demo *.pb file included in the zip as well for you to see how it works.

Again, just a demo. Take care!

http://www.seijin.net/Storage/xGrid 2008-03-27.zip

mk-soft · Post by **mk-soft** » Fri Mar 28, 2008 1:14 pm

Nice, but many to do

Download not right. Is not a ZIP. Is a RAR File without suffix.

MrMat · Post by **MrMat** » Fri Mar 28, 2008 1:29 pm

That's really nice Xombie! I think the link should be the full line?
http://www.seijin.net/Storage/xGrid%202008-03-27.zip

The installer gives a "This program might not have installed correctly" error after installation (Vista 64) and the cursors didn't install but after copying them across the example runs nicely.

Do you want feedback about bugs at this stage?

Xombie · Post by **Xombie** » Fri Mar 28, 2008 2:40 pm

MrMat - yeah, sorry: http://www.seijin.net/Storage/xGrid%202008-03-27.zip is correct. I was in a hurry to upload and didn't write a very good description.

The installer simply copies the example file and the user library. You still need to copy the cursors into the same folder as the program itself. I didn't have enough time to find an elegant solution to include the cursors so I just left it at that.

I'll take bug reports if you feel like passing them on. I've made more time to work on this so I'll be updating regularly. How is the speed and redraw? Any flickering or other stuff?

MrMat · Post by **MrMat** » Fri Mar 28, 2008 3:30 pm

Theres a few minor problems but it is really good

Some stuff i noticed...

If you're editing a cell then resize a row or column then the cell flickers.

If you edit a cell then click in another cell then the contents of the first cell disappear. I guess it should keep the first cell, as if return was pressed after editing it.

If you're editing a cell and scroll somewhere then the edit box doesn't move.

If you scroll down to the last row (223) then resize then press the down arrow the program crashes.

When you change sheet the cell shown as selected isn't currently selected so if you start typing text appears in a different cell.

If you make a selection then press delete (not backspace) then maybe it should clear the selection like Excel?

Xombie · Post by **Xombie** » Fri Mar 28, 2008 4:32 pm

Almost all related to the edit control, which is no surprise. I literally just added that so there's a bit to fix/add/change for it.

I appreciate the feedback and will get on these. Were you able to put it in your own test app or are you just using the sample app I included?

Thanks again!

MrMat · Post by **MrMat** » Fri Mar 28, 2008 5:25 pm

Cool! I've been using it in your example but i'm sure to make use of it in the future. I hope you decide to charge for it, it is definitely worth paying for

Some other minor stuff:

If you start the example, click in A1, type 123 then press return it crashes.

If you resize a row or column then the scroll bars don't update to reflect the new size.

If you drag a selection of cells and move the mouse outside the window then the selection doesn't update (no SetCapture_()/ReleaseCapture_()?). Also, when you move the mouse back inside the gadget then top left cell in the selection seems to be forgotten so the wrong cells are selected.

If you double click in a column or row header then the cursor changes to the resize cursor and if you try to resize the dividing line is drawn from the wrong place.

I think F2 should edit a cell and delete should clear it, or make it possible for the user to control this.

It looks like the last three parameters of SpreadsheetGadget are optional from the function description but they don't appear to be.

Keep up the great work!

rsts · Post by **rsts** » Fri Mar 28, 2008 5:53 pm

Yea! I'm very happy to see this

I'm busy on another project right now, but will test as I have time.

Thanks for the update.

cheers