RE: Please Help! Change Axis scaling without using 'setMajorUnit' from XDDFValueAxis

No, that's new. -Original Message- From: ranzhang35 [mailto:rzh...@mkprod.com] Sent: Friday, October 05, 2018 11:53 AM To: user@poi.apache.org Subject: Please Help! Change Axis scaling without using 'setMajorUnit' from XDDFValueAxis *Is there similar API from XSSFValueAxis class as the

RE: Urgent: using POI 3.17, how to change X-Axis scaling using xssf chart

If it is really that urgent, why don't you look at how POI 4.0.0 does it, and try to work that into POI 3.17. Surely you can do that faster than someone here since we all work on this in our own free time, and it appears to be what you are working on at work right now. I'll give you a hint, you

RE: General Support for Percentage Values?

ot to have the POI code do the percentage-to-integer conversion when it sets the @w:w value. Cheers, Eliot -- Eliot Kimber http://contrext.com On 8/16/18, 8:42 AM, "Murphy, Mark" wrote: According to the spec, w:val is always an integer value. What that integer represents depends

RE: Any Idea Why Word Does not Preserve Leading or Trailing Space?

Maybe the space is preserved only at the end of the text in the node? -Original Message- From: Eliot Kimber [mailto:ekim...@contrext.com] Sent: Wednesday, August 15, 2018 4:21 PM To: POI Users List Subject: Any Idea Why Word Does not Preserve Leading or Trailing Space? In the DOCX I'm

RE: General Support for Percentage Values?

According to the spec, w:val is always an integer value. What that integer represents depends on the w:type value. If w:type="auto" then it appears that w:val=0, or may even be ignored, but that will depend on the table width algorithm. I didn't look at that just now, it is very complex. If

RE: How to Resolve "Indirectly referenced from required .class files" Issue?

LOL, There is a lot of old stuff that doesn’t have unit tests. If you are regularly making use of CT classes, then you might want to consider using the full ooxml-schemas jar. -Original Message- From: Eliot Kimber [mailto:ekim...@contrext.com] Sent: Wednesday, August 01, 2018 7:40 AM

RE: XWPFFieldRun Doesn't Work for Creating DOCX

Yea, there are a lot of half finished classes in XWPF. Fields are one of those. If you look at Stack Overflow here https://stackoverflow.com/a/40264237/2296441 you will see how I add a table of contents as a simple field. This should be relatively easy to add as a method of a paragraph like

RE: General Mechanism in WXPF Code for Managing CT IDs?

In fact, I think it would be good to change the TableCell behavior before 4.0.0 goes live as that is a breaking change. -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Friday, July 20, 2018 3:52 PM To: 'POI Users List' Subject: RE: General Mechanism

RE: Contributor Question: How Best to Create Pull Request Using a git-svn Clone?

It depends on who goes about reviewing your changes. Most don't care, PJ prefers a git pull request. I generally do my real work in svn, and test stuff in a git clone. -Original Message- From: Eliot Kimber [mailto:ekim...@contrext.com] Sent: Friday, July 20, 2018 12:00 PM To: POI Users

RE: General Mechanism in WXPF Code for Managing CT IDs?

Those places that have this behavior are being adjusted as I get to them. So let's not create extra work for later. -Original Message- From: Eliot Kimber [mailto:ekim...@contrext.com] Sent: Friday, July 20, 2018 11:22 AM To: POI Users List Subject: Re: General Mechanism in WXPF Code

RE: Long XSLF Table needs splitting

This seems to be a new question, not even related to Excel. Can you please not hijack threads, but instead create a new one? Odds are PJ's answer won't even help because he answered for Excel, and the API's aren't really even similar. -Original Message- From: Nayan Zubeen Bayan

RE: Is it POI error starting 3.14 version onwards

You need to apply a style to the cell. The style can include a number format. DataFormat format = workbook.createDataFormat(); short fmt = format.getFormat("#0.0"); CellStyle style = workbook.createCellStyle(); style.setDataFormat(fmt); … cell.setCellStyle(style); From: Syed Mudassir Ahmed

RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus

How did you sort the rows? -Original Message- From: Dagnon, William [mailto:william.dag...@wpsic.com] Sent: Thursday, March 08, 2018 8:53 AM To: POI Users List Subject: RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS

RE: showInPane does not work

Not working is a very broad statement, what is happening, what did you expect? What does your code look like? -Original Message- From: arun.ka [mailto:thimsa...@gmail.com] Sent: Wednesday, February 07, 2018 2:44 AM To: user@poi.apache.org Subject: Re: showInPane does not work Dear POI

RE: Paragraph runs are wrongly considered to be deleted in review

Simon, if you could attach a simple document that exhibits this issue to bugzilla issue #61787 (https://bz.apache.org/bugzilla/show_bug.cgi?id=61787), I would appreciate it. -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Monday, November 20, 2017 8:45 AM

RE: Paragraph runs are wrongly considered to be deleted in review

It appears, based on my reading of the spec, that the fix for bug 58067 is incorrect as it is keying on rsidDel which is a revision session id not a deleted element mark. Deletions are indicated by several tags but most important to this particular bug is which is the tag for deleted text in

RE: XSSFWorkbook isHidden implementation

For sheets, once again Excel 2016, I cannot hide the last visible sheet. So it appears that Excel handles Sheets and workbooks differently. One potential reason to have hidden workbooks is if you have a workbook with just macros in it, and you have that in your XLSTART library [User

RE: XSSFWorkbook isHidden implementation

In my testing, Excel 2016, I can hide a workbook by selecting View->Hide. I can do that even if it is the only workbook open. The XML is in workbook.xml and looks like this: I can close out of Excel with the only workbook hidden, and it allows me to save it as hidden. When I re-open

RE: corruption in xlsx spreadsheet generated by poi?

I believe that the JVM still uses Unicode internally. I believe character data is probably converted when the string is created. I know that on IBM i, I do not have to do anything special to EBCDIC character data, and POI documents are written correctly. -Original Message- From: Robert

RE: new XWPFDocument(fis) is blocked

What OS are you running on? -Original Message- From: xjtuzxh [mailto:xiaohui.zh...@transwarp.io] Sent: Wednesday, May 17, 2017 4:49 AM To: user@poi.apache.org Subject: new XWPFDocument(fis) is blocked hi all, This is my first topic on POI, I am from china so my English is a little

RE: How it is possible to get the Alt Text from a Table in Word

As I mentioned on SO, this feature is not in the 2006 schema that POI uses. In order to do what you want to do, you will have to retrieve the XML for the table, and manually parse the tblCaption node out of the table Parameters. Start with XWPFTable.getCTTLB(). Then you may be able to use

RE: I want create a xls workbook that the sheets are greater than 64 and every sheet have comment, but it not work at the version 3.12 and later version.

Please Open an issue at https://bz.apache.org/bugzilla/buglist.cgi?product=POI From: Zouchengguang (Ben) [mailto:ben@huawei.com] Sent: Thursday, April 06, 2017 2:28 AM To: user@poi.apache.org Subject: I want create a xls workbook that the sheets are greater than 64 and every sheet have

RE: Prevent of creation new sheets

How about just don't create a new sheet. Saving does not create new sheets in POI. -Original Message- From: Artem Telizhenko [mailto:bito4e...@gmail.com] Sent: Wednesday, April 05, 2017 11:07 AM To: user@poi.apache.org Subject: Prevent of creation new sheets Hi, I am tried to find out

RE: HSMF (Outlook .msg) updates

Not real sure what Aspose is. It is likely not associated with POI. If it does what you need, maybe you should use it unless you can make the necessary modifications to POI. Or > There are usage examples in the poi-examples [2] package, in the unit > tests, and on the quick guide, [3], which

RE: Problem with default font size when reading from docx file

Please attach a minimal document, and some code that exhibits the issue. Then we can probably answer better. But if there is no style directly associated with the paragraph or run, it should be getting its style from the default run style. This is found in XWPFStyles. XWPFStyles styles =

RE: shiftrows() in xls document containing hidden (zero height) rows

Check the link at the bottom of the email? -Original Message- From: discreta discrecion [mailto:ecorr...@hotmail.com] Sent: Sunday, January 08, 2017 5:53 AM To: POI Users List Subject: Re: shiftrows() in xls document containing hidden (zero height) rows unsuscribe,

RE: Writing workbooks with linked workbooks using XSSFWorkbook

If you create an issue in bugzilla with a unit test, It will be easier to get that fixed. -Original Message- From: Jörn Franke [mailto:jornfra...@gmail.com] Sent: Tuesday, December 27, 2016 9:53 AM To: user@poi.apache.org Subject: Writing workbooks with linked workbooks using

RE: How do you code cell striping?

, 2016 at 11:44 AM, Murphy, Mark <murphym...@metalexmfg.com> wrote: > PropertyTemplate is new for 3.15. It is in package > org.apache.poi.ss.util > > Here are the javadocs: https://poi.apache.org/ > apidocs/index.html?org/apache/poi/ss/util/PropertyTemplate.htm

RE: How do you code cell striping?

- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Tuesday, December 20, 2016 11:45 AM To: 'POI Users List' <user@poi.apache.org> Subject: RE: How do you code cell striping? Can you do the color thing in Excel? If not, you probably can't do it in POI either. -Original M

RE: How do you code cell striping?

Can you do the color thing in Excel? If not, you probably can't do it in POI either. -Original Message- From: Eric Douglas [mailto:edoug...@blockhouse.com] Sent: Tuesday, December 20, 2016 10:34 AM To: POI Users List Subject: Re: How do you code cell striping? I

RE: How do you code cell striping?

PropertyTemplate is new for 3.15. It is in package org.apache.poi.ss.util Here are the javadocs: https://poi.apache.org/apidocs/index.html?org/apache/poi/ss/util/PropertyTemplate.html Both PropertyTemplate and setCellStyleProperties() will help in reducing the number of styles generated. But

RE: How do you code cell striping?

I am pretty sure this is the way it works in Excel. Conditional formatting overrides the stated cell style. In order to get any other colors you need to add additional rules to the conditional formatting. -Original Message- From: Eric Douglas [mailto:edoug...@blockhouse.com] Sent:

RE: How do you code cell striping?

I can take a stab at one of these. #1) Why does Conditional formatting use setBackgroundColor to set the fill color for Solid Fill while styles use setForgroundColor? I noticed this discrepancy myself. To answer the question I generated a simple spreadsheet in MS Excel with one cell colored

RE: Where is the Eclipse Project file?

The easiest way is to: 1. Add the repository in eclipse 2. In your Java perspective, File->Import from the repository trunk, and during the import have eclipse find the project file. This is an option in one of the import wizard dialogs. -Original Message- From: Nadav Benedek

RE: Too much memory is used when reading a xlsx-file whose size is just 7.3M

If we replaced that, and stored the document as Java objects only, we could then conceivably write the document as either XLS or XLSX, or whatever format comes down the pike simply by selecting a write format. Someone would have to create the writers. Expanding on that, we could also read

RE: Getting all ContentControls

Not real sure what you mean by this. Ask you question, and maybe someone can help you. Be sure to include what you did, what you expected to happen, and what actually happened instead. Showing your code is a good idea, and maybe attach the document as well. -Original Message- From:

RE: XWPFSDT

It depends on where the SDT is. You are going to have to use the CT classes to do it though. The SDT part of XWPF is pretty much read only at the moment. You can find the spec here http://www.ecma-international.org/publications/standards/Ecma-376.htm. POI uses the 1st edition. Parts 3, and 4

RE: Restarting styled numbered/lettered lists

XWPF is a work in process, and the API is not really stable. The goal is that it not be simply a surrogate for the CT classes, but rather an intuitive interface to create word documents from Java. I am working through a basic architecture right now so that what we have doesn’t feel so

RE: POI-3.15: Commons-Collections-4 vs. Jasper Reports' dependency on Commons-Collections-3

This issue seems to have worked out well for Andreas, but I am wondering, if Jasper Reports depends on POI, can a user upgrade POI without breaking dependencies such as Jasper Reports? Can a user run with two versions of POI in their classpath? I don’t think so. While it is good to remove

RE: Suspected Spam:Re: altChunk inside paragraph or table call

This also needs to be done through the CT classes. You can break into this low level interface using XWPFGetDocument. From there you need to navigate the XML to add a new paragraph in a specific location. Once again, an issue in Bugzilla will help this occur a bit faster. -Original

RE: altChunk inside paragraph or table call

Not yet through the usermodel API, but if you do some research on what it should look like in the underlying XML, you should be able to accomplish it with the CT classes. You should add an issue to the Bugzilla issue tracker for this. -Original Message- From: Алексей Ушаровский

RE: How to insert table inside tablerowcell using apache poi

} } } From: Krishna Vyas Majji [mailto:krishna.ma...@quest-global.com] Sent: Thursday, September 01, 2016 10:49 AM To: Murphy, Mark <murphym...@metalexmfg.com> Subject: RE: How to insert table inside tablerowcell using apache poi I tried mark I am not getting exactly li

RE: how to split a cell vertically in XWPFTableCell

I don't understand what you mean. -Original Message- From: Krishna Vyas Majji [mailto:krishna.ma...@quest-global.com] Sent: Tuesday, August 23, 2016 10:45 AM To: POI Users List Subject: how to split a cell vertically in XWPFTableCell Hi Team, How to split a cell

RE: Remove space before and after paragraph in table i.e. word document

The problem is that when creating table, a row containing a cell containing a paragraph containing a blank run is already created. Those are the extra blanks you see. When you do cell.addParagraph(), you are adding a second paragraph. This is not really appropriate behavior, and is likely to

RE: How to add diagonal up border to a tablecell in word document using XWPF

ile system FileOutputStream out = new FileOutputStream(new File("create_table_example.docx")); document.write(out); out.close(); Thanks, Krishna -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Thursday,

RE: How to add diagonal up border to a tablecell in word document using XWPF

blecell in word document using XWPF Mark, Thanks a lot. Your code snippet is working. Regards, Krishna -----Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Thursday, August 18, 2016 6:48 PM To: 'POI Users List' Subject: Bulk Mail : RE: How to add diagonal up bor

RE: How to add diagonal up border to a tablecell in word document using XWPF

cBorders.addNewTr2Bl(); } //Write the Document in file system FileOutputStream out = new FileOutputStream(new File("create_table_example.docx")); document.write(out); out.close(); Thanks, Krishna -Orig

