#!/bin/env python

#see license.txt for license details

__version__='3.3.0'

__doc__='Test script for reportlab.tables'

from reportlab.lib.testutils import setOutDir,makeSuiteForClasses, outputfile, printLocation

setOutDir(__name__)

import os,unittest

from reportlab.platypus import Spacer, SimpleDocTemplate, Table, TableStyle, FrameBG

from reportlab.platypus.paragraph import Paragraph

from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle

from reportlab.lib.units import inch, cm

from reportlab.lib import colors

from reportlab.graphics.charts.linecharts import HorizontalLineChart

from reportlab.graphics.shapes import Drawing, _DrawingEditorMixin

from reportlab.graphics.charts.barcharts import VerticalBarChart

styleSheet = getSampleStyleSheet()

def getTable():

    t = Table((('','North','South','East','West'),

             ('Quarter 1',100,200,300,400),

             ('Quarter 2',100,400,600,800),

             ('Total',300,600,900,'1,200')),

             (72,36,36,36,36),

             (24, 16,16,18)

            )

    return t

def makeStyles():

    styles = []

    for i in range(5):

        styles.append(TableStyle([('ALIGN', (1,1), (-1,-1), 'RIGHT'),

                                  ('ALIGN', (0,0), (-1,0), 'CENTRE'),

                                  ('HREF', (0,0), (0,0), 'www.google.com'),

                                  ]))

    for style in styles[1:]:

        style.add('GRID', (0,0), (-1,-1), 0.25, colors.black)

    for style in styles[2:]:

        style.add('LINEBELOW', (0,0), (-1,0), 2, colors.black)

    for style in styles[3:]:

        style.add('LINEABOVE', (0, -1), (-1,-1), 2, colors.black)

    styles[-1].add('LINEBELOW',(1,-1), (-1, -1), 2, (0.5, 0.5, 0.5))

    return styles

def run():

    doc = SimpleDocTemplate(outputfile('test_platypus_tables.pdf'), pagesize=(8.5*inch, 11*inch), showBoundary=1)

    lst = []

    from reportlab import Version

    styNormal = styleSheet['Normal']

    styBackground = ParagraphStyle('background', parent=styNormal, backColor=colors.pink)

    styH1 = styleSheet['Heading1']

    lst.append(FrameBG(color=colors.red))

    lst.append(Paragraph("First, a test of how tables align their content...", styH1))

    lst.append(Paragraph("""Generated with version %s""" % Version,

                        styNormal))

    lst.append(Paragraph("""In release 2.3, cells with plain text positioned their

                         text differently to cells with Paragraphs using the

                         same font.  Hopefully now they are back on the same baseline""",

                        styNormal))

    lst.append(FrameBG(color=colors.blue))

    ts1 = TableStyle([

                ('ALIGN', (0,0), (-1,0), 'RIGHT'),

                ('BACKGROUND', (0,0), (-1,0), colors.lightgrey),

                ('VALIGN', (0,0), (-1,-1), 'TOP'),

                ('GRID', (0,0), (-1,-1), 0.25, colors.black),

                    ])

    t1 = Table([

        ('plain text','plain text','shortpara','plain text', 'long para'),

        ('Text','more text', Paragraph('Is this para level?', styBackground), 'Back to text', Paragraph('Short para again', styBackground)),

        ('Text',

            'more text',

            Paragraph('Is this level?', styBackground),

            'This is plain\ntext with line breaks\nto compare against\nthe para on right',

            Paragraph('Long paragraph we expect to wrap over several lines accurately', styBackground)),

        ])

    t1.setStyle(ts1)

    lst.append(t1)

    lst.append(FrameBG(start=False))

    lst.append(Spacer(0,10))

    lst.append(Paragraph("Now we make a table with just one cell containing a string...note how the text sits low", styNormal))

    lst.append(FrameBG(start=False))

    tsGrid = TableStyle([

                ('GRID', (0,0), (-1,-1), 0.25, colors.black),

                    ])

    lst.append(Table([['One cell of plain text']], style=tsGrid, colWidths=[200]))

    lst.append(Spacer(0,10))

    lst.append(Paragraph("Now we make a table with just one cell containing a para...should be same position.  Note that the overall bounding box is an approximation and lies - it always did.", styNormal))

    lst.append(Table([[Paragraph('One cell containing a paragraph.  ÄÉ∫', styBackground)]], style=tsGrid, colWidths=[200]))

    lst.append(Spacer(0,10))

    lst.append(Paragraph("Paragraphs jumped up post 2.1.  Ideally they should align the same.", styNormal))

    lst.append(Spacer(0,30))

    lst.append(Paragraph("Now for all the tests we had before.  See also the much longer test_platypus_tables_2.pdf, which for reasons unknown was split into a separate file generated by the same script", styNormal))

    styles = makeStyles()

    for style in styles:

        t = getTable()

        t.setStyle(style)

