Re: [Bug parsing CustomGeometry]: Wrong custom geometry is returned

2022-03-02 Thread Andreas Beeker
need more information. I’m happy to help. Thanks, Etienne On 28 Feb 2022, at 8:13 am, Andreas Beeker wrote: Hi Etienne, I'm not sure, if this was a spam hiring attempt or message somehow cut short, but I've checked your attached pptx via POI, Libre Office and Powerpoint. IIRC the master slide had one

Re: [Bug parsing CustomGeometry]: Wrong custom geometry is returned

2022-02-27 Thread Andreas Beeker
Hi Etienne, I'm not sure, if this was a spam hiring attempt or message somehow cut short, but I've checked your attached pptx via POI, Libre Office and Powerpoint. IIRC the master slide had one line via custom geometry and the slide added another line. So the rendering looked similar, but  I

Re: Running tests in parallel?

2021-11-02 Thread Andreas Beeker
Hi Andreas, the two files build/ooxml-lite-report.clazz & .xsb are generated via the OOXMLLiteAgent. The agent is used on the modules with xmlbeans dependencies (poi-ooxml, poi-excelant and poi-integration) and incrementally gather the used XmlBeans classes and xsbs. I haven't tried build

Re: SlideShow rendering issues

2021-10-18 Thread Andreas Beeker
Hello Bernhard, I take care about rendering issues in HSLF/XSLF. Either create a new bugzilla entry [1] with files/attachments which we can put into our test data corpus (preferred). Or get in contact with me directly and provide me the files and I try to fix the implementation. Out of scope

Re: Problem when signing docx file

2021-08-12 Thread Andreas Beeker
Hi Blaz, sorry for the late response. Please debug org.apache.poi.poifs.crypt.dsig.SignatureInfo#initXmlProvider after the servlet is reloaded. My guess is that the RelationshipTransformService registration is lost somewhere and the singleton is not initialized again. So depending on the

[ANNOUNCE] Apache XMLBeans 5.0.1 release

2021-07-14 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of Apache XMLBeans 5.0.1. The POI team took over the ownership of XMLBeans since version 3.0.0. See the downloads page for binary and source distributions: https://xmlbeans.apache.org/download Note: The Apache Software Foundation uses

Re: Closing down IRC channel - any interest on a new chat system?

2021-06-20 Thread Andreas Beeker
blem which you want to chat about or just get some news, feel free to contact/email me directly for further chat options. Andi On 27.05.21 21:36, Markus Kirsten wrote: Cool. I'm very interested joining if there's a Slack channel Thanks a lot On Thu, 27 May 2021 at 18:54, Andreas Beeker w

Re: 4.1 -> 5.0 results in enormous increase in dependencies and WAR file size

2021-06-20 Thread Andreas Beeker
Hello Jan, TL;DR: I'm not adding examples on how to use the package manager to achieve a minimal POI version, as the components are covered in POI and the package manager exclusions are documented in their related sites. sorry for postponing this nearly one month ... somehow I hoped someone

Re: Converting pptx to pdf

2021-05-29 Thread Andreas Beeker
Hi Jessy, here a few points about this issue: * PDF support is relatively new and there are a few/lot (?) of cases which work differently opposed to PPTX->PNG * I can have a look at your input file and try to figure out what's wrong - either send it to the list or to me privately * Cascaded

Closing down IRC channel - any interest on a new chat system?

