calc chart not rendered

Asked by daniel herrera

In a LibreOffice Calc Sheet I have inserted a simple Chart. DataRanges of this chart "includes fixed python" cells.

Ex: DataRange is $E$61:$G$63 where F62 contains ="fromPythonValue" and this cell is NOT include in any kind of loop ( Not "do row ... " ) Also, I verify than F62 value is right.

Issue is that chart is no rendered when I open the generated document ... but, when I doubleclick over the chat, then the chart is refreshed and take right values. Chart is also updated if I press F9 ( https://help.libreoffice.org/Calc/Recalculate )

You know some workaround about this issue?

==================================

PE: LibreOffice 4 refresh charts on open.

==================================

Congrats about your appy library its a powerful package.

Question information

Language:
English Edit question
Status:
Answered
For:
Appy Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Gaëtan Delannay (gaetan-delannay) said :
#1

Hi,
I have no workaround sorry. pod for ODS is quite new; the current implementation is quite minimal. Feel free to explore and improve the product.
Cheers
Gaetan

Revision history for this message
daniel herrera (ctrl-alt-d) said :
#2

Hello Mr Gaëtan,

perhaps the issue is than appy don't change the cell type:

I found this text on content.xml:

<table:table-cell table:style-name="ce30">
<text:p>85896938</text:p>
</table:table-cell>

And I think the right text should be:

<table:table-cell table:style-name="ce30" office:value-type="float" office:value="85896938" >
<text:p>85896938</text:p>
</table:table-cell>

I think your product is very good, in concept and implementation, I use it for 2 years generating reports in my school. Now, I have downloaded your code, if you introduce me on it I can try to fix the issue if you want. Just a brief description what to search and where (you have 606 files on 59 folders ;). You can contact me at ctrl.alt.d at gmail.

Regards,
daniel.

Revision history for this message
Launchpad Janitor (janitor) said :
#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Gaëtan Delannay (gaetan-delannay) said :
#4

Hi Daniel,

As explained on http://appyframework.org/pod.html, if your cell F62 contains ="fromPythonValue" and variable fromPythonValue contains a Python int or float, appy.pod will indeed produce something like:

<table:table-cell table:style-name="ce30" office:value-type="float" office:value="85896938" >
<text:p>85896938</text:p>
</table:table-cell>

Are you sure you havent't put a float represented as a string into "fromPythonValue" ?
Thank you,
Gaetan

Revision history for this message
daniel herrera (ctrl-alt-d) said :
#5

Hello Gaëtan,

Do you need I have new tests?

Daniel
 El dia 23/06/2014 17.12, "Gaëtan Delannay" <
<email address hidden>> va escriure:

> Your question #247254 on Appy changed:
> https://answers.launchpad.net/appy/+question/247254
>
> Gaëtan Delannay posted a new comment:
> Hi Daniel,
>
> As explained on http://appyframework.org/pod.html, if your cell F62
> contains ="fromPythonValue" and variable fromPythonValue contains a
> Python int or float, appy.pod will indeed produce something like:
>
> <table:table-cell table:style-name="ce30" office:value-type="float"
> office:value="85896938" >
> <text:p>85896938</text:p>
> </table:table-cell>
>
> Are you sure you havent't put a float represented as a string into
> "fromPythonValue" ?
> Thank you,
> Gaetan
>
> --
> You received this question notification because you asked the question.
>

Revision history for this message
daniel herrera (ctrl-alt-d) said :
#6

Solved moving to LibreOffice4.X

Congrats again about your code.

Daniel.
 El dia 23/06/2014 19.36, "daniel herrera" <
<email address hidden>> va escriure:

> Your question #247254 on Appy changed:
> https://answers.launchpad.net/appy/+question/247254
>
> Status: Expired => Open
>
> You are still having a problem:
> Hello Gaëtan,
>
> Do you need I have new tests?
>
> Daniel
> El dia 23/06/2014 17.12, "Gaëtan Delannay" <
> <email address hidden>> va escriure:
>
> > Your question #247254 on Appy changed:
> > https://answers.launchpad.net/appy/+question/247254
> >
> > Gaëtan Delannay posted a new comment:
> > Hi Daniel,
> >
> > As explained on http://appyframework.org/pod.html, if your cell F62
> > contains ="fromPythonValue" and variable fromPythonValue contains a
> > Python int or float, appy.pod will indeed produce something like:
> >
> > <table:table-cell table:style-name="ce30" office:value-type="float"
> > office:value="85896938" >
> > <text:p>85896938</text:p>
> > </table:table-cell>
> >
> > Are you sure you havent't put a float represented as a string into
> > "fromPythonValue" ?
> > Thank you,
> > Gaetan
> >
> > --
> > You received this question notification because you asked the question.
> >
>
> --
> You received this question notification because you asked the question.
>

Revision history for this message
Gaëtan Delannay (gaetan-delannay) said :
#7

Thank you Daniel :)
No I do not need more tests, I discovered the bug. I will try to publish Appy 0.9.0 today!
Cheers
Gaetan

Can you help with this problem?

Provide an answer of your own, or ask daniel herrera for more information if necessary.

To post a message you must log in.