Issue 108737 - Some notes disappearing after edit, saving and opening again a spreadsheet
Summary: Some notes disappearing after edit, saving and opening again a spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.1.1
Hardware: Other Windows 95
: P3 Trivial with 1 vote (vote)
Target Milestone: 3.4.0
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, oooqa
: 114321 118056 (view as issue list)
Depends on:
Reported: 2010-01-28 13:12 UTC by wagafo
Modified: 2013-01-29 21:50 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

You can repoduce this issue using this simple spreadsheet and following the steps in my report (7.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-28 13:14 UTC, wagafo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description wagafo 2010-01-28 13:12:06 UTC
OpenOffice 3.1.1 on Ubuntu Gnu/Linux 9.10

I have a spreadsheet with a single worksheet. I wrote notes on all cells of the
first three columns with 1573 rows. After saving and reopening the spreadsheet
some of the notes are gone. I cannot tell a pattern, in some rows it alternates
rows where notes disappear (one OK, the next the note has diappeared, and so
on). There are also complete sequences of rows where notes have disappeared. It
seems related to cutting and pasting cells with notes. 

Here is a simple way to reproduce it: 
1) Create a spreadsheet with five rows and three columns.
2) Insert a note to each cell. 
3) Highlight and cut columns 2 and 3 from the second to the last row. 
4) Paste back starting in cell b3.
5) Save and exit
6) Reopen the spreadsheet

If I do this the notes for cell b3, b4, c3 and c4 disappear.
Comment 1 wagafo 2010-01-28 13:14:20 UTC
Created attachment 67457 [details]
You can repoduce this issue using this simple spreadsheet and following the steps in my report
Comment 2 Risto Jääskeläinen 2010-01-28 16:37:45 UTC
I can see too this dissappearing of notes in Calc 3.1.1 and 3.2 RC4 in Ubuntu
9.10 and in Calc 3.2 RC4 in Vista.

Moreover in Ubuntu I can see some extra lines on the sheet after notes are read
and closed. This extra lines dissappear after scrolling of the sheet. 

Best Regards
Risto J.
Comment 3 wagafo 2010-01-28 16:50:13 UTC
I confirm these lines appearing when working with notes, and disappearing after
scrolling in the spreadsheet. 
Comment 4 Rainer Bielefeld 2010-01-29 05:45:13 UTC
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"!
When you try to reproduce, do not cut rows, but range 'B1:C5'

No Problem when I save as .xls

This one might be a DUP of Issue 106619, Issue 102061, In Issue 102061 I left a
request to check.
Comment 5 daniel.rentz 2010-01-29 09:44:27 UTC
Comment 6 pseymour 2010-02-18 03:48:09 UTC
OpenOffice m19 (3.1.1) here in Windows XP. I can reproduce this simply by adding
a note in A1 of a new spreadsheet, deleting the first column, undoing the
action, and saving/reloading the file. Also, I do not have problems with
"cutting" columns, as to me this bug only manifests when I delete then undo columns.
Comment 7 floris_v 2010-06-03 23:25:51 UTC
Confirmed for version 3.2.0.
I received a report of notes disappearing after inserting a row in a spreadsheet
and saving/reloading from somebody working with 3.2.0 on Windows 7, but couldn't
reproduce that on Vista.
Comment 8 daniel.rentz 2010-06-04 09:00:30 UTC
Works better after fixing issue 109372, (OOo 3.2.1 integrated in OOO320m15, and
OOo 3.3 integrated in DEV300m77).
But still, some notes disappear.
Comment 9 daniel.rentz 2010-06-04 09:05:18 UTC
Comment 10 niklas.nebel 2010-09-06 09:25:42 UTC
*** Issue 114321 has been marked as a duplicate of this issue. ***
Comment 11 niklas.nebel 2010-09-06 09:26:57 UTC
A scenario where comments are still lost is described in issue 114321.
Comment 12 daniel.rentz 2010-10-19 19:19:27 UTC
The most simple scenario to reproduce the problem is as following:

1) create note in cell A1
2) select A1:A2 (important!)
3) cut
4) move cursor to A2
5) paste
6) save&reload
Comment 13 Regina Henschel 2011-05-20 13:40:12 UTC
*** Issue 118056 has been marked as a duplicate of this issue. ***