PureBasic Forums - English

I've updated the original xGrid code for PB4 (99% of the effort was in adding Define for the variables).

I've also added in a new IsNumber() and expression solving function so that should speed up any expressions by a lot. However, I had to rework how it handles cell referencing so I'd appreciate any reports on bugs in the expression solver. Also, there are only two functions at the moment - Round() and Max(). I'll add more later and I welcome any suggestions.

The project is not unicode compatible at the moment. That's a later update. Probably much later since I have a lot of other things to do and this is a pretty low priority to me. It's a large project, doesn't make any money and I don't actually use it so it's not as fun for me to update.

Features are still missing as this is a direct conversion from the original xGrid code. And I'm sure there are a lot of bugs. Let me know if you find some.

Doubles and Quads are supported so accuracy (precision?) should be much better.

What else? I dunno. Oh, here's a simple screenshot...



Shows a formula and how it works with a cell reference.

Let me know if y'all find anything or just drop a note to say hey. Oh, and it's LGPL.

http://www.seijin.net/Storage/Code/xGrid/xGrid.7z

Haven't had an opportunity to test it yet, but regardless, thanks again for another fine contribution.

cheers

thanks Xombie, looking good

Big and nice Job

Fun with cell colors



That's supposed to be "PUREBASIC 4.00 X-Grid" ... I never claimed to be an artist

Champion stuff. Thanks, Xombie

WOW!

Only had a quick play (I'm at work...shhhh...don't tell the boss). My God, this is awesome! Very nice!

Thank you, this is excellent! Only problem is, no cursor/mouse pointer while over the grid area. Must be my setup, will play around some more.

Cheers Xombie!

DOH! The lack of cursor must be in the way I'm compiling, will continue to play...

Thanks, fellas

@Amundo - When I compile the program (using Japbe for PB4), I use resources. If you pull up Main.pb with a plain text editor, you'll see the info at the bottom of the file.
I haven't messed around with the PB editor's resource usage so I'm not sure how to set this up. Maybe someone else can chime in?

I think the PB editor loads an .rc file so maybe...
With that saved as xGrid.rc and then go to Compiler->Compiler Options->Resources Tab->" ... " and load xGrid.rc? In the PB editor.

Maybe.

Thanks Xombie, yeah, just edited my original post, can't be compiling it properly.

jack wrote:

jack wrote:a tip for people using the PB IDE.
assuming that you created a folder "C:\Program Files\PureBasic\Examples\xGrid" and extracted xGrid to that folder.
save the following as "cursors.rc" in same folder

Thanks Jack!

It's even MORE beautiful now...brings a tear to my eye...

Good tip, jack. Thanks.

Stooop eet... I'm blushing



As long as it's useful for something, I'm happy. Or not. I learned a lot while plodding through the process of making that sucker.

xombie,

Your new xGrid is GREAT!

I have one suggestion to make it easier to resize the column width.
Right now, I have to put my cursor exactly on the dividing line between two columns to be able to resize a column.
Since the line is only one pixel wide, this is very hard!
Please consider allowing a "margin" on either side of the divider, maybe 10 pixels or so.

This idea isn't my original; I "borrowed" it from Microsoft's Excel spreadsheet.
But there's no shame in sharing a good idea, is there?

Regards,
Eric

yes, huge work, congrats.

i noticed a little bug about formulas:

for example '=A4+C5' is ok but not with 'double letters column' like '=AB4+CE5'.