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

RSS Feed

Google Search

PHP-GTK2 eBooks

Most Recent Reviews

Frédéric rates article "Accordion Menu Apple style - variation 2":
Nov 19, 2008 8:07am
bescherelle rates sample code 507:
Nov 18, 2008 9:52am
Bartosz says: Hello, I have both Hide DirectPHP for RSS Feed and Hide include_content_item ...
Nov 17, 2008 9:57am
jerryhou rates article "StickyNote plugin":
Nov 16, 2008 9:42pm
sunil thakare rates article "2.2 Understand the Fill parameter":
Nov 16, 2008 10:54am
doutrax says: hello! looks like a nice plugin, but is it possible with a stand-a-lone ...
Nov 16, 2008 9:55am
acara2000 rates article "StickyNote plugin":
Nov 15, 2008 11:43am
mmka says: asd ...
Nov 15, 2008 5:07am
XeKtRuM rates sample code 530:
Nov 14, 2008 5:58am
underdpt rates sample code 530:
Nov 13, 2008 9:36am
Heinrich Stamerjohanns rates sample code 24:
Nov 12, 2008 3:27pm

Main Menu

Home

Sample Codes

List all sample codes

Browse all sample codes

Side Menu

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 Yahoo Stock Quote

PHP-GTK2 Newsletter

PHP-GTK2 Tips & Techniques
FREE Newsletter
by kksou

Your privacy is respected.

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).