[jopendocument] Re: Support in-memory sheets (and documents read from an URL)

2009-05-28 Thread Sylvain Cuaz
Cafebabe a écrit : The SpreadSheet-API is very File-oriented. I would like to see a way of reading SpreadSheets from an URL or from an in memory byte array: SpreadSheet createFromFile = SpreadSheet.createFromUrl( new URL (url) ); and byte[] bytes = ... SpreadSheet createFromFile =

[jopendocument] Re: adding an image to a document / to a table

2009-05-28 Thread Sylvain Cuaz
Eric Duell a écrit : Is it possible to add a image to a table cell? At least I can answer one part my question, after I imported the source code to my eclipse. Yet it is not able to add a image to a table cell. According to MutableCell.java -- setValue () only allows FLOAT and DATES. Of all

[jopendocument] Re: Multiple Sheets, Naming Sheets

2009-06-05 Thread Sylvain Cuaz
J McBride a écrit : Hello, Hi, I'm trying to use jOpenDocument to create new spreadsheets for presenting data. These spreadsheets need to have multiple sheets within them. I can't find any way within the API to create new sheets. What I'm looking for is something like

[jopendocument] Re: Problem to reopen saved spreadsheet documents

2009-07-28 Thread Sylvain Cuaz
googleuser a écrit : Hello, Hi, i use the jOpenDocument library to save and open OpenOffice spreadsheets. I have the problem that saved data created with the library cannot be reopened with the library. Yes, there was a NPE in ODPackage.getDocument(). It is now fixed, you should be able

[jopendocument] Re: How to create a chart ?

2009-10-05 Thread Sylvain Cuaz
Guillaume Viguier-Just a écrit : Hi, However, I've seen the chart package, but I can't figure out how to create a chart based on the data I have in my spreadsheet, and then include this chart within the spreadsheet. Is it possible to do that ? No for the moment the chart package is

[jopendocument] Re: New line in sheet cell

2009-11-12 Thread Sylvain Cuaz
Alfredo a écrit : Hello: I'm trying to use JOpenDocument and I found a problem: When I get string from open document sheet cell, method SpreadSheet.getValueAt return only text until first new line of the cell text. Is this normal behaviour? Hi, No, thanks for reporting, it's just I had

Re: [jopendocument] Cell Comment

2010-12-14 Thread Sylvain Cuaz
Le 01/12/2010 17:24, abad a écrit : Ho to read a cell comment using the API? Hi, There's no support in the API but it's quite simple : Cell? cell = sheet.getCellAt(A3); XMLVersion version = sheet.getODDocument().getVersion(); Element annot =

Re: [jopendocument] hideSection not works

2010-12-14 Thread Sylvain Cuaz
Le 13/12/2010 11:10, Boymix81 a écrit : Hi, I want management the visibility of some sections in a odt document . In jopendocument library I only find showParagraph and hideParagraph methods in org.jopendocument.dom.template.JavaScriptFileTemplate class . I extend this class with the following

Re: [jopendocument] Merge mutiple text files: page break question

2011-05-10 Thread Sylvain Cuaz
Le 08/03/2011 15:30, fiensi73 a écrit : Hello, I'm trying JOpenDocument library for a project involving complex mail merge with JODReports. I've got 2 questions: 1) Is there a way of creating a new text document? Something like SpreadSheet.createEmpty(model).saveAs(file)? No, but you

Re: [jopendocument] Managing thousand of records with Spreadsheet class for ods files

2012-03-23 Thread Sylvain Cuaz
Le 19/03/2012 15:10, manisha a écrit : Hi, I am using Spreadsheet.createFromFile(new File(curser.ods)) method to loas spread sheet object. curser.ods can have five sheets in which each sheet consists of 1 records. When try to load this file, consuming maximum time(say 2 mins...) and even

Re: [jopendocument] How can i read cell which contains multiple lines?

2012-05-04 Thread Sylvain Cuaz
Le 04/05/2012 13:40, gammoudi neji a écrit : Hello, Hi, I have a method which read all records from an input .ods file, It works well especially for multi-line cell. For multi-line cell i get only the first line and not all the content. It should work, can you provide your

