Adjusting comment pointer problem

[jackrcook]

I need a hint on how to move the arrowhead to the correct cell.
Attempts to drag the little green box at the arrow head to the cell with the value 11,596.00 fail.
I want the arrow to point to the red dot at the upper right corner of the correct cell.
I had the cell pointer in the cell showing the 11,596 when I started the "insert comment" process but it insists on pointing as shown in my screen shot.
I should point out that this problem persists at any cell I attempt to add a comment in this sheet tab. Other sheet tabs in this workbook work properly. Its as if a property of this particular sheet has been altered.

[Villeroy]

Put your comments in cells or better use a database.

[jackrcook]

Put your comments in cells or better use a database.

Not quite the help I was looking for. I really want to fix what's broke not re-invent.
Thanks

[Villeroy]

I can offer macro code to transfer annotations to cell values.

[Calc, Basic] Introspective cell functions
right neigbour cell: =CELL_NOTE(SHEET();ROW();COLUMN()-1)

[RoryOF]

Strange problems in OpenOffice are frequently cured by deleting or renaming the OO user profile. Details on this are in
viewtopic.php?f=74&t=12426

[jackrcook]

Strange problems in OpenOffice are frequently cured by deleting or renaming the OO user profile. Details on this are in
viewtopic.php?f=74&t=12426

Since my last post I did the following to no avail.

A) I copied the file to my MBP Laptop and opened it using OO. The same pointer problem was present in the file. This almost eliminates the corrupt profile theory since I get the same result of two independent computers.

B) I then renamed my OpenOffice User Profile folder, re-started OpenOffice and answered the first time opening screen questions. Then I opened the file with the glitch. It persisted. Not a user profile problem confirmed.

C) I then attempted to delete rows and columns to upload a water-downed version to make the file acceptable for uploading here. Low and behold, removing columns to the left of the problem cells corrected the problem. However, I can't permanently remove those columns from my working SS. So, I then re-inserted columns and deleted columns hoping that that would fix the problem. But it didn't. Villeroy suggestions will not work for me since there are no blank cells near the ones that require notations. Of course, my goal is to fix the problem, not accommodate it.

Thanks again, and maybe somebody will have a suggestion that works.

[acknak]

What document format are you saving to? Saving to any format other than OOo's native ODF format (.ods for spreadsheets) carries some risk of losing formatting. If you're not saving as ODF, try that and see if you still have a problem.

Even so, Calc's comments are not reliable enough for me to recommend putting a lot of time into them. There are reports here of comments disappearing or being relocated to some other part of the document.

[jackrcook]

Acknak,
The file has been ODS for several years now. As to the comment being miss-located, its only one cell away but a frustration when trying to fix it.
Keep in mind, there are about 8 sheets in this file and only one sheet exhibits this nuisance.

[RoryOF]

A quick thought: if the pointer is one cell away, are there any hidden rows/columns on that sheet?

[MrProgrammer]

Keep in mind, there are about 8 sheets in this file and only one sheet exhibits this nuisance.

Create a new sheet. Select the cells you're using in the problematic sheet. Edit → Copy. Select the new sheet. Edit → Paste. If the problem is gone, delete the problematic sheet and move on with your work.

Of course, my goal is to fix the problem, not accommodate it.

Personally I have found comments to be troublesome and I now never use them. Instead of typing 11596 in your cell and then using many additional steps to add the dated comment, I would just put =IF(DATE(2015;8;12);11596;"Bought 30 shares at 112.61") in the cell. The date, value, and comment are all stored in one location. For the IF() function, all dates except 1899-12-30 are "TRUE" so the value of the function is 11596 and the text is ignored. You can continue to use comments if you want, but I'd say you can expect more problems ahead. You may not like it, but that's my best advice for this situation. I never have any trouble with comments using this technique.

[jackrcook]

Mr P
Your IF() solution is a very interesting option. I will keep this in mind the next time I run into this problem. I did try the copying to new sheet idea and the problem followed right along.
Thanks