Re: [jopendocument] Google Docs cannot import spreadsheet created by JOpenDocument.

[Sylvain Cuaz]

Le 26/02/2013 17:05, Daniel Lopez Gonzalez a �crit :
> Hello
Hi

> am trying to use the jOpenDocument library <http://www.jopendocument.org/> to create documents. I
> have executed the example where it creates a spreadsheet - the code compiles and runs OK but when
> I tried to open the document with Google Docs they indicated to me that the format is incorrect.

Indeed, Google freaks out if an automatic style name isn't all lower case. And it uses false as the
default for the displayability of tables. The rc2 version will include an explicit display=true.

Cheers,
Sylvain

[Daniel Lopez Gonzalez]

Can i download the rc2? Is the code operative now?

On Thursday, 28 February 2013 16:34:36 UTC+1, ILM wrote:

Le 26/02/2013 17:05, Daniel Lopez Gonzalez a �crit :

[Alex Buloichik]

On Thursday, February 28, 2013 6:34:36 PM UTC+3, ILM wrote:

Indeed, Google freaks out if an automatic style name isn't all lower case. And it uses false as the
default for the displayability of tables. The rc2 version will include an explicit display=true.

I tried with the  jopendocument -1.3.jar. The same issue. But when I open ods file, then insert space into one empty cell, then save ods, then Good opens it good.
I have to change every sheet in ods file for impot to Google Docs.

[Sylvain Cuaz]

Le 08/10/2013 16:14, Alex Buloichik a �crit :

Hi,

I tried just now with org.jopendocument.sample.SpreadSheetCreation and SpreadSheetFill to import to
google drive and both worked flawlessly. Can you send an ods that doesn't work ?

Cheers,
Sylvain

[Sylvain Cuaz]

Le 12/10/2013 09:22, Alex Buloichik a écrit :
> Hi Sylvain !
>
> See attachment, please.

OK, it's the same issue : Google is missing display=true. Upon investigating this can happen in 1.3
if you use SpreadSheet.addSheet(). As a workaround you can either create all your sheets at once
using SpreadSheet.create(int sheetCount, int colCount, int rowCount) or use createEmpty() and then
Sheet.copy().
This will be resolved in the next release.

Cheers,
Sylvain

[Alex Buloichik]

Hi Sylvain !

Workaround works fine. Thank you.

WBR, Alex.

Cheers,
Sylvain

--

--- You received this message because you are subscribed to a topic in the Google Groups "jOpenDocument" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jopendocument/ChAjl0fD_cw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jopendocument+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Alex Buloichik]

Hi Sylvain !

One more issue with google docs:

When I set columns width like "sheet.getColumn(1).setWidth(60);" it displays good in LibreOffice. But when I imports ods into Google Docs, width is much lesser(about 30% of my width).

If I open ods in the LibreOffice, save it, the Good Docs displays width correctly.

WBR, Alex.

[Sylvain Cuaz]

Le 19/10/2013 06:14, Alex Buloichik a �crit :

Hi,

Google doesn't accepts length in millimetres, you could try to file a bug report so they handle
more units of measure : see section 18.3.18 of OpenDocument-v1.2-os-part1 and
http://www.w3.org/TR/2001/REC-xsl-20011015/slice5.html#section-N8185-Definitions-of-Units-of-Measure

Cheers,
Sylvain