2021-05-27 Thread Andreas Beeker
Hi devs/users, freenode was taken over [1] and I was asked about our channel (#apache-poi) their, which was essentially dead for a long time now. I'll close the channel [2] soon without a replacement, as it seems online-chat is not a POI users/devs thing. I'll keep the private POI channel on

Re: 4.1 -> 5.0 results in enormous increase in dependencies and WAR file size

2021-05-23 Thread Andreas Beeker
The exclusion Yegor mentioned only work flawless on the classpath-mode. In JPMS only Batik is optional (and need to be added via module-info or --add-modules), the rest of the dependencies should be on the module-path. see [1] for the optional modules - we discussed the current setup in [2]

[ANNOUNCE] Apache XMLBeans 5.0.0 release

2021-03-15 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of Apache XMLBeans 5.0.0. The POI team took over the ownership of XMLBeans since version 3.0.0. See the downloads page for binary and source distributions: https://xmlbeans.apache.org/download Note: The Apache Software Foundation uses

[ANNOUNCE] Apache POI 5.0.0 released

2021-01-19 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 5.0.0. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes The most

Optional dependencies - was: Plea - test the POI 5.0.0 snapshot

2020-12-21 Thread Andreas Beeker
: Will integrate w Tika on Monday and test it out. Thank you!!! On Sat, Dec 19, 2020 at 7:52 AM Andreas Beeker wrote: Dear POI users, we are shortly before releasing POI 5.0.0 and there have been some breaking changes [1]. Notably the JPMS/JigSaw migration and the upgrade of the ECMA-376 schemas

Missing classes in poi-ooxml-lite - was: Plea - test the POI 5.0.0 snapshot

2020-12-21 Thread Andreas Beeker
! Please help test! -- Forwarded message - From: Tim Allison Date: Sat, Dec 19, 2020 at 8:45 AM Subject: Re: Plea - test the POI 5.0.0 snapshot To: POI Users List Will integrate w Tika on Monday and test it out. Thank you!!! On Sat, Dec 19, 2020 at 7:52 AM Andreas Beeker wrote

Plea - test the POI 5.0.0 snapshot

2020-12-19 Thread Andreas Beeker
Dear POI users, we are shortly before releasing POI 5.0.0 and there have been some breaking changes [1]. Notably the JPMS/JigSaw migration and the upgrade of the ECMA-376 schemas to the 5th edition. Please download the snapshot [2] and give it a try - especially with the new schemas, I'm

Re: HTML to pptx using apache POI

2020-11-11 Thread Andreas Beeker
Hi Nikunj, this [1] is quite an old entry which shows how to parse html and use it to create a docx. A similar approach might be possible with XSLF. The hope to "retain all the formatting" depends on how much effort you want to put in the mapping - there's no ready to use solution from the POI

Re: getting started

2020-10-27 Thread Andreas Beeker
Hi Rolf, frankly said, I haven't tested any of the shell scripts, as I was happy that the modifications for JPMS worked ok with POI. Therefore I recommend to call the SchemaCompiler directly and use the srconly option. If you look at the ooxml-schema maven pom, you'll see the parameters to be

Re: xmlbeans and maven

2020-10-26 Thread Andreas Beeker
On 26.10.20 08:00, Rolf Schumacher wrote: is the xmlbeans maven plugin still recommendable? I used to use xmlbeans a lot till the project went to sleep. I see that it is alive again - for a while now - and would restart my usage. However I see that the newest xmlbeans-maven-plugin 2.3.3 is

Re: Can't get the DOM Node text representation of the markup

2020-10-15 Thread Andreas Beeker
Hi Nadav, using the dom node usually results in some disconnected xml fragments. When our schema doesn't cover current elements, I always use XmlCursor. Have a look for instance at the SignatureLine class [1] There you can see, how to add XmlObjects to a xml element having any content [2] and

Re: Best way to keep ourselves informed of security vulnerabilities

2020-04-27 Thread Andreas Beeker
Hi Venkat, > Is there a way to keep track of security vulnerabilities discovered in Apache > POI? I know the following sources: the official CVE list: https://www.cvedetails.com/vulnerability-list/vendor_id-45/product_id-22766/Apache-POI.html our change list not necessarily point out

[ANNOUNCE] Apache POI 4.1.2 released

2020-02-14 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 4.1.2. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes The most

Re: Debugging tip for "Excel cannot open the file" ... when opening the file created by POI OOXML

2020-02-03 Thread Andreas Beeker
find if there's any code closer to validator in POI source. >> >> Thank you for mentioning .xsb files. They exist in the shaded jar but they >> weren't relocated. And if I did relocate them, I'm guessing there would be >> lots of file-not-found exceptions. I temporarily stopped

Re: Debugging tip for "Excel cannot open the file" ... when opening the file created by POI OOXML

2020-02-03 Thread Andreas Beeker
We have two entries in the FAQ [1] about file validation, which I haven't used myself yet ... and probably are futile in your case. You can try to validate against the ECMA 376 schemes. If I have similar problems I try to go step-wise from the simple case to the complex ... and yes, it's

Re: Debugging tip for "Excel cannot open the file" ... when opening the file created by POI OOXML

2020-02-03 Thread Andreas Beeker
Hi, I'd do the same in the unit test as in the real run. Unzip and compare both files. What's the difference? What is a real run like? is this a web application? Do you have duplicated POI jars in the classpath? Andi On 03.02.20 20:55, Kuro Kurosaka wrote: > Hi, > I created an .xlsx file using

Re: out of memory error when creating pptx file

2020-02-03 Thread Andreas Beeker
Hi, XSLF and XmlBeans are undoubtedly memory hogs, but I can't solve this in a short period - I often thought about an internal model which we could use for XSLF / HSLF but lets get back to your issue. So when you say, you need to generate 600 slides ... does that mean they have similar

Re: Display embedded files on the document (.docx)

2019-12-29 Thread Andreas Beeker
Hi Yogesh, I've quick-hacked (well not really ...) an example for you: https://pastebin.com/wsGqBDi0 The example contains the embedding via OLE Packager and direct. I've tried to use a Non-VML approach, but then the image doesn't react on double-click. The Ecma 376 spec (5th edition) mentions

Re: next version of poi

2019-12-18 Thread Andreas Beeker
> On 2019/11/27 21:30:06, Andreas Beeker wrote: >> Hello Ankita, >> >>> Looking at the change log it seems that poi can release in as little as 3 >>> months. >> This was the plan once ... currently our committer base is a bit ... busy >> somewhere

Re: next version of poi

2019-11-27 Thread Andreas Beeker
Hello Ankita, > Looking at the change log it seems that poi can release in as little as 3 > months. This was the plan once ... currently our committer base is a bit ... busy somewhere else, I guess. So usually we wait for enough changes to accumulate or if we discover/fix a regression to be

[ANNOUNCE] Apache POI 4.1.1 released

2019-10-20 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 4.1.1. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes The most

Re: POI 4.1.1

2019-09-17 Thread Andreas Beeker
Hi Thimo, > Are there any plans / timelines for this release? so you've validated the trunk/nightly version for your purpose? About a month ago, we had already the discussion about the next release on the dev list - so I guess we will soon do a release. From the point we start the release

Re: Exception

2019-05-26 Thread Andreas Beeker
Hi Glenn, your mail looks auto-corrected, but I guess you want to know, how to configure the TempFile directory. Option 1: Configure the Java tmpdir when calling your program: -Djava.io.tmpdir= Specify -Dpoi.keep.tmp.files= to suppress the deletion of the tempfile, i.e. the default is to

Re: How to Add Notes To XSLFSlide?

2019-05-02 Thread Andreas Beeker
Hi Eliot, > Is this missing from the current API? If so, I can possibly try to add the > necessary methods if appropriate, Yes it's missing. Although there's a XSLFSlide::setNotes method, it's a no-op. Feel free to extend the API and please share your implementation in a bugzilla or github

Re: POI PPT XSLFTextParagraph know the point of text overflow.

2019-04-25 Thread Andreas Beeker
> but I dont see any method in XSLFTextShape to know the > original height of the text box the original height of the text box is the anchor height. here is an example, which stops (usually) when the textbox is full. public void overflow() throws Exception { boolean useXml = false; try

Re: POI PPT XSLFTextParagraph know the point of text overflow.

2019-04-24 Thread Andreas Beeker
> I checked XSLFTextShape.getTextHeight() to get text height ... > Problem is I am not able to figure out the point of text > overflow. I know about the inaccuracy of the getTextHeight(graphics2d) method, which varies from Windows/Linux/Mac system and the way Java vs. Windows-GDI renders fonts.

Re: streaming detection of OLE?

2019-04-16 Thread Andreas Beeker
On some files the properties record is located in the end. If you read the POIFS HeaderBlock (see POIFSFileSystem constructor), you know from HeaderBlock._property_start the first block containing properties. When accessing the network file via http/webdav, you can then jump to that range [1]

Re: streaming detection of OLE?

2019-04-16 Thread Andreas Beeker
Hi Tim, when you say detection, you mean the type of OLE document? , e.g. word, excel, powerpoint ... Instead of reading the directory entries, you could also read the storage_clsid of the root record. But I haven't checked yet, where this information is located in the file. Andi

Re: Getting contents out of HemfComment.EmfCommentDataWMF ?

2019-04-08 Thread Andreas Beeker
Allison wrote: > Are you ok w it? > > On Mon, Apr 8, 2019 at 6:11 PM Andreas Beeker wrote: > >> Oh sorry ... I've just realized you've introduced the method recently ... >> how embarrassing ... >> >> signature.asc Description: OpenPGP digital signature

Re: Getting contents out of HemfComment.EmfCommentDataWMF ?

2019-04-08 Thread Andreas Beeker
Oh sorry ... I've just realized you've introduced the method recently ... how embarrassing ... signature.asc Description: OpenPGP digital signature

Re: Getting contents out of HemfComment.EmfCommentDataWMF ?

2019-04-08 Thread Andreas Beeker
Hi Tim, please use the getWMFData() method: HemfPicture emf = new HemfPicture((InputStream)...); for (HemfRecord r : emf.getRecords()) { if (r instanceof EmfComment) { EmfCommentData hc = ((EmfComment)r).getCommentData(); if (hc instanceof EmfCommentDataWMF) {

Re: POIXMLTextExtractor.java : IllegalStateException

2019-03-25 Thread Andreas Beeker
Hi Scott, > I don’t understand where the values of text.length() and string.length() are > coming from. The values are parameters of method "checkMaxTextSize", Where is "checkMaxTextSize" called and what are the parameters? Please use a decent IDE, and check the references to the method! Ok,

Re: Writing content in ttf code128

2019-03-08 Thread Andreas Beeker
Hi, just to recap: a) you want to email a .docx file to your clients b) this .docx file contains a .xlsx file as an embedded document c) this .xlsx contains cells with barcodes formatted via a code128 font Regarding c): My guess is you need to set the barcode string as text value of a cell and

Re: AW: Problems using poi with JDK 11 in a modularized application

2019-01-26 Thread Andreas Beeker
Hi Achim, for the private xmlbeans namespace in the generated re-/sources, I had to modify the XmlBeans handling of the metadata directory and change the typesystem stub/loading in POI. At least the POI tests looks good. You find the binary of XmlBeans and the full POI schemas, including the

Re: AW: Problems using poi with JDK 11 in a modularized application

2019-01-25 Thread Andreas Beeker
Hi Achim, But please don't waste your time in explaining it to me when it is easier for you to build it by yourself and not necessary for me to understand. I've tried to change the schema generation via the repackage parameter, which is only available by using the

Re: Problems using poi with JDK 11 in a modularized application

2019-01-24 Thread Andreas Beeker
Hi Achim, there's an unofficial repackage parameter for xmlbeans generation: -repackage org.apache.xmlbeans:mybeans We could try to provide a new XmlBeans version and/or POI schemas with custom packages, to get rid of the name clash. Apart of generating a dummy schema, I haven't checked

Re: Use different logger

2018-12-31 Thread Andreas Beeker
On 31.12.18 11:30, pj.fanning wrote: The new class will need to sublass org.apache.poi.util.POILogger. But the problem is, that the new logger needs to reside in the same package. I would remove the package-private constructor or make POILogger an interface. Andi

Re: XSLFTextRun definition

2018-12-22 Thread Andreas Beeker
HI, the modifications are in the trunk - so if you want it immediately, you could use a nightly [1]. The next release of POI (4.1.0) will be around end of February. Well, great if *XSLFTable* or *Slide* can know if /content/ fits with one *slide* and then /remaining content/ will display to

Re: how to instrument the apache bundles poi 4.0.0_1

2018-12-20 Thread Andreas Beeker
I did that patch locally to validate some OSGI problems before POI 4.0.0 was released. I've seen that there's already a 4.0.0 version of the service mix bundle - as Dave suggested - but I haven't checked the differences. My hope was, that the patch might help you in fixing the service mix.

Re: how to instrument the apache bundles poi 4.0.0_1

2018-12-20 Thread Andreas Beeker
For POI 4.0.0, I've created a patch (http://people.apache.org/~kiwiwings/servicemix-poi-4.0.0.patch), feel free to use it as a starting point. I've just realized that there's a sandbox for Apache committers, maybe I should push my updates there ...

Re: XSLFTextRun definition

2018-12-18 Thread Andreas Beeker
I've applied a patch via #63017 [1] So have a look at [2] at method testResize(). This should be somehow what you want - add rows until a max size is reached and then continue on the next page. The dimensions are only approx. correct - hence I've added the rendering via PPTX2PNG - which you

Re: XSLFTextRun definition

2018-12-18 Thread Andreas Beeker
On 18.12.18 20:47, paoim101084 wrote: Will support all available font family or just get the last one of Array? Although you could easily try that yourself, before posting in the mailing list - the answer is: "it depends", not all font families can be used in Powerpoint - I would only use

Re: XSLFTextRun definition

2018-12-18 Thread Andreas Beeker
- You need to register font first - just google for "GraphicsEnvironment registerFont" https://stackoverflow.com/search?q=%5Bjava%5D+GraphicsEnvironment+registerFont - then simply set the font name as font family - To

Re: How display text fits with the width of column?

2018-12-18 Thread Andreas Beeker
On 18.12.18 16:46, paoim101084 wrote: Yes, I have two issues when I used XSLFTable. 1. Display text does not fit with column. For example, less text should display in small column. long text should display in big column. 2. Calculate table's height, so I can display two or more tables in the

Re: How display text fits with the width of column?

2018-12-18 Thread Andreas Beeker
On 17.12.18 22:17, paoim101084 wrote: Do you know how to autoResize the column in XSLFTable? I got painful when I use XSLFTable. I cannot calculate the exact table height. I've just realized that the table height is not updated [1], only the bounding boxes of the cells are updated on

Re: XSLF copy slides

2018-12-17 Thread Andreas Beeker
Although you excavate a 3+ year thread, I assume you've tested with a current POI 4.0.x version: If not -> please try with POI 4.0.1 if yes -> open a bugzilla issue and add your files, because testing with a few arbitrary files and your code was successful. Andi

[ANNOUNCE] Apache POI 4.0.1 released

2018-12-03 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 4.0.1. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes The most

Re: Classpath issues with 4.0.0

2018-11-25 Thread Andreas Beeker
Hi David, this will be fixed be 4.0.1 - specifically this was fixed by #62742 (https://bz.apache.org/bugzilla/show_bug.cgi?id=62742) Please add Commons Compress 1.18 (or higher) to your classpath. https://search.maven.org/artifact/org.apache.commons/commons-compress/1.18/jar The way my

Re: Disabling Logging in POI 3.15

2018-11-19 Thread Andreas Beeker
On 19.11.18 17:05, Nick Burch wrote: On Mon, 19 Nov 2018, Sawan.Patwari wrote: There were around 91 matches to the 'System.out.println' statements in the POI-3.15 source-code Apache POI 3.15 is now over 2 years old, and several security issues have been fixed in newer versions. What happens

Re: Disabling Logging in POI 3.15

2018-11-19 Thread Andreas Beeker
Hi, I've searched the codebase for ->usage"<- (and other variations) to check if we generate such a string somewhere, but didn't find anything - please check your other libs/code. Andi - To unsubscribe, e-mail:

Re: emulate saveAs

2018-11-12 Thread Andreas Beeker
Hi Rob, although this is more memory consuming, how about opening your template file via (File-)InputStream and using Workbook.write(new FileOutputStream(..))? Andi On 12.11.18 22:25, Rob Sargent wrote: How does one read in an excel file then "save as" new file? I'm transforming xlsx input

[ANNOUNCE] Apache POI 4.0.0 released

2018-09-07 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 4.0.0. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes The most

Re: XSLFTextRun definition

2018-08-05 Thread Andreas Beeker
Hi Giacomo, > the text it contains is not the text I expect it to contain If you would provide your expected text + the file, that would lift the mysterious curtain ... :) > Is there an official definition of what a XSLFTextRun is? The official POI statement is in the code ... just look at the