Re: [jopendocument] Re: How can i read cell which contains multiple lines?

2012-05-07 Thread Sylvain Cuaz
Le 07/05/2012 11:01, gammoudi neji a écrit : As you can see only multi-lines cell are not all displayed! Have you modified the exemple.ods file before run the test? No, what version of jOpenDocument are you running ? I think the support for multi-line was added in 1.2. Otherwise try with the

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

2013-02-28 Thread 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

Re: [jopendocument] Open Document - How to remove rows from a sheet?

2013-04-04 Thread Sylvain Cuaz
Le 26/03/2013 22:38, Barry Williams a écrit : In using a spreadsheet template, I have inserted all the rows necessary in the template itself. I then call for the file in opendocument spreadsheet. The data I pass to the spreadsheet does not necessarily need all the data rows that were set, and

Re: [jopendocument] jOpenDocument cannot write booleans

2013-04-04 Thread Sylvain Cuaz
Le 02/04/2013 23:26, PhilipN a écrit : Hi, Hi, I found that using jOpenDocument (even 1.3rc1) it is not possible to write boolean values to a spreadsheet. I suspect part of the issue that jOpendocument doesn't write the proper office:value-type tag in the table cells. AFAICS

Re: [jopendocument] Read and Edit a existing ods file in open state

2013-04-11 Thread Sylvain Cuaz
Le 10/04/2013 12:00, Ruben Cabral a écrit : hi there, I try read and modify an existing spreadsheet, and save it but i need the ods file stay all the time open, is realy necessary, and my code is like this for example. File file = *new *File(template/invoice.ods); *final *Sheet sheet =

Re: [jopendocument] Re: IllegalArgumentException : Cannot get sheets from an ODS file

2013-06-24 Thread Sylvain Cuaz
Le 23/06/2013 13:38, Michal Rajčan a écrit : Good day, I just want to ask, if you have solved your problem? If so, how? I need to do the same task and my project stopped with this same error as yours and i have no idea, how to fix it. Hi, As I've said before, it seems that the file isn't

Re: [jopendocument] Templating doesnt work. EngineTemplate::saveAs creates strange output ?!?

2013-06-25 Thread Sylvain Cuaz
Le 24/06/2013 18:12, kugelphan...@googlemail.com a écrit : Hi everyone! Hi, I'm new to jOpenDocument and try to get the TestTemplate.java example from the sources to work (for the last 8 hours :-//). It compiles ok, and runs also. But this: // Save to file.

Re: [jopendocument] src/org/jopendocument/examples/SimpleOdt2.java

2013-08-01 Thread Sylvain Cuaz
Le 24/07/2013 09:50, Gmail a écrit : Hi, ok fine, This code does not work anymore : ODPackage outputDocument = new ODPackage(new File(styles.odt)); contentDom = outputDocument.toSingle(); final Paragraph paragraph = new Paragraph(); contentDom.add(paragraph); What is the correct way to do it

Re: [jopendocument] Conditional text

2013-08-01 Thread Sylvain Cuaz
Le 31/07/2013 10:09, Jenthe Marien a écrit : Hi I'm developing my first project using jOpenDocument. Is there some way to put Conditional Text in my OpenOffice template as I would do using the OpenOffice api? Hi, Install the addon and see

Re: [jopendocument] Re: IllegalArgumentException : Cannot get sheets from an ODS file

2013-08-27 Thread Sylvain Cuaz
Le 24/06/2013 09:34, Sylvain Cuaz a écrit : Le 23/06/2013 13:38, Michal Rajčan a écrit : Good day, I just want to ask, if you have solved your problem? If so, how? I need to do the same task and my project stopped with this same error as yours and i have no idea, how to fix it. Hi

Re: [jopendocument] Perm Gen out of memory problem with JOpenDocument 3

2013-09-05 Thread Sylvain Cuaz
Le 09/08/2013 10:17, FL a écrit : Hello, In my application Java, I have a tool of migration which allows me to push towards CouchDB (No-SQL DB) in JSON (Jackon), XML(JAXB), and PDF format corresponding to these folders (POJOs/Object Java). In the 500th iteration (approximately) the memory

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

