Monday, June 25, 2012

ssClasses Update



ssGridSorter Enhancement

I realized that it is annoying for the users of ssGridSorter that it kept on toggling back and forth from ASCENDING to DESCENDING every time they click a header.  So I decided to remove that auto-toggling.

The class will run from now on by default in ASCENDING order and users can click any header of the grid (excluding those with .controlsource of General, Memo and Blob) and they will all have that order (it won't auto-toggle anymore).  To toggle the order, users now need to right-click on any header.  So if the current order is ASCENDING, right-clicking on any header will turn the order into DESCENDING; and vice-versa.  Once it is on DESCENDING order, user can click (left-click of course) on any header of the grid's column and that current sort order will be followed.  To toggle, right-click again.

I also added the necessary tooltip text to guide the users.

ssExcel Pivot

a.  Changed the default font from Arial 10 to Calibri 8.
b.  Added the ability to change the font to be used. This._font = 'Calibri-10'
c.  Added row freezing

Tuesday, June 19, 2012

Facts about a country!



Well, I have constant visitors of my blog site but I believe most of you do not know one hidden feature here? Which is you can know some facts about your country or other countries as well. How is that then?


Monday, June 18, 2012

Grid Tricks#4- Clearer Search Results


Where is numbers 1, 2 & 3 Tricks?  We can simply treat #1 as the More Objects inside a Cell blog, #2 as the Various Images II blog and #3 as the Transparent Grid blog.

I decided to start showing some more tricks I do on my side using grids which I deem will be useful for others as well.  This is about making the search result clearer or more visible by highlighting the cell contents where a near match can be found.  If not, it is very tiring for the user's eyes to trace where exactly those near matches are.

Saturday, June 16, 2012

Block Breaker Tool

I have been converting image files into HexBinary values, manually breaking those into acceptable blocks and enclosing those with TEXT... ENDTEXT, then finally embedding the codes within ssClasses.  The purpose of that is so I can make my library self-sustaining for its images need. 

I wanted the codes to be embedded inside because I want better control of the class and of course to minimize the unnecessary maintenance which will not be possible should I save those binary values inside a table or a text file; and ship those along with _ssclasses library.  Those outside files will be prone to content alteration and with binary values, a single character changed will mean inability to convert the images back properly later.

Not to mention that when I ship the library, I only wanted to ship these two files:

_ssclasses.vcx
_ssclasses.vct

and nothing else.

Wednesday, June 6, 2012

Transparent Grids - Now & Then


I have been wondering whether I can make my grid transparent and indeed I found a way.  However, said transparency can only be attained when there is no RecordSource and yes it suits me just fine because who, in his right mind, would want a transparent grid with data?  That is not only painful to the eyes but is likewise annoying, LOL!


Here is a sample how we can achive that: