php-gtk2 Cookbook: How to use GtkSheet - Part 5 - set row and column headers?

RSS Feed

Google Search

PHP-GTK2 eBooks

Most Recent Reviews

Cláudio César Monteiro dos Santos Júnior rates sample code 28:
Aug 21, 2008 11:14am
vpn01 rates sample code 123:
Aug 20, 2008 10:25pm
adel says: I am using php-gtk-2.0.1 Windows binary pack php-gtk-2.0.1 Windows binary extensions pack under ...
Aug 20, 2008 11:49am
Bruno Azevedo rates sample code 14:
Aug 20, 2008 5:20am
Lars BOje Jensen rates sample code 291:
Aug 19, 2008 5:30am
Lars BOje Jensen rates sample code 74:
Aug 19, 2008 5:28am
Larry says: After further review, I've concluded that my test was unfair. Since ...
Aug 18, 2008 5:35pm
Larry says: My last post should have showed that the php code I was ...
Aug 18, 2008 5:09pm
Larry says: I downloaded and installed this plugin into Joomla! 1.5.6 today. Joomla! was ...
Aug 18, 2008 4:35pm
Larry says: I downloaded and installed this plugin into Joomla! 1.5.6 today. Joomla! ...
Aug 18, 2008 4:15pm
gianni rates sample code 317:
Aug 18, 2008 12:30pm

Main Menu

Home

Sample Codes

List all sample codes

Browse all sample codes

Take a break!

Sudoku Joomla Joomla Gadgets Joomla - sample 1 Joomla - sample 2 Joomla 1.0 to 1.5 Google Image Search Google News Search Wikipedia Search Google Book Search Google Video Search

Sample Code 250: How to use GtkSheet - Part 5 - set row and column headers?

Written by kksou

Wednesday, 06 June 2007

Problem

You have displayed a 2D array in a GtkSheet in How to use GtkSheet - Part 3 - set values?.

Now you would like to set the column headers and row labels as shown below:

How to use GtkSheet - Part 5 - set row and column headers?

Solution

Make sure your version of PHP-GTK2 has the GtkExtra library, and the feature turned on in php.ini. (See notes below.)
Create the spreadsheet as outlined in How to use GtkSheet - Part 1 - create the spreadsheet?
Set the column headers with GtkSheet::column_button_add_label($col, $label)
Set the column headers with GtkSheet::row_button_add_label($row, $label)
You can justify the column headers with GtkSheet::column_button_justify($col, $justification). The $justification are predefined constants as listed here.

Important Note: This only works for PHP-GTK2 compliled with the additional library GtkExtra. For linux, you can download the files from http://gtkextra.sourceforge.net/ and do a recompile. For windows, you may use the builds by Elizabeth Smith or the official php-gtk2 beta release available at http://gtk.php.net/download.php. Both contain all the required gtkextra libraries and dll's. In the php.ini, don't forget to add php-gtk.extensions = php_gtk_extra2.dll to turn on GtkExtra.

Sample Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

<?php
$window = new GtkWindow();
$window->set_title($argv[0]);
$window->set_size_request(421, 250);
$window->connect_simple('destroy', array('Gtk','main_quit'));
$window->add($vbox = new GtkVBox());

// display title
$title = new GtkLabel("Using GtkSheet\n".
"Part 5 - Set Row and Column Headers");
$title->modify_font(new PangoFontDescription("Times New Roman Italic 10"));
$title->modify_fg(Gtk::STATE_NORMAL, GdkColor::parse("#0000ff"));
$title->set_size_request(-1, 40);
$title->set_justify(Gtk::JUSTIFY_CENTER);
$alignment = new GtkAlignment(0.5, 0, 0, 0);
$alignment->add($title);
$vbox->pack_start($alignment, 0, 0);
$vbox->pack_start(new GtkLabel(), 0, 0);

// the 2D table
$data = array(
array('row0', 'item 42', 2, 3.1),
array('row1', 'item 36', 20, 6.21),
array('row2', 'item 21', 8, 9.36),
array('row3', 'item 10', 11, 12.4),
array('row4', 'item 7', 5, 15.5),
array('row5', 'item 4', 17, 18.6),
array('row6', 'item 3', 20, 21.73));

$field_header = array('Row #', 'Description', 'Qty', 'Price'); // note 1
$justification = array('LEFT', 'LEFT', 'CENTER', 'RIGHT');

display_table($vbox, $data, $field_header, $justification);

$window->show_all();
Gtk::main();

function display_table($vbox, $data, $field_header, $justification) {

    $scrolled_win = new GtkScrolledWindow();
    $scrolled_win->set_policy( Gtk::POLICY_AUTOMATIC,
        Gtk::POLICY_AUTOMATIC);
    $vbox->pack_start($scrolled_win);

    $sheet = new GtkSheet(count($data), count($data[0]), 'Test 123');

Note that this is only 70% of the sample code. You have to be a registered member to see the entire sample code. Please login or register.
Registration is free and immediate.
Have some doubt about the registration? Please read this forum article.

Explanation

Column header definitions.
Set the column headers.
Justify the colulmn headers.
Set the row labels. Here we set the row numbers to start from 1 (instead of the default 0).