Re: 4.0.0 Contribution: Javadoc Cleanup

2018-07-21 Thread Andreas Beeker
Hi Eliot, as always: "just do it" ... please provide your patches in a reasonable size (e.g. by package) If they make sense and we have the impression that you'll stick with the project, we usually invite developers to become committers - especially as the hwpf/xwpf apis are a bit in dire

[ANNOUNCE] Apache XMLBeans 3.0.0 released

2018-07-08 Thread Andreas Beeker
The Apache POI project is pleased to announce the unretirement and release of Apache XMLBeans 3.0.0. The POI team is now maintaining and taking over the ownership of XMLBeans. Featured are a handful of security and unicode related fixes. See the downloads page for binary and source

[ANNOUNCE] Apache XMLBeans 3.0.0 released

2018-07-08 Thread Andreas Beeker
The Apache POI project is pleased to announce the unretirement and release of Apache XMLBeans 3.0.0. The POI team is now maintaining and taking over the ownership of XMLBeans. Featured are a handful of security and unicode related fixes. See the downloads page for binary and source

[ANNOUNCE] Apache XMLBeans 3.0.0 released

2018-07-03 Thread Andreas Beeker
The Apache POI project is pleased to announce the unretirement and release of Apache XMLBeans 3.0.0. The POI team is now maintaining and taking over the ownership of XMLBeans. Featured are a handful of security and unicode related fixes. See the downloads page for binary and source

Re: Workbook saved using POI 3.16 needs to be repaired when opening in Excel 2016

2018-06-24 Thread Andreas Beeker
I think this was fixed via #61798 [1], because fixing the dimension in sheet.xml helps. I haven't tested if this also occurs with other files / use cases, but it's kinda disappointing/interesting that such a basic operation failure hasn't been noticed earlier. Andi [1]

Re: Long XSLF Table needs splitting

2018-06-21 Thread Andreas Beeker
On 6/21/18 5:00 PM, lanpirot wrote: > Bump. Is there any workaround to find out the rendered height of a table, a > tablerow or a cell? > The height/width of a cell is fixed/independent from the content - have a look at XSLFTable.getColumnWidth() / .getRowHeight(). For resizing the cell around

Re: Question: Problem with Encryption in POI

2018-06-12 Thread Andreas Beeker
Hi Alex, you haven't closed the encos stream and its better to use the file directly with WorkbookFactory The below worked for me. Cheers, Andi public static void main(String[] args) throws Exception { EncryptionInfo info = new EncryptionInfo(EncryptionMode.standard); Encryptor enc =

Re: Long XSLF Table needs splitting

2018-06-06 Thread Andreas Beeker
HI Alexander, unfortunately there's no such splitting feature yet. Currently my POI todo list is too long, to work on that feature soon, but I would be grateful, if you share your implementation in case you'd decide to implement it via POI. Best wishes, Andi signature.asc Description:

Re: Specification Bug with rowIndex attribute for Rows?

2018-05-25 Thread Andreas Beeker
Hi, regarding ECMA-376 we are still using the 1st edition :( ... and add elements of later schemas every now and then, at least for XSLF. I guess the files you are trying to process aren't generated by MS Office, right? Although we should also handle your case correctly, if this is out in the

Re: Create XSLF Table - What am I doing wrong?

2018-05-16 Thread Andreas Beeker
On 5/15/18 4:20 PM, sai0276 wrote: > I have the same problem. > > Did it get resolved by any chance. Yes ... I haven't checked when, but I think it was something related to XmlBeans loading. Just use POI 3.17 and the below code works. > Can help me here. I'm sure you can :) Andi try

Re: Delete Row from XSLFTable

2018-05-11 Thread Andreas Beeker
> What is the proper way to delete a row from an XSLFTable? If you aren't modify the table instance further, you can use getCTTable().removeTr(index): // prepare some data ByteArrayOutputStream bos = new ByteArrayOutputStream(5); try (XMLSlideShow ppt = new XMLSlideShow()) { XSLFTable

Re: SVG image support in XSLF

2018-05-09 Thread Andreas Beeker
Hi Ritesh, I only have an Office 365 installation at work - please provide a sample file. You can e.g. upload it to a bugzilla entry. Andi signature.asc Description: OpenPGP digital signature