RE: How to add diagonal up border to a tablecell in word document using XWPF

Here is some code that works its way from the table cell object - cell to add an up diagonal border: CTTc ctTc = cell.getCTTc(); CTTcPr ctTcPr = ctTc.isSetTcPr() ? ctTc.getTcPr() : ctTc.addNewTcPr(); CTTcBorders ctTcBorders = ctTcPr.isSetTcBorders() ?

RE: How to add diagonal up border to a tablecell in word document using XWPF

Diagonal borders have not been surfaced from the CT interface yet. You can do it, but you will have to manipulate the CT structures of the table directly. -Original Message- From: Krishna Vyas Majji [mailto:krishna.ma...@quest-global.com] Sent: Thursday, August 18, 2016 7:16 AM To:

RE: Trouble building 3.15

Is this a test he has created which is failing, or is it a current test that is already working for us? -Original Message- From: Andreas Beeker [mailto:kiwiwi...@apache.org] Sent: Monday, August 15, 2016 10:25 AM To: POI Users List Subject: Re: Trouble building

RE: Merge Word docx into another Word dox via XWPFDocument - preserving formatting

uns before that run, insert all of the contents from the merged-in document at the place where run that contains the text-to-be-replaced resides, and then preserve all of the contents of the runs that come after. Thanks again. ~Cory On Mon, Aug 8, 2016 at 5:19 AM, Murphy, Mark <murphym...

