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 2009/11/02 19:47:31 UTC
DO NOT REPLY [Bug 48106] New: Cell Comments not visible using XSSF
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Summary: Cell Comments not visible using XSSF
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: tcarolan@gmail.com
Created an attachment (id=24462)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24462)
Test case taken from Busy Developers Guide and Output XLSX
The simple test case from the "Busy Developers Guide" to create Cell Comments
in an XSSF workbook does not work. The comments are not visible in the
resulting XLSX file.
A comments1.xml file is created but the comments triangle and message box is
not visible when the spreadsheet is opened in Microsoft Excel.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2009-11-03 15:41:58 UTC ---
Can POI see the comments?
Try writing the file out, opening it again fresh in poi and see if you can see
the comments. That'll help us figure out how far along things go before they
break
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #4 from Nick Burch <ni...@torchbox.com> 2009-11-03 17:18:58 UTC ---
Any chance you could create a similar one cell file in excel, and attach that?
That'll make it much quicker for us to spot what we're doing differently!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #8 from Yegor Kozlov <ye...@dinom.ru> 2009-11-27 09:47:06 UTC ---
fixed in r884918
Missing vmDrawing1.vml was important - this part stores visual properties of
cell comments (background color, position in the sheet, whether the comment is
visible, etc.)
I added support for cell comments to common SS interfaces so that it is
possible to use the same code to generate .xlsx or .xls output, see the updated
Busy Developers Guide.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
--- Comment #9 from Tom <tc...@gmail.com> 2009-11-30 15:17:22 UTC ---
I got 884918 from SVN and jarred it up and the comments are working. Nice job
on making the comment creation more consistent as part of the usermodel
interface. Thanks Yegor!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #8 from Yegor Kozlov <ye...@dinom.ru> 2009-11-30 06:43:25 UTC ---
fixed in r884918
Missing vmDrawing1.vml was important - this part stores visual properties of
cell comments (background color, position in the sheet, whether the comment is
visible, etc.)
I added support for cell comments to common SS interfaces so that it is
possible to use the same code to generate .xlsx or .xls output, see the updated
Busy Developers Guide.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Tom <tc...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
AssignedTo|dev@poi.apache.org |tcarolan@gmail.com
--- Comment #6 from Tom <tc...@gmail.com> 2009-11-04 10:41:54 UTC ---
Created an attachment (id=24474)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24474)
Workbook made using Excel with Cell Comments (visible)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Tom <tc...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
AssignedTo|tcarolan@gmail.com |dev@poi.apache.org
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Tom <tc...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from Tom <tc...@gmail.com> 2009-11-03 17:17:53 UTC ---
Yes, POI can see the comments after writing the XSSFWorkbook to disk.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
Tom <tc...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |tcarolan@gmail.com
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
--- Comment #5 from Tom <tc...@gmail.com> 2009-11-04 10:40:59 UTC ---
Created an attachment (id=24473)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24473)
Workbook made using Poi with Cell Comments (not visible)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 48106] Cell Comments not visible using XSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48106
--- Comment #2 from Tom <tc...@gmail.com> 2009-11-03 17:15:45 UTC ---
Created an attachment (id=24470)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24470)
Simple main() that writes/reads a cell comment to/from workbook
A very simple test case that writes an XSSFWorkbook with one cell. Comments are
added to the one cell and POI can read and cell comments after writing the file
to disk. However, comments are not visible using MS Excel.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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