calc chart not rendered

Asked by daniel herrera on 2014-04-19

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:
2014-06-23
Last reply:
2014-06-23

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

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.

Launchpad Janitor (janitor) said : #3

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

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

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.
>

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.
>

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.