All notable changes to this project will be documented in this file.
OPENTBS_GET_FILES_BY_TYPE supports new keywords : 'all' and 'slidem'
PPTX : better XML clean for TBS fields recognition.
Charts with MsOffice: merging values or categories that have special characters (like <, >, &) did produce an invalid document. No error is prompted during the merge but an error is prompted by Ms Office when opening the document.
Command OPENTBS_GET_CELLS with ODS : it used to get only the first line of a string value. Now it support multi-lines and it take formats off.
New command OPENTBS_GET_CELLS for reading range in a workbook.
Parameter « ope=delcol »
New parameter « ope=docfield » enables you to replace document calculated fields with TBS fields.
DOCX only: some spaces between words could be not displayed in LibreOffice.
Alias of block « tbs:draw » did not work correctly with MsWord.
some TBS fields seems to be ignored in ODT files edited with LibreOffice 4 or higher. This was due to a new RSID feature in LibreOffice that inserts invisible XML elements.
no data displayed when merging numerical cells in ODS files built with LibreOffice 4 or higher. This was due to a new attribute in subjacent XML elements.
Supports new parameter "parallel" of TinyButStrong 3.9.0.
based on TbsZip 2.15
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.
based on TbsZip 2.14
automatically cleans up spelling in PPTX templates (such information may deconstruct the TBS tags). This feature can be disabled.
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.
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
parameter "ope=changepic" did not work in PPTX documents.
parameter "ope=changepic" did not work with [onload] fields in Ms Office.
parameter "default=current" did not work when using MergeField() instead of MergeBlock().
some tab may be deleted in the template (during the automatic cleanup process).
merging charts is also available for LibreOffice documents
when using "ope=changepic", default value of parameter "default" is now "current".
delete unused pictures.
based on TbsZip 2.13
requires TBS 3.8.0
Based on TbZip version 2.11
New coding shorctut $TBS->TbsZip.
More examples of formulas for Xlsx and Ods speadsheets.
parameter "defaut=current" does not work and may build invalid documents when the target image is missing.
new command OPENTBS_REPLACEFILE
new command OPENTBS_FILEEXISTS
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
some documents may be corrupted when created using OPENTBS_DOWNLOAD because of a PHP error "supplied argument is not a valid stream resource" or "Undefined property: clsOpenTBS::$OutputHandle".
using keyword "xlsxNum", "xlsxDate" or "xlsxBool" inside a cell that is not merged can make a corrupted XLSX spreadsheet.
updated templates in the demo.
based on a TbsZip v2.8
merge charts in Ms Word documents.
merge rows and columns Ms Excel workbooks.
new "ope" parameters for forcing cells type in Ms Excel (Numeric, Date and Boolean).
debug mode enhanced.
force the type of document using command OPENTBS_FORCE_DOCTYPE.
deal with apostrophes using property OtbsConvertApostrophes.
if the document extension is not recognized, then try to recognize document type by sub-file presence.
can use the Direct Command feature of TBS 3.7.0.
based on a TbsZip v2.6
headers and footers are automatically loaded for OpenOffice & MsOffice.
automatically cleans up spelling and change trackings information in MsWord templates (such information may deconstruct the TBS tags). This feature can be disabled.
new constant OPENTBS_DEBUG_AVOIDAUTOFIELDS
in debug mode: "warning function.str-repeat: Second argument has to be greater than or equal to 0"
when using OPENTBS_RESET: "Warning: Missing argument 2 for clsOpenTBS::OnCommand() in ... on line 225"
DML images were not found when using parameter "ope=changepic" in a DOCX document
the script ends and display the XML contents when a when using parameter "ope=changepic" with a new image type in a DOCX document
Debug doesn't stopped if an OpenTBS alert occurs.
OpenTBS alerts say if the process will be stopped.
based on TbsZip version 2.1: fixes a bug that saved a bad time of modification file was added, and saved time modification when a file content is replaced.
the addpic operator now automatically updates the "fanifest.xml" file on OpenOffice document. Without this fix, an ODP merged document could be open with an error message with OpenOffice >= 3.2
a new plugin command that add a new file in the archive
a new plugin command that delete a new file in the archive
a parameter 'ope=addpic' that add a new picture in the archive directly from the template
render option : OPENTBS_STRING
can reset changes in the current archive using $TBS->Plugin(OPENTBS_PLUGIN, OPENTBS_RESET);