TinyButStrong Forum

Re: Apostrophe error

2017-02-17 08:36:59

The correct syntax is:
[code][onload; if [var.omnic] = 0; then 'fornita dall''impianto'][/code]

Re: Multiple pages - lost image after second page

2017-01-04 15:45:46

I have the same problem with an image only appearing on the first two pages... but the fix doesn't help for me (LibreOffice 5.1.x).

This is my template:
[code]
[mydata.image;ope=changepic;block=tbs:page][mydata.pat_id]
[mydata.dna_nr]
[mydata.name]
[mydata.gebdat]
[/code]

This is the array:
[code]
Array
(
[0] => Array
(
[image] => /srv/redcap/htdocs/plugins/hih/qrcode.png
[pat_id] => ID12345
[dna_nr] => D27893
[name] => NAME
[gebdat] => *DATE
)

[1] => Array
(
[image] => /srv/redcap/htdocs/plugins/hih/qrcode.png
[pat_id] => ID12346
[dna_nr] => D27894
[name] => NAME
[gebdat] => *DATE
)

[2] => Array
(
[image] => /srv/redcap/htdocs/plugins/hih/qrcode.png
[pat_id] => ID12347
[dna_nr] => D27895
[name] => NAME
[gebdat] => *DATE
)

)
[/code]

This ist the XML debug output of the template:
[code]

ID12345

D27893

NAME

*DATE

ID12346

D27894

NAME

*DATE

ID12347

D27895

NAME

*DATE

[/code]

Thanks for any help,
Christian

Re: Merge document footer in OpenOffice odt

2016-11-03 14:20:45

Hi Jan,

As explained in the documentation, the command OPENTBS_SELECT_FOOTER is useless with OFT simply beacause headers and footers are stored in the main sub-file.

Your second code « $TBS->MergeBlock('h', $header) » has no effect because block "h" has already been merged previously. If its' another physical block, then use another name.

Re: Rendering of HMTL stored in my database records

2016-09-27 09:40:16

Hi JPG,

That's the problem of storing rich text (bold, underline, italic, ...) with a final format (HTML).
That's also why some software store riche text in a simplified format (like BBcode).

It would be quite difficult, probably impossible, to perform a function that fully translates HTML to ODT.
I simple solution is simply to use the PHP function strip_tags() in order to delete HTML tags keeping the text.
A more complicated solution is to start a function that does some translation from HTML to ODT but you have to make it.

Re: Problem adding a checkbox in a table

2016-06-17 16:14:29

I got it !

The solution to check the checboxes was to add this in additional information :
[parts2.checked;att=form:current-state;ope=msk:*]

I think the clue is to have the aame data array in the additional information and in the help property, in my case parts2

code to simplify header and footer merge (OPENTBS_SELECT_HEADER/OPENTBS_SELECT_FOOOTER)

2016-05-20 12:01:05

Changing the following 5 lines in tbs_plugin_opentbs.php makes OPENTBS_SELECT_HEADER/OPENTBS_SELECT_FOOOTER more useful when using odt templates.
Otherwise you have to do a manual $tbs->PlugIn(OPENTBS_SELECT_FILE, "styles.xml"); and you have to write different code for .docx and .odt.

Great thanks to all who made this template engine such a great software !

[code]
--- a/external/tinybutstrong/plugins/tbs_plugin_opentbs.php
+++ b/external/tinybutstrong/plugins/tbs_plugin_opentbs.php
@@ -614,7 +614,10 @@ class clsOpenTBS extends clsTbsZip {
$x2 = intval($x2); // 0 by default
$file = $this->MsWord_GetHeaderFooterFile($Cmd, $x1, $x2);
break;
- case 'odt': case 'ods': case 'odp':
+ case 'odt':
+ $file = "styles.xml";
+ break;
+ case 'ods': case 'odp':
$file = $this->ExtInfo['main'];
case 'xlsx': case 'pptx':
return false;
[/code]

Re: Changepic adjust doesn't make a difference

2016-04-15 23:14:53

Hi Skrol29,

I am using CentOS 7 (headless) with libreoffice 4.3.7.2-5.el7_2.1 to do the merge.
Here's the template file: https://www.dropbox.com/s/pom910eefy3x64k/test.odt?dl=0

Re: Need help to formation table

2016-03-29 23:34:00

It is too diffuclt for no, it would need an upgrade of TBS.
The problem is ODT saved the number of spanned cell in the first cell but TBS knows the number of spanned cells only during the merge.

Re: Need help to create odt

2016-03-25 15:09:47

Thanks. I fixed the problem. All is working now

Re: How to get number of rows of a sub block having conditions

2016-03-15 11:00:53

Thank Skrol29

Re: OpenTBS MergeField acting irregularly

2016-02-24 14:11:10

I had a look at the zip archive for the problematic document and there are some clear irregularities in the problem areas. Additionally, I've found other documents merge fields without issue. I think the problem is that the template I'm using is originally a heavily formatted word file which I'm opening through open office leading to the content.xml file's structure getting garbled. Thanks very much for your assistance in developing this application, you've been a great help!

Re: Merging cells vertically in .odt

2016-02-22 23:35:52

Hi Nico,

This feature is more complicated for LibreOffice than for Ms Word because LibreOffice use a special entity for cells that are covered by a merged cell.
So it can be done, but not the same way as for Ms Word tables.

Preparing data w'ont help you for this. The point is to transform a entity into .

I think this will be included in the next OpenTBS version.

Re: OpenTBS doesn't merge blocks when using tab stops in the document

2016-02-16 23:07:18

Hi DenisW,

This problem is well know and should be mentioned in the demo templates soon.
When the TBS tag is split in the inner XML, then it is not merged, or badly merged.

The workaround is to select the TBS tags, then cut, and then paste as « unformatted text ».
This should avoid inner split.

Regards,

Re: How to add one "odt" file into another "odt" file? (i use opentbs plugin)

2016-02-05 12:17:13

Hi, this would be very useful. At least to read a block from another file (e.g. a certain table) and place into the current template (replacing aplaceholder or something).

The usecase would be (in my case) a serial letter with a fixed template, but all get a common settlement table on a last page uploaded by the operator for this particular serial letter issue. I don't want the operator to edit and upload the whole template, since Word destroys the OpenTBS placeholders randomly from time to time (by inserting spaces after the . or some magic invisible stuff).

Re: Grouping multidimensional datas with tables

2015-12-16 19:27:52

Cool! It's working now.

Thank you so much!
Martin