OpenTBS

All OpenDocument Format (ODF) and Office Open XML (OOXML) can be merged with OpenTBS, and also XPS files (XPS is a PDF competitor provided by Microsoft).

In fact, all zip archives containing Xml/Html/Text files can be merged with OpenTBS.

OpenTBS basically extracts data from those two formats and delivers it as a ZIP archive.

Features:

• Design templates directly with OpenOffice or MS Office.
• No exe file needed to merge documents.
• No temporary files needed to merge documents.
• Output directly as an HTTP download, a new file on the disk, or as a string (for file attachment for example).
• Works with both PHP 4 and PHP 5.
• No PHP extension is required (If the Zlib extension is enabled it becomes easier to use templates, see more detail below)
• OpenTBS has automatic extension recognition
• Add and delete files in the archive.

What is new in this release:

• Bug fixes:
• XLSX corruption when merging a float value to a cell when the decimal separator is not a dot because of the locale setting.
• Possible DOCX corruption when using text box or tables in header and footer.
• Produce a corrupted Ms Office document when delete the last series of a chart using command OPENTBS_CHART. May happens with other series.

What is new in version 1.9.0:

• New features:
• New command OPENTBS_SELECT_FILE
• New command OPENTBS_SELECT_HEADER
• New command OPENTBS_SELECT_FOOTER
• New command OPENTBS_GET_HEADERS_FOOTERS
• New command OPENTBS_SEARCH_IN_SLIDES
• New param
• Bug fixes:
• Corrupted MS Office files when inserting images named with space or accent.
• XLSX warning for corrupted subfile "/xl/calcChain.xml-Part".
• Some ODS templates compatible with Ms Excel can become erroneous for Ms Excel after the merge with OpenTBS. Message "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt".
• Some XLSX templates built with LibreOffice can be very long to be opened with OpenTBS. That is because LibreOffice add some extra useless rows definition at the bottom limit of the sheets.
• A big number merged in a XLSX with parameter "ope=tbs:num" can display another value. Example : 7580563123 displays -1009371469 in 32bits.
• Inappropriate error message "ExtType is not defined" when execute a command but no template is loaded.
• OPTBS_SELECT_SHEET with an ODS template do nothing. Now it selects the main file (contains all sheets).
• OPTBS_SELECT_SLIDE with an ODP template do nothing. Now it selects the main file (contains all slides).

What is new in version 1.8.1:

• New feature:
• The loaded template can be a PHP file handle.
• Enhancement:
• Ms Excel Sheets are now saved with explicit references for rows and cells, so merged templates are viewable with Libre Office and other third viewers.
• Keywords for changing cell types is the same for LibreOffice and Ms Office.
• Fixed bug:
• A DOCX file could be corrupted when using "block=tbs:page" and the last paragraph of the document has no text.

What is new in version 1.8.0:

• New feature:
• Automatically cleans up spelling in PPTX templates (such information may deconstruct the TBS tags). This feature can be disabled.
• New feature:
• Block Alias helps to define TBS blocks easily on pages, sections,....
• Merging a chart from its title.
• New parameter "tagpos" to define the position of the TBS tag realtively to the image (when using "ope=changepic").
• New parameter "delcol" to delete columns in tables.
• New parameter "mergecell" to merge cells in tables.
• Enhancement:
• Merging charts is also available for LibreOffice documents
• When using "ope=changepic", default value of parameter "default" is now "current".
• Delete unused pictures.
• New command OPENTBS_SELECT_SLIDE
• New command OPENTBS_DELETE_SLIDES
• New command OPENTBS_DISPLAY_SLIDES
• New command OPENTBS_COUNT_SLIDES
• New command OPENTBS_MERGE_SPECIAL_ITEMS
• New command OPENTBS_CHANGE_PICTURE

What is new in version 1.7.6:

• Restored lost spaces around merged TBS fields in Microsoft Word documents. The patch doesn't work for headers and footers, unfortunately.

What is new in version 1.7.5:

• Avoid erroneous Ms Word merged documents when duplicating objects such as drawings and shapes.
• Based on TbZip version 2.11
• New coding shorctut $TBS->TbsZip.
• More examples of formulas for Xlsx and Ods speadsheets.

What is new in version 1.7.3:

• Fixed bug:
• In Ms Word documents, automatic fields (onload, onshow) placed in headers and footers with parameter "ope=changepic" are producing an erroneous merge.
• In Word 2010 the picture may by missing, in Word 2007 the docx file may be considered as corrupted.

What is new in version 1.7.2:

• Fixed bug: error when using command OPENTBS_SELECT_SHEET with a sheet name: Notice: Undefined index: xxx in xxx on line 1986.

What is new in version 1.7.1:

• Fixed bug: first non empty cell of an Excel Spreadsheet is never merged if it contains a TBS field.
• Minor internal improvements.

What is new in version 1.7.0:

• New parameter 'adjust' for changing picture size
• New command OPENTBS_DEBUG_INFO
• New command OPENTBS_SELECT_MAIN
• New command OPENTBS_SELECT_SHEET
• New command OPENTBS_DISPLAY_SHEETS
• New command OPENTBS_DELETE_SHEETS
• New command OPENTBS_DELETE_COMMENTS
• New command OPENTBS_DELETE_ELEMENTS
• Parameter 'changepic' is optimized

What is new in version 1.6.2:

• Fixed bug:
• Ms Excel cells could considee as error some formatted values such as '0.00000000000000'.

Requirements:

• PHP 4.3 or higher
• TinyButStrong 3.7.0 or higher
• Zlib extension enabled in PHP