##        print '--------------'

##        for rowstyle in t._cellstyles:

##            for s in rowstyle:

##                print s.alignment

        lst.append(t)

        lst.append(Spacer(0,12))

    t=Table([['VERTICAL Gradient Red top, grey bottom','Horizontal Gradient Blue left, green right'],

             ['HORIZONTAL Gradient Span grey left red right', ''],

             ['VERTICAL Gradiant Span Blue top green bottom',''],

             ['','CLEAR']],[3.5*inch, 2.7*inch])

    style=TableStyle([

    ('SPAN', (0,1),(1,1)),

    ('SPAN', (0,2),(0,3)),

    ('BACKGROUND',(0,0), (0,0),['VERTICAL', colors.grey, colors.red]),

    ('BACKGROUND',(1,0), (1,0),['HORIZONTAL', colors.blue, colors.green]),

    ('BACKGROUND',(0,1), (1,1),['HORIZONTAL', colors.grey, colors.red]),

    ('BACKGROUND',(0,2), (0,3),['VERTICAL', colors.blue, colors.green])

    ])

    t.setStyle(style)

    lst.append(t)

    doc.build(lst)

class TableBarChart(_DrawingEditorMixin,Drawing):

    def __init__(self,width=400,height=200,*args,**kw):

        Drawing.__init__(self,width,height,*args,**kw)

        self.width = 136

        self.height = 140

        self._add(self,VerticalBarChart(),name='chart',validate=None,desc=None)

        self.chart.y = 20

        self.chart.width = self.width - 21

        self.chart.height = self.height - 24

        self.chart.categoryAxis.categoryNames = ['Spring','Summer','Autumn','Winter']

        self.chart.categoryAxis.labels.fontSize = 7

