TinyButStrong Forum in English http://www.tinybutstrong.com/ http://www.tinybutstrong.com/forum.php?msg_id=15248 Hi Skrol29,

thanks for help, works perfect! 2016-03-21 16:21:09 http://www.tinybutstrong.com/forum.php?msg_id=15148 Hi,

It seems that you ODS file is not exactly the same on the two platforms.
Maybe the ODS on your Debian get some bad binary content at the beginning or at the end, or because of a bad FTP transfer.

The code in OpenTBS for reading the Central Directory is platform-independant and even don't use the zip extension of PHP.




2016-02-12 18:23:40 http://www.tinybutstrong.com/forum.php?msg_id=14648 Bonjour,

Pour les totaux, tu peux les calculer côté PHP et les enregistrer dans les entité de niveau Classe et Compte.
Tu peux essayer le plug-in Aggregate (voir ici http://www.tinybutstrong.com/plugins.php). Ce plug-in peut s'installer avec OpenTBS.
Mais en tout état de cause je pense que tu n'y arriveras pas avec des formules de total dans l'ODS. Ces formules deviendront incohérentes lors de la fusion car elles sont enregistrées avec les références des cellules.

Une fois que tu as calculé les totaux, il suffit d'ajouter un ligne dans le bloc correspondant.
Exemple:[code]
[detail.cod_class;block=tbs:row+tbs:row+tbs:row+tbs:row+tbs:row;sub1=list_cpte] (défini sur 5 lignes y compris sa ligne de total)
[detail_sub1.cod_cpte;block=tbs:row+tbs:row+tbs:row;sub1=detail_cpte] (défini sur 3 lignes y compris sa ligne de total)
[detail_sub1_sub1.lib_ecrit;block=tbs:row]
Total Compte : [detail_sub1.total_compte]
Total Classe : [detail.total_class]
[/code] 2014-12-10 01:14:07 http://www.tinybutstrong.com/forum.php?msg_id=14528 So I found the solution form my problem. Using strconv=utf8 solved it.

I find it strange because this was not necessary for xmlx 2014-10-10 11:13:54 http://www.tinybutstrong.com/forum.php?msg_id=14491 This is great! Thanks a lot Skrol29

There is just one thing that i find annoying about Excel. If you change something in your template, the style-names keep changing value. I'm using Excel 2010 for building templates in ODS format. It is strange that there is a difference between Excel en LibreOffice OSD format.
I have a tab where i make all my special cell styles. This tab can be invisible. This makes it easier to get the style-name (manually) out of the ODS file. Is there a way to read the table:style-name from a cell. Lets say i have a cell in the hidden tab with the value "higher" and i made the background red. Than the style-name can have a value of "ce6" for example. If i could read the "ce6" from within TBS, than i wouldn't have to do this manually and i wouldn't have to worry about Excel changing the style value every time i made a change to the template.

Keep up the good work. 2014-09-30 15:35:11 http://www.tinybutstrong.com/forum.php?msg_id=14288 hmm, tried using plugins method but still running into memory limit problem.

is it still using array before merging with the xml file?
is there anyway to overcome this?


before this i was using a simple xls where the output is just echoed with specific header and never run to a memory limit problem.
http://www.appservnetwork.com/modules.php?name=News&file=article&sid=8 2014-07-07 13:15:02 http://www.tinybutstrong.com/forum.php?msg_id=14263 Ah d'accord, j'aurais dû faire une recherche plus rigoureuse avant de poster.

Merci 2014-06-18 17:05:36 http://www.tinybutstrong.com/forum.php?msg_id=14175 > Pourrais-tu renommer le sujet en quelque chose qui contiendrai "OTS"

Ok, c'est fait :)
Merci à toi. 2014-04-29 17:13:01 http://www.tinybutstrong.com/forum.php?msg_id=13831 Thank you for this fix !!!
It seems to work.

About the "calcext:value-type" attribute, I have readed this somewhere (well, here: http://en.libreofficeforum.org/node/6876)
"Elements and attributes beginning with calcext: are extensions to the ODF v1.2 specification, made in an interim manner until ODF v1.3 is formalised. The effect of this particular attribute (introduced in the v4.0 series) is described in the related commit (it is part of an attempt to speed up the importing of data by saving on string checking)"
Mentioned commit is this http://cgit.freedesktop.org/libreoffice/core/commit/?id=9fb60c6a7390f782f1878f0e943ba17fd419ebab 2013-12-18 13:30:10 http://www.tinybutstrong.com/forum.php?msg_id=13812 Hi, did you solve your problem ? 2013-12-13 02:32:16 http://www.tinybutstrong.com/forum.php?msg_id=13202 [code]$TBS->Show(OPENTBS_FILE, $file_name_with_path);[/code] 2013-04-20 19:25:54 http://www.tinybutstrong.com/forum.php?msg_id=12938 Here is an example of my data (my $data1 variable):

[code]
Array ( [0] => Array ( [name] => CVS Caremark Corporation [revenue] => 107100.0 [city] => Woonsocket [state] => RI [impacts] => Array ( [0] => Array ( [solution_name] => Managed Print Services [solution_impact] => 5396181.3842505 ) [1] => Array ( [solution_name] => CRM Service [solution_impact] => 95400694.7952 ) ) ) [1] => Array ( [name] => Textron Inc. [revenue] => 11275.0[city] => Providence [state] => RI [impacts] => Array ( [0] => Array ( [solution_name] => Managed Print Services [solution_impact] => 568085.38849137 ) [1] => Array ( [solution_name] => CRM Service [solution_impact] => 10043350.45578 ) ) )
[/code]

As you can see its pretty standard array 2012-12-31 01:14:14 http://www.tinybutstrong.com/forum.php?msg_id=12901 Hi,

When the main ODT is already loaded, you can load a sub-file using:[code]
$TBS->LoadTemplate('#Object 1/content.xml');
[/code]
After that you can start the merge data in this sub file.

It happens that this subfile is the content of an ODS file. Nevertheless, strictly speaking, it is not an ODS file. An ODS file should be a zip archive with XML subfiles.
2012-12-17 22:49:31 http://www.tinybutstrong.com/forum.php?msg_id=12557 > I have to use the file_put_contents, because of the way our downloading works,
> if I don't, when I have the show command, all I get is
> mime encoded display stuff ( ? and other odd characters ).

If you use $TBS->Show(OPENTBS_FILE, $file_name); then it should do the same and it costs less memory.
With OPENTBS_FILE, only modified sub-file are saved in memory, other sub-file are taken directly from the template file. 2012-07-24 10:26:56 http://www.tinybutstrong.com/forum.php?msg_id=12534 You're right, I didn't mention about the odt. Thank you for the update.

You're right about the element table-column too. Modifying the template as you said solved the problem. Wish I can pay you back. Thank you. 2012-07-16 18:49:14