Stack Overflow
Stack Overflow

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
1
vote
1 answer

Can't load a .doc extension file with TBS/OPENTBS

I'm trying to load a .doc file (MS WORD 2007) with only Office. But I've a pop-up asking me the encoding type. What is happening is that the template can't be loaded with errMsg. But if I edit the file with only Office and then try to load it, it…
Rayan Joseph AKEL
  • 13
  • 3
1
vote
1 answer

"The file 'file.odt' is corrupt and therefore cannot be opened." when change picture using OpenTBS

I'm testing the OpenTBS library to use it to generate a document in my project. I created a .odt file in LibreOffice with the image as stated in the documentation and other posts on StackOverflow. However, when I change the image, after saving the…
ciastekkkk
  • 89
  • 7
1
vote
0 answers

Error when changing an image using TBS/openTBS

I'm trying to use tbs/opentbs with PHP to switch out an image in my docx file. I'm using TBS 3.14.0 OpenTBS 1.10.0 PHP 7.2.5 The docx file does download. When I open it using MS Word 2021 I get the following message: Word found unreadable content…
Whiskeyjack
  • 11
  • 1
1
vote
1 answer

Problem when generating an odt with opentbs, values of the same key displayed on the same row and not in column

I'am using a library called OpenTbs to create an odt with PHP, I use it because dynamically generates columns and rows. I know how to create the rows and the columns, what I don't know is how to organize them. let me add an example: So first I will…
haruk1515
  • 358
  • 2
  • 10
1
vote
1 answer

OpenTBS doesn't generate dynamic columns

So I will start giving a little of context, in my actual project I'am trying to use a library called OpenTBS to generate dynamical columns into an odt, I followed the documentation and it gives me this error: TinyButStrong Error in block's…
haruk1515
  • 358
  • 2
  • 10
1
vote
1 answer

image in OpenTBS not changing

I'm trying to show a series of pictures and comments in a document with OpenTBS. The pictures are hosted on a local webserver. The data is in an array. In the resulting document the text lines are rendered as expected, but the sample image is not…
ivomans
  • 31
  • 7
1
vote
1 answer

Use of ifempty in openTBS docx template

I am trying to use the ifempty attribute in a docx template to choose from 2 available variables. I do not have access to the php files. I am just a user of a system using tbs to allow custom export. Here are the results of my tests (var.first is…
Sandrine Berthier
  • 21
  • 2
1
vote
1 answer

Template engin for e-mails

I use opentbs for document templates (writer and ms word). Now I want to use opentbs also for write e-mails. So that I can read an .msg file prepared from the office and than add senders, customer names, ... so that I have an individual e-mail. is…
Andreas_K
  • 11
  • 1
1
vote
1 answer

OpenTBS/TinyButStrong Is Not Replacing Merge Fields In DOCX

I'm trying to use the OpenTBS/TinyButStrong library to replace merge fields in a word document. We can take a very basic word document like this: Hello, My Name Is Bob, My Age Is <> Which in word has the following code: {MERGEFIELD…
Glen Elkins
  • 867
  • 9
  • 30
1
vote
1 answer

Calc : cell format converts empty date to '30/12/1899'

In my LibreOffice Calc spreadsheet, I have a block with a line for each data array (with block:tbs-row) one of the values is a date, which is sometimes empty With [blk1.DT_FIN_ABONNEMENT;noerr;frm=dd/mm/yyyy;ope=tbs:string], I have a text value when…
veroniqueg
  • 41
  • 6
1
vote
1 answer

TBS - Merge string with semicolon into list inside if then statement

When I run the following TBS template (.docx) the single quotes (') still remain on the final docx output. If I remove these, then special characters like semicolon (;) ruins the template, and not all list elements will be shown. How can I keep…
user2984101
  • 21
  • 7
1
vote
0 answers

Merging data into DOCX fails using opentbs

I've been using OpenTBS for the past year with PHP/MySQL to merge data into an MS Word DOCX document with no problems. I populate 2-3 large nested arrays as merge blocks and the resulting Word document is 50+ pages long. Performance has never been…
Owen
  • 11
  • 3
1
vote
0 answers

How to repeat the cellmerging in XLSX with openTBS?

Let me try to describe the problem in words. I have a headline in my array which should be centered in two merged cells. When opentbs is looping throug my array, only the first headline is in a merged cell, for all upcoming headlines the cellmerging…
seppel
  • 11
  • 1
1
vote
1 answer

openTBS - new page after 4 rows in table

i need to create a page break in my ods file after 4 rows in my table. i have tried some suggestion i found here but nothing worked. Here is my code for the table: [ps.pos]…
creadude
  • 11
  • 4
1
vote
0 answers

Function not found in onformat but... it exists

As you can see in this image: https://drive.google.com/open?id=0B6xqoAmB-uxZRTRuQmgzZDBvWXM I get an error for a not found function in an onformat parameter, but the function is there! Any hint on what else could I'm doing wrong? Thank you
Fabrizio Lodi
  • 21
  • 3
1
2
3
…
12 13