RE: Reading xlsx file using poi3.7

In addition, you are going to have to upgrade your Java as POI 3.14 requires Java 1.6. -Original Message- From: Nick Burch [mailto:apa...@gagravarr.org] Sent: Tuesday, June 14, 2016 6:59 AM To: POI Users List Subject: Re: Reading xlsx file using poi3.7 On Tue, 14

RE: CTLongHexNumber

I just thought of that. It is the small one. -Original Message- From: Nick Burch [mailto:apa...@gagravarr.org] Sent: Thursday, June 02, 2016 3:02 PM To: POI Users List Subject: Re: CTLongHexNumber On Thu, 2 Jun 2016, Murphy, Mark wrote: > Is there a way to use CTLongHexNumber with

CTLongHexNumber

Is there a way to use CTLongHexNumber without it causing a type cannot be resolved error? The error is: The type org.openxmlformats.schemas.wordprocessingml.x2006.main.CTLongHexNumber cannot be resolved. It is indirectly referenced from required .class files. I don't think this is an eclipse

RE: Difference of getLastRowNum() and getPhysicalNumberOfRows()

getLastRowNum() retrieves the index of the last row in a spreadsheet. These indexes are 0 based, and if you have no missing rows, row 1104 the last row will have index 1103. getPhysicalNumberOfRows() returns the number of rows actually used in the spreadsheet. Unused rows are just missing from

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

I don't know the answer to your question, but what happens when you try to embed the same document using Word? What does the XML look like? What does the XML look like when you try to embed it with POI? Give us a minimal example of the problem so we can easily see what is happening. Then

RE: Unable to understand how to merge Rows in POI

You are not calling the merge method after your for loop when finalIndex > 0. Immediately following the for loop you need to add: If (finalIndex > 0) { sendRangeToMergeCells(startIndex, finalIndex, sheet); } -Original Message- From: sunnykeerthi [mailto:sunnykeer...@gmail.com] Sent:

RE: How to "clone" values of a workbook