Re: SVG image support in XSLF

2018-05-06 Thread Andreas Beeker
Hi Ritesh, generating the png thumbnails should be possible with Batik [1]. Adding those extension elements should be possible via the XSLFShape.getXmlObject() method. If the xmlschema doesn't provide you with the accessors, you need to use a XmlCursor [2] to add the elements. When using

Re: Glitches and missing features converting powerpoint slides (xslf) to png

2018-03-18 Thread Andreas Beeker
Hi Federico, I don't know of a feature list in POI, i.e. I haven't made one up yet ... Additionally to the SO comment [1], you might want to look at the Aspose comparison [2] - sorry for advertising a non-foss project, but if you want to have a timely solution and payed support you are probably

Re: Background color missing when converting Powerpoint to PNG

2018-03-07 Thread Andreas Beeker
Hi, I think those glitches are related to the theme support which I haven't put too much effort in yet. The themes.pptx in our testdata repo shows also similar color issues. If you like, you could start from the DrawPaint class and check where it goes wrong. Otherwise I'll have a look at your

Re: Delete Column from a XSLFTable

2017-12-25 Thread Andreas Beeker
I've prepared an example on how to delete a column - does it work for you?: https://pastebin.com/AVNTX9yJ ... and yes, I guess this should be inside the API and a few package access methods made public. I think I haven't yet made the setGridSpan & Co. methods public, as I wanted to have an

