https://issues.apache.org/bugzilla/show_bug.cgi?id=55292
--- Comment #16 from Darren Roberts <[email protected]> --- 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: [email protected] For additional commands, e-mail: [email protected]
