Re: Including poi-ooxml-schemas

2016-08-12 Thread Nick Burch
On Thu, 11 Aug 2016, Branden Visser wrote: So it begs the question, what is the intended usage of this "poi-ooxml-schemas" dependency? http://poi.apache.org/faq.html#faq-N10025 Nick - To unsubscribe, e-mail: user-unsubscr...@

Re: Including poi-ooxml-schemas

2016-08-12 Thread Dominik Stadler
The FAQ-entry at http://poi.apache.org/faq.html#faq-N10025 tries to explain this. Please take a look and let us know if anything is still unclear then. Dominik On Aug 11, 2016 10:03 PM, "Branden Visser" wrote: > Hi all, there is this dependency: > > "org.apache.poi" % "poi-ooxml-schemas" % "3.1

The CellType of a cell which is set to String

2016-08-12 Thread Young
Hi In a excel, Firstly, I typed '1' in A1, then I changed the format of this cell to String. Secondly, I changed the format of A2 to Standard(the default format), then I typed '1' in this cell. Finally, I saved this excel. This is my excel file for test. I’m using poi 3.14. My source is very s

The CellType of a cell which is set to String

2016-08-12 Thread niaomingj...@outlook.com
Hi In a excel, Firstly, I typed '1' in A1, then I changed the format of this cell to String. Secondly, I changed the format of A2 to Standard(the default format), then I typed '1' in this cell. Finally, I saved this excel. This is my excel file for test. I’m using poi 3.14. My source is very s

Re: The CellType of a cell which is set to String

2016-08-12 Thread Javen O'Neal
The cell data format is a distinct concept from the cell value. The format only defines how the value should be printed, but doesn't change the underlying value. If you want to convert the cell value to a printed string, use https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.

Re: The CellType of a cell which is set to String

2016-08-12 Thread Javen O'Neal
To see how Excel actually saved the values, unzip the xlsx file and open sheet1.xml. You should see a couple elements, with a value and type. On Aug 12, 2016 8:32 AM, wrote: The cell data format is a distinct concept from the cell value. The format only defines how the value should be printed, b

Re: XSLFTable is empty when generated on Apache Felix/Sling server, works fine from standalone code

2016-08-12 Thread Andreas Beeker
Hi Guillaume, this issue pops up every now and then - see #54697. I guess this happens because of the mixed namespaces, but I can't point out, what the real reason for it is. Although this might be too heavy-weighted, what happens when you use the ooxml-schemas-1.3.jar? [1] Would you send me yo