e system requires for instantiating the workbook instances. Best Regards Kai Murphy, Mark schrieb am 11.05.16 um 16:19: > I am trying to understand just what it is you are trying to do > >>> because the creation of workbook instances is pretty costly (about 200ms to >>> 1

RE: How to "clone" values of a workbook

I am trying to understand just what it is you are trying to do >> because the creation of workbook instances is pretty costly (about 200ms to >> 15 seconds for the workbooks we are dealing with) we implemented a pooling >> of workbook instances which seems to work pretty well. What do you mean

RE: SSPerformanceTest: Is the FAQ still accurate?

XSSF is an XML document. Given that XML is generally about 70-80% overhead vs. data, it is not surprising that binary spreadsheets (which can be optimized, and have very little overhead) are more memory efficient. In addition, XML must be parsed, but binary documents can frequently be accessed

RE: How to open word document in android studio

This all makes sense up until the point that you say: However this code is working in eclipse... What code is working in eclipse? The app you are trying to create? Code you wrote (using the POI API) to retrieve the contents of a word doc and print it to the console? Or are you talking about

RE: [Bug 59106] - WorkdayFunction does not read correctly the area with holidays to calculate work days

You also need to create unit tests that validate the patch, and possibly also documentation. From: Артем Бондарь [mailto:bonda...@gmail.com] Sent: Friday, March 11, 2016 2:46 AM To: user@poi.apache.org Subject: [Bug 59106] - WorkdayFunction does not read correctly the area with holidays to

RE: [Bug 59106] - WorkdayFunction does not read correctly the area with holidays to calculate work days

Yes, rename the ticket and attach the patch there. From: Артем Бондарь [mailto:bonda...@gmail.com] Sent: Friday, March 11, 2016 2:46 AM To: user@poi.apache.org Subject: [Bug 59106] - WorkdayFunction does not read correctly the area with holidays to calculate work days Hi Team, I have found

RE: Ability to set solid color on DataBarFormatting

I asked if anyone could tell me how to do a gradient fill a couple months ago. I do not believe the API supports it yet. -Original Message- From: Maheshwar Jayaraman [mailto:maheshwar_...@hotmail.com] Sent: Tuesday, January 26, 2016 1:14 PM To: user@poi.apache.org Subject: Ability to

RE: CellStyle Help

Very close, First create your workbook, then create your base styles that include your fonts and basic styles. Then when you create a cell you apply the style you want to it. Workbook wb = WorkbookFactory.create(new File("")); CellStyle cs1 = wb.createCellStyle(); CellStyle cs2 =

RE: Documentation for XSSF

, Mark <murphym...@metalexmfg.com> wrote: > Wow, that got totally hosed. Not sure where all those references came > from, but here it is without them. > > -Original Message----- > From: Murphy, Mark [mailto:murphym...@metalexmfg.com] > Sent: Friday, December 18,

Documentation for XSSF

Excel has an inconsistency in its fills. A solid fill defined for a cell needs a foreground color: This first fill shows in Excel as a cell with a yellow background, the second shows in excel with a white background (neither have

RE: Documentation for XSSF

Wow, that got totally hosed. Not sure where all those references came from, but here it is without them. -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Friday, December 18, 2015 9:48 AM To: user@poi.apache.org Subject: Documentation for XSSF Excel has

RE: Drawing Borders is SLOW

[mailto:apa...@gagravarr.org] Sent: Thursday, November 05, 2015 9:48 AM To: POI Users List Subject: RE: Drawing Borders is SLOW On Thu, 5 Nov 2015, Murphy, Mark wrote: > My thought was to build the borders on their own, then once the > borders are created, apply them to the cell styles in a singl

RE: Drawing Borders is SLOW

Re: Drawing Borders is SLOW Hi, I think there is a related bug entry at https://bz.apache.org/bugzilla/show_bug.cgi?id=54593 where we did some investigation and discussed caching things, but we could not create a complete fix yet... Ideas/Patches welcome! Thanks... Dominik. On Wed, Nov

RE: Drawing Borders is SLOW

Subject: Re: Drawing Borders is SLOW On Tue, 3 Nov 2015, Murphy, Mark wrote: > I am sure you all know this. But the problem increases as the number > of styles grows. In looking at the code, I am convinced that the > problem can be found in the fact that when borders are drawn, the cell

Drawing Borders is SLOW

I am sure you all know this. But the problem increases as the number of styles grows. In looking at the code, I am convinced that the problem can be found in the fact that when borders are drawn, the cell style is retrieved, the border is applied, and all styles are searched for a matching

RE: Cannot see text in cell after F2

color at https://bz.apache.org/bugzilla/show_bug.cgi?id=56548 A workaround might be to set the background fill color of the cell style to 65 in this case, let us know if it works for you so we can note it in the bug report. Dominik Am 18.09.2015 18:25 schrieb "Murphy, Mark" <murphym...@m

Fill and Border efficiency for XSSF format

POI 3.12 In looking at the styles.xml file generated by POI, It appears that a lot of borders and fills are created that are not used. Maybe POI needs a method to trim off those unused fills and borders on save. This method would also be able to normalize the fills and borders to remove

RE: Cannot see text in cell after F2

for or not. For a solid fill, there is no problem with that, but for other fills, it apparently will cause some problems. -Original Message- From: Murphy, Mark [mailto:murphym...@metalexmfg.com] Sent: Friday, September 18, 2015 11:56 AM To: user@poi.apache.org Subject: Cannot see text in cell after

Cannot see text in cell after F2

POI 3.12 - XSSF workbook I am having trouble with spreadsheets created by POI. When I open them in Excel, they look just fine, but when I try to edit the contents of a cell, I cannot see the value of the cell, it all turns black. I think it might be something having to do with the my style, as

How to hide formula bar on spreadsheet

In Excel under the View menu, I can uncheck the Formula Bar checkbox to remove the formula bar from the display. Is there a way I can do that with POI?