GNOME Bugzilla – Bug 629303
"= (any cell number)" overwrites existing formatting
Last modified: 2010-09-13 10:05:38 UTC
I *so* had hoped it was a temporary 1.9 thing, but alas. :'( example: cell B265 content: 9/9/2010 cell B265 format: d/m cell B265 shows: 9/9 cell P44 content: =B265 cell P44 format: d/m/yyyy cell P44 shows: 9/9/2010 (everything OK up to here) When I change the content of P44 to "=B266" the format of P44 gets overwritten by the format of B266. This is happening since version 1.9 and it's actually quite annoying. :P cell B266 content: 10/9/2010 cell B266 format: same as B265 cell B266 shows: 10/9 (as it should) edited cell P44 content: =B266 cell P44 format: unchanged cell P44 shows: 10/9 (should have been "10/9/2010") Is this intentional, is it a bug, is there a way to lock the format of a cell so the format doesn't get overwritten, or should I stick with 1.8 (which would be a shame)?
"I *so* had hoped it was a temporary 1.9 thing, but alas. :'(" It might have been, had you reported the issue...
Actually, I meant "a temporary 1.10.9 thing" :D (Oops. Sorry.) So 1.10.8 was still OK (to me, that is) and 1.10.9 + 1.10.10 overwrite existing formatting. I also found Gumeric *doesn't* copy the cell format anymore (in my case: the background color) when using Ctrl-C + Ctrl-V, but only copies the content, so I now need to use Ctrl-C + Ctrl-Shift-V + All + OK to get the same result. Example: cell C266 content: =I266-H266, background color: orange Ctrl-C + Ctrl-V to C267 cell C267 content: =I267-H267 (OK), background color: white (not OK) And no, I'm not really going back to 1.8, just (hopefully temporarily) to 1.10.8. ;) Sorry about the wrong version number!
please file a separate report regarding the copying. Thanks.
I have created bug 629473 for the issue raised in comment 2.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
*** Bug 629473 has been marked as a duplicate of this bug. ***
I had added it because they somehow felt related... one copying too much, the other copying too little, even though on second thought I *should* have filed a second report. Funny that on third thought it actuallay was the same bug. :D (And fixed! Yay!)