2013-10-11 Thread Sylvain Cuaz
Le 08/10/2013 16:14, Alex Buloichik a écrit : 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

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

2013-10-18 Thread 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

Re: [jopendocument] Issue with SchemaFactory

2013-10-21 Thread Sylvain Cuaz
Le 19/10/2013 06:21, Alex Buloichik a écrit : Hi ! Probably it's not an jOpenDocument's issue, but my configuration issue. I just included jOpenDocument-1.3.jar into classpath, then try to work with xsd schemas: SchemaFactory factory =

Re: [jopendocument] jOpenDocument Sheet.getValueAt(int, int) return value is both a String and a BigDecimal?

2013-10-29 Thread Sylvain Cuaz
Le 18/10/2013 22:41, Florrie O. a écrit : I'm processing a .ods spreadsheet with the jOpenDocument library. Since I was processing strings, everything was ok, but when it comes to process numbers it's a pain. In my code I iterate the spreadsheet and make some computations based on the value

Re: [jopendocument] ant build fails with name clash on debian

2014-06-20 Thread Sylvain Cuaz
Le 17/06/2014 17:15, Manfred Hanke a écrit : Hi, I also got that error and once resolved it with the following patch: Hi, I've also renamed it in the trunk, it will be in the next release. Cheers, Sylvain -- --- You received this message because you are subscribed to the Google

Re: [jopendocument] add clean target to build.xml

2014-06-26 Thread Sylvain Cuaz
Le 20/06/2014 20:28, Pirate Praveen a écrit : I thought it would be useful to share it here. Thanks, it will be in the next release. Cheers, Sylvain -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and

Re: [jopendocument] Fwd: Re: libjopendocument-java build failures after repack

2014-06-26 Thread Sylvain Cuaz
Le 20/06/2014 20:25, Pirate Praveen a écrit : heads up for java 8 compatibility. According to: http://anonscm.debian.org/viewvc/pkg-java/trunk/libcommons-collections3-java/debian/patches/java8-compatibility.patch?view=markup MultiHashMap.remove has been renamed to

Re: [jopendocument] comments in french needs an explicit encoding setting in non-utf-8 locales

2014-06-26 Thread Sylvain Cuaz
Le 21/06/2014 09:21, Pirate Praveen a écrit : I think it would be a goog idea to set encoding to utf-8 explicitly so it can build fine in non-utf-8 locales as well. Agreed, I've patched build.xml Cheers, Sylvain -- --- You received this message because you are subscribed to the Google

Re: [jopendocument] Re: .fods (flat xml) support

2015-04-17 Thread Sylvain Cuaz
Le 16/04/2015 21:07, Adam Brousseau a écrit : Not sure if anyone knows that answer, but I am still interested in this functionality. Hi, If you're sure that it's a flat XML, you can use ODSingleXMLDocument.createFromFile() / createFromStream(). Otherwise ODPackage.createFromFile() /

Re: [jopendocument] spreadsheet range

2016-06-15 Thread Sylvain Cuaz
Le 06/06/2016 14:59, James Pollard a écrit : Hi, I'm trying to workout how to select a range of cells then change the background colour This is what I've tried so far as well as variations of this

Re: [jopendocument] getRange and getTableModel returning null

2017-04-12 Thread Sylvain Cuaz
Le 11/04/2017 à 08:33, rho...@opentrends.net a écrit : Hi, I have defined a named range in my libreoffice ods, but neither getRange nor getTableModel seem to get it, they both return null, do you know what could cause that behavior? Hi, from your screenshot it appears you have created a

Re: [jopendocument] jOpenDocument can't read text cells created by libreoffice 7.0.1

2020-09-14 Thread Sylvain Cuaz
Le 31/08/2020 à 21:41, bdw...@gmail.com a écrit : There's an error in my description of the problem. x.getValue() and  x.getTextValue() do not return null.  They throw NullPointerExceptions. E.g. Exception in thread "main" java.lang.NullPointerException     at