You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/07/22 16:03:53 UTC
[Bug 55292] New: XSSFTextBox enhancements
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Bug ID: 55292
Summary: XSSFTextBox enhancements
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: robertsdjguard-poidev@yahoo.com
XSSFTextBox is currently very limited functionality wise compared to TextBoxes
in HSSF and XSLF. For example it currently only allows you to set a single
paragraph of text (when multiples should be allowed) and provides no
functionality for manipulating that paragraph without manually amending the
internal structure.
I am implementing enhancements to address this and will upload patches when
available.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #16 from Darren Roberts <ro...@yahoo.com> ---
Not really as there doesn't appear to be any documentation regarding how Excel
treats auto-numbering. The OOXML specification for the startAt attribute only
say this:
Specifies the number that starts a given sequence of automatically numbered
bullets. When the numbering is alphabetical, the number should map to the
appropriate letter. For instance 1 maps to 'a', 2 to 'b' and so on. If the
numbers are larger than 26, then multiple letters should be used. For instance
27 should be represented as 'aa' and similarly 53 should be 'aaa'.
Even the MS docs here say nothing more than the specification:
http://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.autonumberedbullet%28v=office.14%29.aspx
At the weekend I did a file in Excel that had two bullets at level 1 and on the
first bullet I set the startAt as 5. This got me 5 and 6 in Excel which is what
you'd expect. When I took a look at the drawing.xml file what it actually had
was startAt set on both buAutoNum elements as 5. To my mind, and by the above
that means both should be 5. That's the way I implemented the simple shape
getText method - if it has startAt set then it sets the starting number for the
level as that and increments from there for each following bullet. If the
second bullet also has startAt as 5 it will use 5.
I wonder if Excel actually uses the startAt as a linking value, so if all the
buAutoNum elements at a given level have startAt as say 5 then they are
considered as a releated group and so the first element uses 5, and the rest
are incremented.
If anyone can point me to documentation on how Excel calculates the auto number
then that would be great, otherwise I think we're in best guess territory.
With regards to your previous reply I did respond but it doesn't appear to have
gone through. I'm leaning towards overriding setBullet as it seems cleaner,
although it does little to actually simplify the problem.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Darren Roberts <ro...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30646|0 |1
is obsolete| |
Attachment #30647|0 |1
is obsolete| |
--- Comment #21 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30651
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30651&action=edit
Replacement patch which implements getText() auto-numbering according to Excel
rules
I've implemented the auto-numbering rules I found in a document on the
openxmldeveloper.org website and the getText() auto-numbering does now tally
now with what I see in Excel 2010.
Also expanded XSSFSimpleShape getText() so that auto-numbered bullets will now
appear according to their type/scheme - so you will get alpha (a,b,c), arabic
(1,2,3) or roman (i, ii, iv) along with the various options for brackets and
periods. In the case of the wingdings scheme I use the default bullet character
since we getText returns a string rather than a rich text string.
Normal bullets will also use the bullet character if it has been explicitly set
in the getText() output.
I think this is just about as complete as I can make this function (even if the
code isn't pretty). I have contemplated a method on the XSSFTextParagraph which
would calculate that paragraphs auto-number (for dev's manually parsing the
paragraphs) but I think that can wait and be implemented as a seperate patch.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #14 from Tim Allison <ta...@mitre.org> ---
Would overriding setBullet like this work:
setBullet(boolean flag)
setBullet(ListAutoNumber scheme)
setBullet(ListAutoNumber scheme, int startAt)
(In reply to Darren Roberts from comment #13)
> Created attachment 30647 [details]
> Replacement patch which fixes invalid content in unit test output
>
> Added checks to remove the buChar element if a bullet is set as auto-number
> which should solve the problem of invalid content when opened with Excel.
>
> Also fixed unit-test TextBox size so it should now fully contain the content.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Darren Roberts <ro...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30617|0 |1
is obsolete| |
--- Comment #5 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30620
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30620&action=edit
Replacement patch which tidies up some code and removes redundant style setting
in default shape constructor.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #8 from Tim Allison <ta...@mitre.org> ---
Created attachment 30632
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30632&action=edit
Replacement patch with small mods
Only a few cosmetic changes. The initial patch was in great shape!
Let me know which you'd prefer:
Plan A: You add back in the bullets. I review and then allow a few days for
the community to review it, and then I commit.
Plan B: We leave until Monday for the community to review the current patch. I
commit that and then you submit a separate issue.
Thank you, again, for contributing this.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Darren Roberts <ro...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30618|0 |1
is obsolete| |
Attachment #30620|0 |1
is obsolete| |
Attachment #30632|0 |1
is obsolete| |
--- Comment #10 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30637
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30637&action=edit
Replacement patch which includes bullet properties and associated unit test
This patch has the bullet properties included and a unit test for that
functionality. It includes all mods done in attachments 30632.
I have also added a method to XSSFSimpleShape to add a new paragraph from a
string (alongside the rich text string it already supported), and updated the
XSSFSimpleShape getText method to replicate bullets and autonumbering, along
with tabbed indentation for each level. Note that these do not replicate the
format of the bullets, the getText method is just a quick way to get all the
text in the shape in a semi-representative plain text format. If the developer
wants an exact representation they should access the list of paragraphs and
manually construct it from them.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #4 from Darren Roberts <ro...@yahoo.com> ---
Great, thanks Tim.
Through further testing in my actual project I have identified a number of
other small things that need to be addressed - for example the defaults for a
new XSSFSimpleShape set the background to blue which is at odds with Excel
(white), and also if you don't explicitly specify the text color then I'm
getting it coming through as white by default although I seem to recall seeing
this was an issue elsewhere? I'll take a look at them anyway.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Tim Allison <ta...@mitre.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30651|0 |1
is obsolete| |
--- Comment #23 from Tim Allison <ta...@mitre.org> ---
Created attachment 30652
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30652&action=edit
final (?) patch
Wow and wow. This is fantastic. I made one small change to your code and
added one test case.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Tim Allison <ta...@mitre.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #24 from Tim Allison <ta...@mitre.org> ---
Committed as of r1508692. Thank you, Darren!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #18 from Darren Roberts <ro...@yahoo.com> ---
But what happens when someone loads a file containing numbered bullets in a
TextBox? The other way to look at it is as I said in an earlier response the
getText method is a simple way to get the basic text out, for anything more
complicated the developer would need to parse the paragraphs manually which
means they have the headache of working this out for themselves anyway.
I see no reason to exclude setBulletAutoNumber as that caters to the dev's like
me who are creating xlsx files with POI more than reading them.
But since the current missing piece of information is how Excel calculates the
numbers, perhaps in the getText method instead of calulating (guessing) what
the number should be then we should just output something identifiable like
"[autonum] bullet text" or "? bullet text". That way we've informed the dev
that there should be a number or something there, but it's up to them how to
handle it?
It would be so much easier if the schema just stored the value Excel assigned
the bullet, even if it was just a hint... <sigh>
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #22 from Darren Roberts <ro...@yahoo.com> ---
> I think this is just about as complete as I can make this function (even if
> the code isn't pretty). I have contemplated a method on the
> XSSFTextParagraph which would calculate that paragraphs auto-number (for
> dev's manually parsing the paragraphs) but I think that can wait and be
> implemented as a seperate patch.
Almost forgot, I also implemented the setBullet override.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Darren Roberts <ro...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #30637|0 |1
is obsolete| |
--- Comment #13 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30647
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30647&action=edit
Replacement patch which fixes invalid content in unit test output
Added checks to remove the buChar element if a bullet is set as auto-number
which should solve the problem of invalid content when opened with Excel.
Also fixed unit-test TextBox size so it should now fully contain the content.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #2 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30618
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30618&action=edit
Xlsx test file for the unit tests
Lives in test-data/spreadsheet folder.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #7 from Darren Roberts <ro...@yahoo.com> ---
Ah, a remnant from the presentation side. I think this function could be
removed at the moment as I believe from the docs that level only has any
relevance when it comes to bullets (to determine the style of bullet to use at
a given indentation level), and since this enhancement doesn't support bullet
properties yet it's a moot point.
If you could upload your modified patch so I can apply your changes to my copy,
I can probably find a few hours over the weekend to look at incorporating the
missing bullet functionality.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #20 from Nick Burch <ap...@gagravarr.org> ---
(In reply to Darren Roberts from comment #16)
> Even the MS docs here say nothing more than the specification:
> http://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.
> autonumberedbullet%28v=office.14%29.aspx
If the Microsoft documentation is missing something, the first place is to ask
on the relevant Open Specifications Community forum for the document, see
<http://www.microsoft.com/openspecifications/en/us/applied-interoperability/support/default.aspx>
for the links to the forums
If that doesn't get an answer in a sensible amount of time, let me know and
I'll give you the email address of the docs team and you can ask them directly.
(They do check the forums though, so you might well get an answer from there)
The Interoperability Specification Team at Microsoft are very keen for their
documentation to be complete and useful, so they do want to know if there is a
problem or noticable gap in the docs they publish!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
Evgeniy <e...@bev.su> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|unspecified |3.10-dev
OS|Linux |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #11 from Tim Allison <ta...@mitre.org> ---
Created attachment 30646
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30646&action=edit
testAddBulletParagraphs result
Excel is throwing an "unreadable content; want to recover" message when I try
to open the wb created in testAddBulletParagraphs. Excel is able to recover,
but can you tell what's causing this? To generate this attachment, I added the
following at the end of testAddBulletParagraphs:
try{
OutputStream os = new FileOutputStream(new File("C:/data/testbullets.xlsx"));
wb.write(os);
os.flush();
os.close();
} catch (IOException e){
e.printStackTrace();
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #17 from Tim Allison <ta...@mitre.org> ---
Ah, ok. Would it make sense to leave out the setBulletAutoNumber functionality
for now? Someone can add that functionality on a later patch?
I did get your message about overloading setBullet(). I tried the no-thinking
process of just replacing setBulletAutoNumber with setBullet(...), and I wasn't
getting any numbers out in your test case.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #6 from Tim Allison <ta...@mitre.org> ---
I made a few small cosmetic changes.
In XSSFTextParagraph what should this javadoc read:
/**
* Specifies the particular level text properties that this paragraph will
follow.
* The value for this attribute formats the text according to the
corresponding level
* paragraph properties defined in the SlideMaster.
SlideMaster?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #15 from Tim Allison <ta...@mitre.org> ---
So close. Thank you for bearing with me. The numbering in the created xlsx
(as interpreted by Excel) differs from the test case:
3. Second bullet (level 1)
1. Third bullet (level 1)
Is there an easy fix?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #3 from Tim Allison <ta...@mitre.org> ---
Darren,
Thank you very much for submitting this. If an experienced committer is
willing to back me up, I'd like to take this as my first review+commit. I
should have feedback by tomorrow.
This should solve (https://issues.apache.org/jira/browse/TIKA-1100).
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #9 from Darren Roberts <ro...@yahoo.com> ---
No problem, I needed some of it's capabilities for my own project which was my
primary driver!
I'm easy, obviously I don't want to hold up any release. Probably the best
thing to do is see how I get on over the weekend - naturally I'll merge your
patch with my source so I retain your modifications and then if I get round to
finishing the bullets I'll upload a new patch for review.
If not, commit your patch and when the new release is done I'll just have to
update and merge my source, generate a new patch and attach it to a new issue
for review.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #12 from Darren Roberts <ro...@yahoo.com> ---
(In reply to Tim Allison from comment #11)
> Created attachment 30646 [details]
> testAddBulletParagraphs result
>
> Excel is throwing an "unreadable content; want to recover" message when I
> try to open the wb created in testAddBulletParagraphs. Excel is able to
> recover, but can you tell what's causing this? To generate this attachment,
> I added the following at the end of testAddBulletParagraphs:
>
> try{
> OutputStream os = new FileOutputStream(new
> File("C:/data/testbullets.xlsx"));
> wb.write(os);
> os.flush();
> os.close();
> } catch (IOException e){
> e.printStackTrace();
> }
Ah, I have been able to figure out what it is that Excel doesn't like - by
default in the code when you set a paragraph as a bullet using setBullet(true)
it sets a character to use as the bullet, but Excel doesn't like this being
defined if you then set the bullet to use auto-numbering. Remove the buChar
from the XML for the auto-number bullets and it loads without issue (almost,
the arbitrary size text box actually needs to be bigger).
Interestingly the spec makes no mention of the buAutoNum and buChar elements
being exclusive, so presumably it is an Excel-ism. LibreOffice Calc loads
without complaint, but doesn't appear to support bullets in the textbox (just
displays them as normal paragraphs) so that doesn't help as far as testing
goes.
So two options, I can either remove the automatic setting of the buChar (in
which case Excel does not display anything, it does not substitutes a value),
or set it and remove it if you call setBulletAutoNumbering?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #19 from Darren Roberts <ro...@yahoo.com> ---
(In reply to Darren Roberts from comment #18)
> But what happens when someone loads a file containing numbered bullets in a
> TextBox? The other way to look at it is as I said in an earlier response the
> getText method is a simple way to get the basic text out, for anything more
> complicated the developer would need to parse the paragraphs manually which
> means they have the headache of working this out for themselves anyway.
>
> I see no reason to exclude setBulletAutoNumber as that caters to the dev's
> like me who are creating xlsx files with POI more than reading them.
>
> But since the current missing piece of information is how Excel calculates
> the numbers, perhaps in the getText method instead of calulating (guessing)
> what the number should be then we should just output something identifiable
> like "[autonum] bullet text" or "? bullet text". That way we've informed the
> dev that there should be a number or something there, but it's up to them
> how to handle it?
>
> It would be so much easier if the schema just stored the value Excel
> assigned the bullet, even if it was just a hint... <sigh>
Actually, I've just found something online which gives a little bit more
information regarding rules for calculating the numbers which actually makes
sense of the two startAt="5" elements I saw. I'll try modifying the getText
method to use these rules and see if that gets us any closer to Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55292] XSSFTextBox enhancements
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #1 from Darren Roberts <ro...@yahoo.com> ---
Created attachment 30617
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30617&action=edit
Patch which implements extended functionality for XSSFTextBox and unit tests
for major features
First pass at the enhanced XSSFTextBox functionaility.
Note that the new functionlaity does not currently support bullets or
hyperlinks. I will look at adding these later. Unit tests have been implemented
in TestXSSFDrawing for the major features (text setting/extraction, font and
color setting and retrieval). I will look at implementing additional unit tests
in time.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org