No, I moved on. Drawing borders was more important.
On 6:31PM, Thu, Dec 31, 2015 Javen O'Neal wrote:
> Mark,
>
> Were you able to get some answers about how to get a gradient fill in POI
> XSSF?
>
> On Thu, Oct 29, 2015 at 12:58 PM, Murphy, Mark
> wrote:
> > Has anyone been able to do a gradien
In XWPF, there is nothing about a style that indicates that it is a heading
style. If you want to understand how TOC determines what to call a heading,
you can look in the specs Part 4: Markup Language Reference, December 2006
section 2.16.5.75. You will see that it generally will use the style nam
Dominick, do the formulas still work in the English locale?
If so, it is possible that we could translate the formula names by adding a
translation table. Somehow we would have to find out all the locale
specific names of each function to do that though.
On Mon, Dec 12, 2016 at 5:41 AM, Dominik S
BTW, if you look at the quick guide
https://poi.apache.org/spreadsheet/quick-guide.html#CellProperties you will
find two methods of drawing borders without creating all those unused
intermediate styles.
On Mon, Dec 19, 2016 at 4:04 PM, Eric Douglas
wrote:
> Yeah, I wouldn't expect really fast re
Is POI producing this? What happens if you display the file with Word?
On Thu, Nov 16, 2017 at 10:47 AM, Simon Gaeremynck
wrote:
> Hello all,
>
> I think this is a bug but wanted to run it past the email list first
> before I open a bug ticket.
>
> I have a document that contains paragraphs and
What have you tried, what did you expect, and what happens? (Show Code and
sample data please)
On Tue, Nov 21, 2017 at 12:05 AM, shagunbhat...@gmail.com <
shagunbhat...@gmail.com> wrote:
> Problem
>
> How to add some part of data from source excel sheet to the destination
> excel sheet using Apac
Can you do what you want in Excel?
Here is what it looks like when I add borders in Excel.
The borders are re there though. If I look in Print Preview, it looks like
this:
So maybe what you are seeing is just the way Excel renders the borders you
have created.
On Fri, Mar 2, 2018 at 10:22 A
of Excel.
>
> 2. background fill: yes, that works fine through Excel. Except I am
> generating files and cannot go through every sheet of every workbook and
> manually make changes every time.
>
>
> Also: I cannot see either image you included.
>
>
> From: Mark Murph
The Cell Style overrides the Row Style. When you are setting a style in
POI, no new styles are created. The style being set is used as is. Be
careful of changing your style after you have used it. The change will
affect every cell that the style has been applied to. Instead I manually
create all th
So you should start with the un-sorted spreadsheet, make a copy, then sort
and save, then compare the two. You could also make an unsorted version
manually with Excel, save a copy, sort it, and then compare all four to see
how things got out of whack.
On Thu, Mar 8, 2018 at 1:39 PM, Dagnon, Willia
I'm thinking that this is a general rather than specific approach. Whether
you remove one or many rows, that would happen in the place called //
remove a row.
On Mon, May 14, 2018 at 10:52 AM, jsaunders2...@gmail.com <
jsaunders2...@gmail.com> wrote:
>
>
> On 2018/05/11 14:30:44, Andreas Beeker
According to the spec, the id's for footnotes and end notes are unique to
the note type (footnote or end note). You may want to create this so that
it can handle footnotes or end notes as there are only cosmetic differences
between the two. Similar to header/footer. Id's should be handled
internall
liot Kimber
> http://contrext.com
>
>
> On 7/20/18, 11:06 AM, "Mark Murphy" wrote:
>
> According to the spec, the id's for footnotes and end notes are unique
> to
> the note type (footnote or end note). You may want to create this so
> t
> that is motivating these updates but definitely need to make sure end notes
> are properly handled. I wanted to get a pull request in before I spent to
> much time just to make sure I wasn’t going off the rails somewhere.
>
> Cheers,
>
> Eliot
> --
> Eliot
CT Classes are added to the poi-ooxml-schemas jar based on unit tests. If
the class is used by a unit test, it is included in the jar. I generally
use the full schema in ooxml-schemas for development so I don't hit that
issue. And you should always add unit tests for new code, and examples so
that
Here's how I would do it:
public void setUnderlineColor(String color) {
CTRPr pr = run.isSetRPr() ? run.getRPr() : run.addNewRPr();
CTUnderline underline = (pr.getU() == null) ? pr.addNewU() :
pr.getU();
SimpleValue svColor = null;
if (color.equals("string")) {
One more thing, I want to keep naming consistent. For Abstract classes it
should be XWPFAbstract vs. AbstractXWPF. If you could rename your footnote
and endnote classes that would be great. And any other place that XWPF
exists, it goes first. This will keep things consistent with the rest of
POI.
Crap, not "string" but "auto".
On Wed, Aug 1, 2018 at 10:30 PM Mark Murphy wrote:
> Here's how I would do it:
>
> public void setUnderlineColor(String color) {
> CTRPr pr = run.isSetRPr() ? run.getRPr() : run.addNewRPr();
> CT
This looks like you are creating a page break at the end of the document
for each table in the document. So you will have all your tables, and at
the end of the document, you have a bunch of page breaks.
On Tue, Aug 7, 2018 at 10:57 AM venkatesh
wrote:
> i am trying to insert page break end of e
Use 1st edition, part 4. The CT classes were all generated from the 1st
edition schema.
On Thu, Aug 16, 2018 at 12:17 PM Eliot Kimber wrote:
> I'm using ECMA-376 3rd Edition / June 2011, Office Open XML File Formats –
> Part 1
>
> Although it looks like there's a 5th edition from 2015. I'll get
schemas?
>
> Cheers,
>
> E.
>
> --
> Eliot Kimber
> http://contrext.com
>
>
> On 8/16/18, 11:25 AM, "Mark Murphy" wrote:
>
> Use 1st edition, part 4. The CT classes were all generated from the 1st
> edition schema.
>
> On Thu, A
Does it require XMLBeans 3.01, or will 2.3 still work?
On Mon, Aug 20, 2018 at 11:53 AM Dave Fisher wrote:
> Hi -
>
> A vote to release XMLBeans 3.0.1 is currently in progress on the
> d...@poi.apache.org mailing list. You can take a look there and download
> the RC.
>
> Regards,
> Dave
>
> On A
Ok, there are two requirements here, one to build POI, and the other to run
POI. Is XMLBeans 3.0 required to both build and run POI 4.0? Or just to
Build it? Will it still run on XMLBeans 2.3 or 2.6 albeit with less
functionality? Or have we changed the runtime requirement to XMLBeans 3.01.
On Mon
Sorry, I have a real job, and I don't have a lot of free time.
On Thu, Oct 4, 2018 at 12:43 PM ranzhang35 wrote:
> Mark:
> please email me at rzhang at mkprod.com
>
> I have multiple projects and I'm a hardware engineer. I will issue
> you a PO for your time if you know how to r
I don't think there is anyone working on sections. But, I would want a
section class that is used by the document class much like headers and
footers. The document object would need to be able to create, retrieve,
move, and remove sections. In addition, it might be nice to be able to mark
a particu
adding references to them on the
> CTSectPr for the section, but I haven't tried it yet.
>
> I think the correct behavior is to have sections use the default
> header and footer if the section doesn't specify it's own (that's certainly
> what I woul
I see no issue in the Bugzilla. Without an issue there, the chances of it
being worked on or even considered are poor at best.
On Fri, Jul 12, 2019 at 9:29 AM Kirill Rajbhandary <
kirill.rajbhand...@jedox.com> wrote:
> Dear POI Users Group,
>
> Unfortunately I did not subscribe to POI Users List
Maybe you could take a look and see if you can narrow down what the issues
are. Then maybe you could contribute a patch?
On Fri, Jul 12, 2019 at 11:10 AM Mark Murphy wrote:
> I see no issue in the Bugzilla. Without an issue there, the chances of it
> being worked on or even considered ar
I'm pretty sure macros are not implemented.
On Mon, Jul 29, 2019 at 6:43 PM Sekhar P wrote:
> Just want to add more information to my initial question:
> i need to detect if there is any HYPERLINK macro in xls/xlsx files and
> reject them, looks like we need to read each cell to verify this. Is
What have you tried?
On Wed, Sep 18, 2019 at 4:35 AM Bhavya Kothapally <
bhavya.kothapa...@verizon.com> wrote:
> I have a document with title and contents.
> I have used XWPFParagraph for paragraph, XWPFTable for table, XWPFSdt fro
> content control.
> I am unable to replace the title with other
So for each SDT in Test.docx you are creating a new document, adding some
text, and writing it to TestOP.docx. What is happening? Are you just
overwriting TestOPdocx for each SDT, and you only get the last one? Is
there only one SDT in Test.docx? Where is the Title in the document? Did
you know tha
Ok, the table of contents is not a page, instead it is a field. Support is
somewhat limited, but I have found that the easy way to create one is by
following my Stack Overflow answer here:
https://stackoverflow.com/a/40264237/2296441. This creates an automatic
table of contents that uses Heading st
Not unless it is a manual page break. The amount of text that fits on a
page is up to the client, font size, page size, etc. Even different
versions of Word can end up with different page breaks.
On Thu, Feb 20, 2020 at 8:36 PM Nick M wrote:
> Hello,
>
> I'm using POI to perform a variety of tas
33 matches
Mail list logo