Re: Infinite loop in SectionIDMap.get() and .put()

2017-11-22 Thread Andreas Beeker
On 11/22/17 9:01 PM, pj.fanning wrote: > Hi Arjohn, > Could you log a bugzilla issue? Would it be possible to provide a Java test > case? > Reproducing this is easy ... and it's a shame this hasn't bubbled up earlier. I've fixed and junit-tested it - will commit with bugzilla entry probably

[ANNOUNCE] Apache POI 3.17 released

2017-09-16 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 3.17. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Note: The Apache Software Foundation uses an

Re: Cannot extract texts from PowerPoint 95

2017-07-28 Thread Andreas Beeker
> If you know, could you please tell me how to extract text data from > PowerPoint 95 file? Sorry ... this hasn't been implemented yet - I haven't checked their sources, but maybe TIKA is able to extract the text from Powerpoint 95 (... although they usually depend on us for processing BIFF

Re: corruption in xlsx spreadsheet generated by poi?

2017-07-10 Thread Andreas Beeker
> If I create a ³corrupt² excel, unzip it, and then zip it back up (on my > mac using zip command), the resulting zip file opens without issue. If a > colleague on Windows generates the same excel, and does the same probably > using windup, the corruption remains. Please check if you see a

[ANNOUNCE] Apache POI 3.17-beta1 released

2017-06-30 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 3.17-beta1. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Note: The Apache Software Foundation uses an

Re: excel processing differences

2017-06-16 Thread Andreas Beeker
ile ? > > > --- > Thanks > Sateesh > > > > From: Andreas Beeker <kiwiwi...@apache.org> > To: > Cc: Sateesh K Kolusu <sateesh.kol...@in.ibm.com>, POI Users List > <user@poi.apache.org> > Date: 06/15/2017 09:16 PM > Subject:Re:

Re: excel processing differences

2017-06-15 Thread Andreas Beeker
You are trying to process a BIFF (HSSF) excel file with the commands for OOXML (XSSF) files. Please read again [1] ... if it still doesn't work, you can send me the file and I'll check it for you ... Andi [1] http://poi.apache.org/encryption.html signature.asc Description: OpenPGP digital

Re: xlsf slides wont show charts or shapes on png export

2017-05-17 Thread Andreas Beeker
Hi Oscar, I've implemented a glyph checker [2] and two mappings to either fully replace a font or fallback to another font, if the font is not available or a glyph can't be rendered. Have a look at [1] - which also shows a convenience way to google MS fonts ;) If you want to send me example