def old_tables_test():

    from reportlab.lib.units import inch, cm

    from reportlab.platypus.flowables import Image, PageBreak, Spacer, XBox

    from reportlab.platypus.paragraph import Paragraph

    from reportlab.platypus.xpreformatted import XPreformatted

    from reportlab.platypus.flowables import Preformatted

    from reportlab.platypus.doctemplate import SimpleDocTemplate

    from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle

    from reportlab.platypus.tables import GRID_STYLE, BOX_STYLE, LABELED_GRID_STYLE, COLORED_GRID_STYLE, LIST_STYLE, LongTable

    rowheights = (24, 16, 16, 16, 16)

    rowheights2 = (24, 16, 16, 16, 30)

    colwidths = (50, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32)

    data = (

        ('', 'Jan', 'Feb', 'Mar','Apr','May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'),

        ('Mugs', 0, 4, 17, 3, 21, 47, 12, 33, 2, -2, 44, 89),

        ('T-Shirts', 0, 42, 9, -3, 16, 4, 72, 89, 3, 19, 32, 119),

        ('Key Ring', 0,0,0,0,0,0,1,0,0,0,2,13),

        ('Hats', 893, 912, '1,212', 643, 789, 159, 888, '1,298', 832, 453, '1,344','2,843')

        )

    data2 = (

        ('', 'Jan', 'Feb', 'Mar','Apr','May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'),

        ('Mugs', 0, 4, 17, 3, 21, 47, 12, 33, 2, -2, 44, 89),

        ('T-Shirts', 0, 42, 9, -3, 16, 4, 72, 89, 3, 19, 32, 119),

        ('Key Ring', 0,0,0,0,0,0,1,0,0,0,2,13),

        ('Hats\nLarge', 893, 912, '1,212', 643, 789, 159, 888, '1,298', 832, 453, '1,344','2,843')

        )

    lst = []

    lst.append(Paragraph("Tables", styleSheet['Heading1']))

    lst.append(Paragraph(__doc__, styleSheet['BodyText']))

    lst.append(Paragraph("The Tables (shown in different styles below) were created using the following code:", styleSheet['BodyText']))

    lst.append(Preformatted("""

    colwidths = (50, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32, 32)

    rowheights = (24, 16, 16, 16, 16)

    data = (

        ('', 'Jan', 'Feb', 'Mar','Apr','May', 'Jun',

           'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'),

        ('Mugs', 0, 4, 17, 3, 21, 47, 12, 33, 2, -2, 44, 89),

        ('T-Shirts', 0, 42, 9, -3, 16, 4, 72, 89, 3, 19, 32, 119),

        ('Key Ring', 0,0,0,0,0,0,1,0,0,0,2,13),

        ('Hats', 893, 912, '1,212', 643, 789, 159,

             888, '1,298', 832, 453, '1,344','2,843')

        )

    t = Table(data, colwidths, rowheights)

    """, styleSheet['Code'], dedent=4))

    lst.append(Paragraph("""

    You can then give the Table a TableStyle object to control its format. The first TableStyle used was

    created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

GRID_STYLE = TableStyle(

    [('GRID', (0,0), (-1,-1), 0.25, colors.black),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT')]

    )

    """, styleSheet['Code']))

    lst.append(Paragraph("""

    TableStyles are created by passing in a list of commands. There are two types of commands - line commands

    and cell formatting commands. In all cases, the first three elements of a command are the command name,

    the starting cell and the ending cell.

    """, styleSheet['BodyText']))

    lst.append(Paragraph("""

    Line commands always follow this with the weight and color of the desired lines. Colors can be names,

    or they can be specified as a (R,G,B) tuple, where R, G and B are floats and (0,0,0) is black. The line

    command names are: GRID, BOX, OUTLINE, INNERGRID, LINEBELOW, LINEABOVE, LINEBEFORE

    and LINEAFTER. BOX and OUTLINE are equivalent, and GRID is the equivalent of applying both BOX and

    INNERGRID.

    """, styleSheet['BodyText']))

    lst.append(Paragraph("""

    Cell formatting commands are:

    """, styleSheet['BodyText']))

    lst.append(Paragraph("""

    FONT - takes fontname, fontsize and (optional) leading.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    TEXTCOLOR - takes a color name or (R,G,B) tuple.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    ALIGNMENT (or ALIGN) - takes one of LEFT, RIGHT, CENTRE (or CENTER) or DECIMAL.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    LEFTPADDING - defaults to 6.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    RIGHTPADDING - defaults to 6.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    BOTTOMPADDING - defaults to 3.

    """, styleSheet['Definition']))

    lst.append(Paragraph("""

    A tablestyle is applied to a table by calling Table.setStyle(tablestyle).

    """, styleSheet['BodyText']))

    t = Table(data, colwidths, rowheights)

    t.setStyle(GRID_STYLE)

    lst.append(PageBreak())

    lst.append(Paragraph("This is GRID_STYLE\n", styleSheet['BodyText']))

    lst.append(t)

    t = Table(data, colwidths, rowheights)

    t.setStyle(BOX_STYLE)

    lst.append(Paragraph("This is BOX_STYLE\n", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

    It was created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

BOX_STYLE = TableStyle(

    [('BOX', (0,0), (-1,-1), 0.50, colors.black),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT')]

    )

    """, styleSheet['Code']))

    t = Table(data, colwidths, rowheights)

    t.setStyle(LABELED_GRID_STYLE)

    lst.append(Paragraph("This is LABELED_GRID_STYLE\n", styleSheet['BodyText']))

    lst.append(t)

    t = Table(data2, colwidths, rowheights2)

    t.setStyle(LABELED_GRID_STYLE)

    lst.append(Paragraph("This is LABELED_GRID_STYLE ILLUSTRATES EXPLICIT LINE SPLITTING WITH NEWLINE (different heights and data)\n", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

    It was created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

LABELED_GRID_STYLE = TableStyle(

    [('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),

     ('BOX', (0,0), (-1,-1), 2, colors.black),

     ('LINEBELOW', (0,0), (-1,0), 2, colors.black),

     ('LINEAFTER', (0,0), (0,-1), 2, colors.black),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT')]

    )

    """, styleSheet['Code']))

    lst.append(PageBreak())

    t = Table(data, colwidths, rowheights)

    t.setStyle(COLORED_GRID_STYLE)

    lst.append(Paragraph("This is COLORED_GRID_STYLE\n", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

    It was created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

COLORED_GRID_STYLE = TableStyle(

    [('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),

     ('BOX', (0,0), (-1,-1), 2, colors.red),

     ('LINEBELOW', (0,0), (-1,0), 2, colors.black),

     ('LINEAFTER', (0,0), (0,-1), 2, colors.black),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT')]

    )

    """, styleSheet['Code']))

    t = Table(data, colwidths, rowheights)

    t.setStyle(LIST_STYLE)

    lst.append(Paragraph("This is LIST_STYLE\n", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

    It was created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

LIST_STYLE = TableStyle(

    [('LINEABOVE', (0,0), (-1,0), 2, colors.green),

     ('LINEABOVE', (0,1), (-1,-1), 0.25, colors.black),

     ('LINEBELOW', (0,-1), (-1,-1), 2, colors.green),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT')]

    )

    """, styleSheet['Code']))

    t = Table(data, colwidths, rowheights)

    ts = TableStyle(

    [('LINEABOVE', (0,0), (-1,0), 2, colors.green),

     ('LINEABOVE', (0,1), (-1,-1), 0.25, colors.black),

     ('LINEBELOW', (0,-1), (-1,-1), 3, colors.green,'butt'),

     ('LINEBELOW', (0,-1), (-1,-1), 1, colors.white,'butt'),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT'),

     ('TEXTCOLOR', (0,1), (0,-1), colors.red),

     ('BACKGROUND', (0,0), (-1,0), colors.Color(0,0.7,0.7))]

    )

    t.setStyle(ts)

    lst.append(Paragraph("This is a custom style\n", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

    It was created as follows:

    """, styleSheet['BodyText']))

    lst.append(Preformatted("""

   ts = TableStyle(

    [('LINEABOVE', (0,0), (-1,0), 2, colors.green),

     ('LINEABOVE', (0,1), (-1,-1), 0.25, colors.black),

     ('LINEBELOW', (0,-1), (-1,-1), 3, colors.green,'butt'),

     ('LINEBELOW', (0,-1), (-1,-1), 1, colors.white,'butt'),

     ('ALIGN', (1,1), (-1,-1), 'RIGHT'),

     ('TEXTCOLOR', (0,1), (0,-1), colors.red),

     ('BACKGROUND', (0,0), (-1,0), colors.Color(0,0.7,0.7))]

    )

    """, styleSheet['Code']))

    data = (

        ('', 'Jan\nCold', 'Feb\n', 'Mar\n','Apr\n','May\n', 'Jun\nHot', 'Jul\n', 'Aug\nThunder', 'Sep\n', 'Oct\n', 'Nov\n', 'Dec\n'),

        ('Mugs', 0, 4, 17, 3, 21, 47, 12, 33, 2, -2, 44, 89),

        ('T-Shirts', 0, 42, 9, -3, 16, 4, 72, 89, 3, 19, 32, 119),

        ('Key Ring', 0,0,0,0,0,0,1,0,0,0,2,13),

        ('Hats', 893, 912, '1,212', 643, 789, 159, 888, '1,298', 832, 453, '1,344','2,843')

        )

    c = list(colwidths)

    c[0] = None

    c[8] = None

    t = Table(data, c, [None]+list(rowheights[1:]))

    t.setStyle(LIST_STYLE)

    lst.append(Paragraph("""

        This is a LIST_STYLE table with the first rowheight set to None ie automatic.

        The top row cells are split at a newline '\\n' character. The first and August

        column widths were also set to None.

    """, styleSheet['BodyText']))

    lst.append(t)

    lst.append(Paragraph("""

        This demonstrates a number of features useful in financial statements. The first is decimal alignment;

        with ALIGN=DECIMAL the numbers align on the points; and the points are aligned based on

        the RIGHTPADDING, which is usually 3 points so you should set it higher.  The second is multiple lines;

        one can specify double or triple lines and control the separation if desired. Finally, the coloured

        negative numbers were (we regret to say) done in the style; we don't have a way to conditionally

        format numbers based on value yet.

    """, styleSheet['BodyText']))

    t = Table([['Corporate Assets','Amount'],

               ['Fixed Assets','1,234,567.89'],

               ['Company Vehicle','1,234.8901'],

               ['Petty Cash','42'],

               ['Intellectual Property\u00ae','(42,078,231.56)'],

               ['Overdraft','(12,345)'],

               ['Boardroom Flat Screen','60 inches'],

               ['Net Position','Deep Sh*t.Really']

               ],

              [144,72])

    ts = TableStyle(

        [#first the top row

         ('ALIGN', (1,1), (-1,-1), 'CENTER'),

         ('LINEABOVE', (0,0), (-1,0), 1, colors.purple),

         ('LINEBELOW', (0,0), (-1,0), 1, colors.purple),

         ('FONT', (0,0), (-1,0), 'Times-Bold'),

        #bottom row has a line above, and two lines below

         ('LINEABOVE', (0,-1), (-1,-1), 1, colors.purple),  #last 2 are count, sep

         ('LINEBELOW', (0,-1), (-1,-1), 0.5, colors.purple, 1, None, None, 4,1),

         ('LINEBELOW', (0,-1), (-1,-1), 1, colors.red),

         ('FONT', (0,-1), (-1,-1), 'Times-Bold'),

        #numbers column

         ('ALIGN', (1,1), (-1,-1), 'DECIMAL'),

         ('RIGHTPADDING', (1,1), (-1,-1), 36),

         ('TEXTCOLOR', (1,4), (1,4), colors.red),

        #red cell

        ]

        )

    t.setStyle(ts)

    lst.append(t)

    lst.append(Spacer(36,36))

    lst.append(Paragraph("""

        The red numbers should be aligned LEFT & BOTTOM, the blue RIGHT & TOP

        and the green CENTER & MIDDLE.

    """, styleSheet['BodyText']))

    XY  =   [['X00y', 'X01y', 'X02y', 'X03y', 'X04y'],

            ['X10y', 'X11y', 'X12y', 'X13y', 'X14y'],

            ['X20y', 'X21y', 'X22y', 'X23y', 'X24y'],

            ['X30y', 'X31y', 'X32y', 'X33y', 'X34y']]

    t=Table(XY, 5*[0.6*inch], 4*[0.6*inch])

    t.setStyle([('ALIGN',(1,1),(-2,-2),'LEFT'),

                ('TEXTCOLOR',(1,1),(-2,-2),colors.red),

                ('VALIGN',(0,0),(1,-1),'TOP'),

                ('ALIGN',(0,0),(1,-1),'RIGHT'),

                ('TEXTCOLOR',(0,0),(1,-1),colors.blue),

                ('ALIGN',(0,-1),(-1,-1),'CENTER'),

                ('VALIGN',(0,-1),(-1,-1),'MIDDLE'),

                ('TEXTCOLOR',(0,-1),(-1,-1),colors.green),

                ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),

                ('BOX', (0,0), (-1,-1), 0.25, colors.black),

                ])

    lst.append(t)

    data = [('alignment', 'align\012alignment'),

            ('bulletColor', 'bulletcolor\012bcolor'),

            ('bulletFontName', 'bfont\012bulletfontname'),

            ('bulletFontSize', 'bfontsize\012bulletfontsize'),

            ('bulletIndent', 'bindent\012bulletindent'),

            ('firstLineIndent', 'findent\012firstlineindent'),

            ('fontName', 'face\012fontname\012font'),

            ('fontSize', 'size\012fontsize'),

            ('leading', 'leading'),

            ('leftIndent', 'leftindent\012lindent'),

            ('rightIndent', 'rightindent\012rindent'),

            ('spaceAfter', 'spaceafter\012spacea'),

            ('spaceBefore', 'spacebefore\012spaceb'),

            ('textColor', 'fg\012textcolor\012color')]

    t = Table(data)

    t.setStyle([

            ('VALIGN',(0,0),(-1,-1),'TOP'),

            ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),

            ('BOX', (0,0), (-1,-1), 0.25, colors.black),

            ])

    lst.append(t)

    t = Table([ ('Attribute', 'Synonyms'),

                ('alignment', 'align, alignment'),

                ('bulletColor', 'bulletcolor, bcolor'),

                ('bulletFontName', 'bfont, bulletfontname'),

                ('bulletFontSize', 'bfontsize, bulletfontsize'),

                ('bulletIndent', 'bindent, bulletindent'),

                ('firstLineIndent', 'findent, firstlineindent'),

                ('fontName', 'face, fontname, font'),

                ('fontSize', 'size, fontsize'),

                ('leading', 'leading'),

                ('leftIndent', 'leftindent, lindent'),

                ('rightIndent', 'rightindent, rindent'),

                ('spaceAfter', 'spaceafter, spacea'),

                ('spaceBefore', 'spacebefore, spaceb'),

                ('textColor', 'fg, textcolor, color')])

    t.repeatRows = 1

    t.setStyle([

                ('FONT',(0,0),(-1,1),'Times-Bold',10,12),

                ('FONT',(0,1),(-1,-1),'Courier',8,8),

                ('VALIGN',(0,0),(-1,-1),'MIDDLE'),

                ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),

                ('BOX', (0,0), (-1,-1), 0.25, colors.black),

                ('BACKGROUND', (0, 0), (-1, 0), colors.green),

                ('BACKGROUND', (0, 1), (-1, -1), colors.pink),

                ('ALIGN', (0, 0), (-1, 0), 'CENTER'),

                ('ALIGN', (0, 1), (0, -1), 'LEFT'),

                ('ALIGN', (-1, 1), (-1, -1), 'RIGHT'),

                ('FONT', (0, 0), (-1, 0), 'Times-Bold', 12),

                ('ALIGN', (1, 1), (1, -1), 'CENTER'),

                ])

    lst.append(t)

    lst.append(Table(XY,

            style=[ ('FONT',(0,0),(-1,-1),'Times-Roman', 5,6),

                    ('GRID', (0,0), (-1,-1), 0.25, colors.blue),]))

    lst.append(Table(XY,

            style=[ ('FONT',(0,0),(-1,-1),'Times-Roman', 10,12),

                    ('GRID', (0,0), (-1,-1), 0.25, colors.black),]))

    lst.append(Table(XY,

            style=[ ('FONT',(0,0),(-1,-1),'Times-Roman', 20,24),

                    ('GRID', (0,0), (-1,-1), 0.25, colors.red),]))

    lst.append(PageBreak())

    data=  [['00', '01', '02', '03', '04'],

            ['10', '11', '12', '13', '14'],

            ['20', '21', '22', '23', '24'],

            ['30', '31', '32', '33', '34']]

    t=Table(data,style=[

                    ('GRID',(0,0),(-1,-1),0.5,colors.grey),

                    ('GRID',(1,1),(-2,-2),1,colors.green),

                    ('BOX',(0,0),(1,-1),2,colors.red),

                    ('BOX',(0,0),(-1,-1),2,colors.black),

                    ('LINEABOVE',(1,2),(-2,2),1,colors.blue),

                    ('LINEBEFORE',(2,1),(2,-2),1,colors.pink),

                    ('BACKGROUND', (0, 0), (0, 1), colors.pink),

                    ('BACKGROUND', (1, 1), (1, 2), colors.lavender),

                    ('BACKGROUND', (2, 2), (2, 3), colors.orange),

                    ('TEXTCOLOR',(0,-1),(-2,-1),colors.green),

                    ])

    lst.append(Paragraph("Illustrating splits: nosplit", styleSheet['BodyText']))

    lst.append(t)

    lst.append(Spacer(0,6))

    lst.append(Paragraph("Illustrating splits: split(4in,30)", styleSheet['BodyText']))

    for s in t.split(4*inch,30):

        lst.append(s)

        lst.append(Spacer(0,6))

    lst.append(Spacer(0,6))

    lst.append(Paragraph("Illustrating splits: split(4in,36)", styleSheet['BodyText']))

    for s in t.split(4*inch,36):

        lst.append(s)

        lst.append(Spacer(0,6))

    lst.append(Paragraph("Illustrating splits: split(4in,56)", styleSheet['BodyText']))

    lst.append(Spacer(0,6))

    for s in t.split(4*inch,56):

        lst.append(s)

        lst.append(Spacer(0,6))

    lst.append(Paragraph("Illustrating splits: repeated split(4in,30)", styleSheet['BodyText']))