# LuaLatex, \includespread and libreoffice table with %

I've using LuaLatex for the last couple of days and been enjoying it despite of lack of documentation on \includespread. Nevertheless, got it to work for tables that don't have a percentage value (e.g.: 10% in a cell).

Is this a bug or a feature? How can I include a spreadsheet with percentage values?

• 10\% You have to escape the % character
– user2478
Dec 11 '14 at 11:38
• @Herbert Escaping with a "\"... Should've thought about that... Using that, I'll have to duplicate any cell with a % to have a value that can be use to calculate stuff (hidden) and another to show (and be imported by includespread).
– Marc
Dec 11 '14 at 12:13
• give a complete and small example which shows your problem.
– user2478
Dec 11 '14 at 12:24
• I think that the problem is with my odsfile package, respective version which is on CTAN, it can include open document spreadsheets and it has problem with character escaping. I should probably upload current development version, which solves these problems, although some bugs are still unsolved Dec 11 '14 at 12:30
• I uploaded odsfile v0.4 to CTAN, bug with escaping is fixed in this release Dec 11 '14 at 13:06

Edit:

OP provided some test files, which showed few new issues. Those issues should be fixed now and updated package will find its way to CTAN and TeX Live soon, hopefully.

There is one issue with your code:

\begin{table}[ht]
\label{tab:stuff_cal}
\centering
\begin{tabular}
\end{tabular}
\caption{Stuff calculated in a ods.}
\end{table}


you use \begin{tabular} without specifying columns, and TeX parser reads next token, which is \includespread. So it is newer executed. As you defined template table_3c as full tabular environment, you really don't need to start tabular here and just use \includespread alone.

I suppose you are talking about my odsfile package. Behaviour you describe is a bug which was fixed some time ago, but I haven't posted fixes to CTAN until today (I am really bad in posting stuff to CTAN). So thank you for remind me. Some other bugs were fixed as well in this release, so you should update your TeXLive distribution as soon as the update gets here.
you can see from the screenshot from PDF generated from ODS spreadsheet that not only special characters such as % or \$ works, but also some basic styles such as bold text works, as well as external links
• @Marc there was bug in your code as well as there were bugs in odsfile. I will add details about fix for your code here, updated odsfile is on Github and I uploaded it to CTAN as well Dec 11 '14 at 22:19