|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Cell annotation is rendered transparent after doc store | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | App Dev | Reporter: | bmarcelly <marcelly.bernard> | ||||||
| Component: | api | Assignee: | oc | ||||||
| Status: | CLOSED FIXED | QA Contact: | issues@api <issues> | ||||||
| Severity: | Trivial | ||||||||
| Priority: | P3 | CC: | chne, issues, richard.fearn, thierry.munoz | ||||||
| Version: | 3.3.0 or older (OOo) | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | All | ||||||||
| OS: | Windows XP | ||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
| Developer Difficulty: | --- | ||||||||
| Attachments: |
|
||||||||
sw->nn: One for you methinks Created attachment 36327 [details]
Document contains 3 test macros showing details of the problem
Changing target to 2.x I see a similar problem with 2.0.3. I'll attach some code demonstrating the problem. The behaviour differs depending on whether (a) the document is saved by the code, and (b) any manual changes are made to the document. The code creates a blank spreadsheet document, adds some annotations, and saves the document. Test 1: annotations added and document saved programmatically. If the document is then manually closed and reopened the annotations are missing. Test 2: annotations added programmatically; document saved manually by clicking Save button. If document is then manually closed/reopened the annotations are missing. Test 3: annotations added and document saved programmatically; change is made manually (e.g. entering a value into a cell). Document is then manually saved/closed/reopened; annotations are present, but they (a) have a transparent background (as the bug reporter mentioned) and (b) they are displayed in the wrong position, in the very top left corner of the sheet. Test 4: annotations added programmatically; a change is made to the document and it is then manually saved/closed/reopened. Annotations are not present. So annotations are only saved if (1) the document is saved programmatically, (2) a manual change is made, and (3) it is saved manually. When annotations are missing, they aren't in the content.xml file inside the .ods file. Created attachment 42013 [details]
Test program showing annotations not being saved
This bug still exists in OpenOffice.org 2.1. retarget 2.x -> 3.x taking over. checking if that still happens in CWS dr66... Already fixed (by chance) due to fundamental reimplementations in the area of cell annotations. back to QA verified in internal build cws_dr66 OK for me on OOO310m2 (Build 9385) This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues Sorry this issue was wrongly closed. This issue will be reopened automatically. And will be set after that back to fixed/verified. Set to state 'fixed'. Set back to state 'verified/fixed'. Again. Sorry for the mass of mails. This issue is closed automatically. It should be fixed in a version with is available for longer than half a year (OOo 3.1). If you think this issue isn't fixed in the current version (OOo 3.2) please reopen it. But then please pay attention about the field 'target milestone'. The closure was approved by the Release Status Meeting at 22nd of February 2010 and it is based on the issue handling guideline for fixed/verified issues : http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues |
The described anomaly appears in 2.0.2 but not in 1.1.4 When an annotation is inserted in a Calc cell through com.sun.star.sheet. XSheetAnnotations.insertNew() the annotation is correctly shown with the usual yellow background. After the document has been stored, closed, reopened, the annotation turns to a transparent background. Basic example: Sub ajouterNote dim maFeuille as object, maCellule as object dim lesNotes as object, adr as object maFeuille = thisComponent.Sheets.getByIndex(0) maCellule = maFeuille.getCellRangeByName("F11") adr = maCellule.CellAddress lesNotes = maFeuille.Annotations lesNotes.insertNew(adr, "bla ble bli blo blu") End Sub The same example works correctly in 1.1.4.