Questions tagged [opentbs]

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

You can just create a document using MS Office, LibreOffice, or OpenOffice; you can then use this document as a template for OpenTBS, which helps you to merge data, change parts, and get the result as direct download, a saved file, or a binary string in a variable.

Some supported features :

  • Merges data items, records, blocks, conditionals blocks;
  • Change pictures in documents;
  • Change Charts in DOCX, XLSX;
  • Hide/show sheets in XLSX and ODS;
  • Delete comments;
  • Support native connectivity with MySQL, PostgreSQL, or SQLite, PDO;
  • All features of the TinyButStrong Template Engine

Links :

195 questions
0
votes
1 answer

How to add

tags in openTBS docx?

I want add multiple line in one cell with openTBS, but
to is not "real" multiple line. So I'm try to use Text or Text, but cann't open in ms word. So how can I add multiple line in a…
nbsp
  • 161
  • 2
  • 8
0
votes
0 answers

cakephp 2.x + OpenTBS

I am trying to get OpenTBS to work with cakephp 2.x but am having some issues. I found the following thread and have followed it but this is for cakephp 1.x CakePHP + TinyButStrong The differences I made are as follows: TbsHelper class TbsHelper…
sluggerdog
  • 843
  • 4
  • 12
  • 35
0
votes
1 answer

TinyButStrong insert an html inside an odt file
I'm working correctly with TinyButStrong inside my php project: I can replace parts of an odt template file with custom texts, but now I'd like to insert some inside of it. The problem is that it insert the html code nor the interpreted version. Is…
linuxatico
  • 1,878
  • 30
  • 43
0
votes
1 answer

Load a block on xlsx header

is there any way when using openTBS, to send blocks to an .xlsx header? Like we do on word, load the block on header.xml? Thanks in advance, regards UPDATE: yes, i found the header content in /xl/worksheets/sheet1.xml, but still im trying to merge…
Gil
  • 184
  • 1
  • 3
  • 15
0
votes
1 answer

Replicate Excel worksheets dynamically

Is there any way to replicate Ms Excel worksheets dynamically, using openTBS on template side? im used to delimit this in Ms Word with 'Page Breaks' between the block begin and end... What i need is [base;block=begin] "blablabla text...." (Page…
Gil
  • 184
  • 1
  • 3
  • 15
0
votes
1 answer

delimit blocks - openTBS / xlsx,

im using openTBS to make an excel doc. Here is my problem: Im trying to replicate submodules under the parent title ( Red one ) and my output is: is there any way to limit the blocks inside that table? so i can get all the green modules under a…
Gil
  • 184
  • 1
  • 3
  • 15
0
votes
1 answer

opentbs deleting spaces

I'm using openTBS to convert data from a mysql db (via PHP) to some word and excel docs. One of my problems is, openTBS is deleting lots of spaces near the tags.. blablabla [base_sub1.value] blablabla and the output is blablablavalue…
Gil
  • 184
  • 1
  • 3
  • 15
0
votes
1 answer

Adding pic on the fly to MS excel with OpenTBS

It was noted that ope=changepic is not possible on xlsx templates. Is there a workaround to this? Maybe thru addpic? Or maybe modifying the archive? How? Thanks!
jovani
  • 669
  • 8
  • 16
-1
votes
1 answer

How to not replicate an paragraph on tbs:page

I have a template with one page containing a block of tbs:page type. This function replicate greatly my content. But i have a problem. On top of this page, I have a title/topic for my table of contents, but i only need this index on the first page…
-1
votes
1 answer

How add image created in GD to template

I am looking for help with one problem. I would like to create an image using imageJpeg. And this image add to template using openTBS. template: [b.image;ope=changepic;from=[val];default=current;adjust] php: $TBS =…
bsilwa
  • 19
  • 2
-1
votes
1 answer

Insert Files as Objects in Exported Word Document with OpenTBS

I am using OpenTBS to load a word template and complete all the required fields with the information I have. The problem is that I have some related documents (other words, excels, pdfs) for the exported word, that I have to insert as objects in a…
-2
votes
1 answer

TinyButStrong - PHP template engine and OpenTBS docx file conversion to html

Is it possible from .dox file (or OpenXML format) save as html code, modify it with TinyMCE and convert back to previuos file?
dojo
  • 453
  • 1
  • 10
  • 24
-2
votes
2 answers

problem with 'bmagnet' parameter on 2 level table with OpenTBS

I uses OpenTBS to produce IT invoices. I have a problem on a block with a 'bmagnet' on 2 levels table: table + table: table. The problem is on '101' block. When the 'lib' field is missing, the deleted block goes too far and it corruptes the file.…
O.Hot
  • 1
  • 1
-2
votes
1 answer

Can a 'when' conditional section show content based on a 'contains' or 'includes' parameter?

I'm using TBS/OpenTBS (thanks Skrol, it's awesome) to produce Word documents based on form inputs. One of the form fields is a checkbox. Let's say it has ten options. I can display content fine if a single option is selected, but if, say, 4 options…
Richard
  • 1
  • 2
-2
votes
1 answer

Using TinyButStrong (TBS) to generate a PDF from a DOCX

I have used TBS (TinyButStrong) for several PHP projects to generate DOCX or XLSX files based on a template. I am now trying to popular a DOCX template with TBS and generate a PDF at the of the process. It this possible with TBS? It doesnt seem like…
AAA
  • 2,388
  • 9
  • 32
  • 47
1 2 3
12
13