Google Docs ODS export is buggy. The cell annotations are exported like this: <office:annotation draw:style-name="gr1" draw:text-style-name="P2" svg:width="0.01mm" svg:height="357.51mm" svg:x="0mm" svg:y="0mm" draw:caption-point-x="172.14mm" draw:caption-point-y="19.94mm"><dc:date>2015-08-19T00:00:00</dc:date><text:p text:style-name="P1"><text:span text:style-name="T1">Annotation text</text:span></text:p></office:annotation> The problem is svg:width=0.01mm attribute. It renders the annotation unviewable and uneditable. Your only hope is to delete it from ODS and write over again. Does Calc need such precise control over annotation sizes? 0.01mm is less than 1 character width.
So it's Google doc's bug or bug in LO? If google's export is wrong, then should be this bug closed as "notourbug".
yes we do need such precise annotation and asking us to be less precise because Google Export is....wonky...makes no sense. Closing as NOTABUG.