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:


and nothing else.

Friday, June 8, 2012

Lessons in Life, or is it?

Well I realize that I am being serious lately so I decided to write some things that may lighten up my blogs.  And also to counter the new look of my header here which seems to reflect me in a no-nonsense mood, LOL!

Some people wonder why my vocabulary seems to be ample for a Filipino who never went anywhere except in the Philippines and now here in Papua New Guinea. Well here is the reason:

We are living before in a barrio where electricity is still a thing of the future and we only use Coleman or wicker oil lamp at night.  However, when we transferred to the city at the age of 3, I was able to watch Ernie and Bert, Kermit the frog, Big Bird and some more characters and that is where I slowly learn English words and learned how to count from 1 to 10.

At the age of 5, we wen't back to the barrio; and I can't believe Sesame Street has not taught me everything!  Because I realized that after the number 10, there are some more which is Jack, Queen and King.  Even 1 is also sometimes called Ace.  Drat! (I learn those after watching my cousins play a game of cards). And so I also learn another word - 'synonyms'.

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: