PureBasic Forums - English

Xombie wrote:@Karbon - thanks ^_^ I'll think about it but I probably will stick with somewhere around $5 and free updates. My reasoning is that it's not a huge major project like billing software. It's a supplement that other people use in their programs. Also, I do enjoy working on it.

Well let me know when you decide - I'll be your first customer and order a couple of copies!

You *have* to enjoy working on your software to make it decent. I love working on most of mine most of the time. Sometimes it does become "just work", but everything does at some point!

Although I don't know and never used any spread sheet yet, yet I'd like to help indies with a small fee I have, I'll support you buy purchasing if I have something in my pocket.

Keep the good work on.

Xombie charging a $5 for such a huge project is well worth for us and even cheap (sorry guys thats what I think).

I am sure to buy it even if i know i wont use it so much because i just enjoy looking at your work.

Your coding skills are one of the best i know! you like to code and think creative (out of the box) and it does not matter if you are not a programming guru who knows ASM or C or whatever.

I thank you for all your help and your work, and when your project is out i will buy it

Great job.

Thanks, Pantcho and yoxola

I haven't had as much time as I'd like to work on features but still found time to do quite a bit of updating.

Resizing columns and rows is in. Multiple selections are in. Keyboard movement is mostly in. You can use the arrow keys as well as page up, page down, home and end and they should work almost exactly like Excel. For example, holding down the control key while pressing the home key should clear any existing selections and set the cell at row 1 column 1 to the only selected cell. The logic between monitoring when the grid has or loses focus is also in place. It should work much better than the old release (original PB4 version) and be much more lenient. Clicking the system menu does not cause the selected grid to lose focus, for instance. The focused grid should only lose focus when another control gains focus.

I also completely revamped the part of the code that calculates cells dimensions to be faster and smaller. It's an often called procedure so it was important to get it down a little more. The keyboard movement keys should behave much more like Excel in this version (compared to the original PB4 release). So holding down the shift key while pushing the up or down arrow should increase or decrease the selection based on where the user first clicked.

It may not seem like much but it is. You'll just have to trust me

I've enabled a couple of things for this demo. I've set the number of rows to 120000 and added 10 sheets. The number of rows, columns and sheets are something you designate when you first create the spreadsheet gadget. I'm simply calling this to create the whole spreadsheet gadget...
... and that's it. There is no code needed to remove the control at the end of the program like the old program.

You can click the test button to set the text for a particular cell. This part is in it's infancy so don't be too surprised if it doesn't seem that spectacular. Clicking the button will prompt for the row and column and then will use whatever sheet you have selected.

And the program is currently only 82k.

I'll be adding in cell editing capabilities next and going from there to working on handling formulas.

One thing I'd like to add that there will probably be scripting available in the future Kind of like VBA for Excel. Long term goal but it's something I have planned.

Download... http://www.seijin.net/Storage/xGrid-Test2.zip

Looks great Xombie, very nice.

This is a capability I would very much like to add to a program I'm working on.

Before i create a disaster by attempting to add my own calculation routines to egrid, just wondering if this is still a work in progress and if it is, is there any rough extimate as to when it might be released for testing?

No rush or anything, just trying to save myself some trouble.

cheers

Looking good Xombie. Keep going!

Howdy. Still a work in progress. I had to rework the selection routines and that took a chunk of time. I'm trying to figure out the best way to get the in cell editing done. After that, things will move much, much faster. Those two parts were always the most difficult.

I was thinking of just having a pop-up for the cell editing so that it'd be easier to get the multi-line and special effects (bold, font size, etc...) per character. Getting it into the cell as you're typing is a bear

I'm still interested in being your first customer if you decide to sell it

Xombie do you work momently at the xGrid or is it finished for you?

Sorry, guys. I took a break for a while from this but will be starting again a little bit this weekend and then giving it more time on Monday.

I really do apologize for the delay and ask that you bear with me for a little bit.

Thanks!

No worries.. I'll check back from time to time and check the progress. Might try to use this in kBilling sometime this year if it's something you think you'll continually develop (and charge for!).

HI, are you still going with this and how long to you are ready to release for sale/ general use?
Thanks
Matty

Odd coincidence you picked that particular formula as an example.

379-7916 was the phone number I had when I was a kid !