Re: Details on new vulnerability against Apache POI usage ?

2017-05-03 Thread Andreas Beeker
> We specifically use POI ONLY for extracting data from Microsoft Excel sheets > ... Do you trust and know the people/programs generating those Excel sheets? Yes -> no need to upgrade No -> upgrade! PS: Sorry for the double posting ... it was in the wrong list signature.asc

Is Powerpoint Turing complete?

2017-04-20 Thread Andreas Beeker
Hi *, here is a video (from my favorite blog...) you might like to consider, when you need to develop a turing machine the next time ;) https://www.youtube.com/watch?v=uNjxe8ShM-8 Andi signature.asc Description: OpenPGP digital signature

[ANNOUNCE] Apache POI 3.16 released

2017-04-18 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 3.16. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Note: The Apache Software Foundation uses an

Re: HSLF TableCell getRowSpan() isMerged()

2017-04-14 Thread Andreas Beeker
Hi, thank you for the sample file, I've just fixed the grid/rowspan code, but need to do a few more tests before I commit it. > Could you please confirm if those two methods are checking for first if a > tablecell is merged and secondly it returns the number of cells of being >

RE: Change Z-index of XSLFShape

2017-04-06 Thread Andreas Beeker
Currently there's no API for it. You need to manipulate the xmlbeans shape array directly, i.e. change the index/order of the shape objects. As the xmlbeans are referenced by the POI usermodel classes and you would change their base underneath, this might lead to unexpected results when saving

Re: jotlmsg: read & write Outlook msg files

2017-01-07 Thread Andreas Beeker
Hello Cédric, > Anyway, a link in your promoted section would already be great ! done. > I was more looking to improve directly MAPIMessage and related API great! have a look at http://poi.apache.org/guidelines.html > I don't know how to > proceed in order to make an equivalent of a pull

Re: jotlmsg: read & write Outlook msg files

2017-01-06 Thread Andreas Beeker
Hello Cédric, I've just had a quick browse/review through the source and the code looks fine to me. Not sure, if you had it in mind, but if we would integrate it in POI, we would have another two dependencies (commons-io and javax-mail), you'd need to change the license and there's a policy

RE: Question

2016-12-23 Thread Andreas Beeker
Sorry there was a typo in the last line, the methods aren't affected ...  Original message From: Andreas Beeker <andreas.bee...@gmx.de> Date: 12/24/16 08:19 (GMT+01:00) To: POI Users List <user@poi.apache.org> Subject: RE: Question I'm currently integrating so

RE: Question

2016-12-23 Thread Andreas Beeker
I'm currently integrating some code from [1], i.e. there will be an Extractor class for Excel, but the code will differ a lot from that quick and dirty SO hack ...The reason why this might not work for you is the AlternateContent tag, which wraps a lot of tags in newer Office releases.The

Re: Export pdf-file from xssf-file with java

2016-12-10 Thread Andreas Beeker
Hi, the LibreOffice export would probably handle the most cases, but is also quite heavy weighted and assumes you have a LO installation on your system/server. If you want to have a light-weighted - but also incomplete - solution, you can modify [1] and put the output through FOP [2] - that's

Re: OSGI malformed xlsx

2016-11-29 Thread Andreas Beeker
Can you strip down your use case to a small example project? I have the impression that there are also other problems like an old xalan version. I haven't done much with OSGi and I guess, if I create an example project myself, I might hit other errors ... Andi

Re: OSGI malformed xlsx

2016-11-23 Thread Andreas Beeker
Have a look at the FAQ [1] - does it work? [1] http://poi.apache.org/faq.html#faq-N1029C

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

2016-10-08 Thread Andreas Beeker
Just for closing this issue officially - this has been verified already a while ago and there's now a workaround via [1] Andi [1] https://bz.apache.org/bugzilla/show_bug.cgi?id=60226 - To unsubscribe, e-mail:

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

2016-08-20 Thread Andreas Beeker
A short follow-up on this: I can reproduce the error and it seems to be a classloader issue. I'm now trying to change the POIXMLTypeLoader to use an user given class loader - maybe that helps ... Andi - To unsubscribe, e-mail:

  1   2   >