Created attachment 70944 [details] Minimal example to reproduce bug Caveat: this is hard to explain. Please try steps to reproduce or attached sample file. I think this might be similar to bug 51748. It seems that if you put a reference to a cell in one sheet in a cell on another sheet then other cells around also become mysteriously linked. However you cannot see these links in the content of the cells, but they behave like they are linked. It's hard to explain but it's a nightmare because you end up corrupting your whole file and by the time you realise what's happened you've overwritten lots of cells on different sheets. I cannot use an application with this behaviour as I cannot trust it not to lose my work. Steps to reproduce (the values below are arbitrary): * Create new spreadsheet * Enter value 50 in Sheet1.A1 * Enter value 60 in Sheet2.A1 * Enter "=Sheet2.A1" in Sheet1.A2 * Enter value "ss" in Sheet2.B1 * Change back to Sheet1 and you'll find that the value "ss" has been copied to Sheet1.B1. Why?! Thanks, Ian.
Win 7x64 Ultimate LibreOffice Version 3.6.4.3 (Build ID: 2ef5aff) I can not reproduce this issue. But this is intended if you have both sheets selected. LibreOffice help: " Copying to Multiple Sheets In LibreOffice Calc, you can insert values, text or formulas that are simultaneously copied to other selected sheets of your document. Select all desired sheets by holding down the Ctrl key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white. You can use Shift+Ctrl+Page Up or Page Down to select multiple sheets using the keyboard. Now when you insert values, text or formulas into the active sheet, they will also appear in the identical positions in the other selected sheets. For example, data entered in cell A1 of the active sheet is automatically entered into cell A1 of any other seleted sheet. " If this is the case not a bug.
At the moment have not the conditions to be a blocker.
Many thanks mariosv for your swift reply - you were absolutely right. This is not a bug at all but my mistake. I have been using Google Docs Spreadsheets and the shortcut for changing sheets in that app is Ctrl+Shift+PgUp/Down. I had been using this shortcut in LibreOffice as well and not realising the effect. Now that I know what's going on I will say that is difficult to notice (on my display at least) that I have several sheets selected at once. The difference between the white and the grey is not great - it's at the bottom of the screen and not where my eyes are looking when I make the mistake. If you are finding many other users making the same mistake as me I would suggest making it more obvious, perhaps by changing the cursor box to indicate something special is going on when entering data into multiple sheets at once.
Hi Ian, maybe change to a better title, can get more attention as enhancement.
Done, hopefully that's a bit better.
Comment on attachment 70944 [details] Minimal example to reproduce bug >PK����'Al9.���.������mimetypeapplication/vnd.oasis.opendocument.spreadsheetPK����'A²?.��.�����meta.xml<?xml version="1.0" encoding="UTF-8"?> ><office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:grddl="http://www.w3.org/2003/g/data-view#" office:version="1.2"><office:meta><meta:creation-date>2012-12-02T21:39:47.45</meta:creation-date><dc:title>MyDefault</dc:title><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>2</meta:editing-cycles><meta:generator>LibreOffice/3.6$Windows_x86 LibreOffice_project/58f22d5-270d05a-e2abed1-ea17a85-9b5702</meta:generator><dc:date>2012-12-02T21:41:15</dc:date><meta:document-statistic meta:table-count="2" meta:cell-count="5" meta:object-count="0"/><meta:template xlink:type="simple" xlink:actuate="onRequest" xlink:title="MyDefault" xlink:href="../../AppData/Roaming/LibreOffice/3/user/template/MyDefault.ots" meta:date="2012-12-02T21:39:46.91"/></office:meta></office:document-meta>PK��'A���������������settings.xmlíZßsÚ8~¿¿ñ;1$=<¡Ó&m®Í`öú&ì4µIÆ¡ýÉ6tÇN°r×9�ýøvY}ú´+ûìí}ÈZ+"XÝ£Õîc@ùb`ÝLß·ÿ´Þÿ8ÃùúàèÇ!pÕ "[z:nÞ=°bÁ]$J¤«|#àÛiîÃÑnf,o¹gß ¬¥RkÛI%½#»Ûï÷í¬w;ÔG>§º¦òÑM!âOCéÜÌÓéÛùo«µqòAhk¸ÃöïÏ6ò6U¦±imS×6é®($?£fÍ{<çJ:c0@¦YÛNµt'åÊvÎì§ /¾¹2üjY}|Òëí~t±,õ¼ÛsúuáÛ!ÚpAÑ$åkÍÑìë:Cr¼JhXÃÝyü_9úx·PÝüÇB¢¸FI¦ÿ·iòùï/PÐÈa^Ĩú(bPÔ7^ð~ &7èCÿ à|EW¡O_TÇÙ |ëoâµTIʸÍ÷õ°AàïáT£4Êèô°¸9Ú?Ù1d©´>~º£ÇÞU{Èpk¨DåÈ%ÏÏ*´ÓB×>a >}PèBú¬ÐUÝYÞ]wgeyEʧÞ{+/±%óæÀ°}8×æݵ´T«bÛ0YA·:f¾ÀÌùr:×ÁÿÊôn{ðWÈ)ê4ÃtuÓã6°®¢rA¤v=ù 3F2ÑBc�ýR~£¼u8C&=(¸ñ8¦8!RAq¡ØY9ð¥Üܳ0©×»:ùîtvT "|i¾/¼Ïº¢²áÚá x¹ó»R'ÝS鹿Èéx½d`s]X>@ª7Ĥüá+$ÁDËr¶6@í( >Þ >@1ý½y¸Ö QJPq1õ §Ç籶ìiW¬pLñôR¾Û<OðDTmÏ<ÀÐ9mö°ðÈ >nó§#_ø¡4§´&µ|CÆÏúGyâ^Wßå§úÎaÇÇ£(bë âQÄÁ?à#I ¿¹¯bRrãðÍÿòáü*)éTØ\0Ö2L|½�c#2UÆkVÓUɲoÄ^ÛTÓ>âlL¸ì7-u^©Nø/æÁÙ¥ýäý»êÍá?PK§ÐïÉ��Û!��PK��'A���������������content.xml½XMoã6½÷W*ÐM[þH¢Ú^,P-°¹l Åb´4D¤,ûßw¨/Kå(ëÔ'&ßÌ<>ÎI¯>¢p´©¸×Öt<±F»Âãq°¶^ÿ$÷Ö§Í/+áûÜÇnA¬+bGh+§][©ÁWNÌ"Pv@\Y9M´Ç*F>ÍspÓZÃA56Ø-ÛÖdÙPcEQæ¾j|P!ñª%LóCÈãkk§uâPeÙ8èôááæ³5a·Æ%©sçRÁSt:Ò >fCùlRF[¥a½ÚÕDB.×$æ0GMV~íÁÙµzdvwLγÜN7<Uf^Ó6bz׳¿÷ô'óÇ/§¼ÑÐXÛÊ<¼ÌÝ´BÔTAQì9]{2Óâ{]gk ¸{î²ÐÑ9Ñ7¥ °7)_BõØ´®ÁÊëuýÏã'w;ùÛ`Âc¥Y|RFMè]éJHÔµ0þðæ»e×Üv: >û[ ô¼³P¤3£ØF°ÉCök«·^ÎêÃí;5sÔç/ÒØ+ʺXÜL±07sZZ]CX^Mà¤J";'§aÝnÚ2:sg²Lx~×c§â\¥fú°Ï_©#æÌ®\FjÕ¶µ©æ¢|< Ï\ ¸¡Ú¬[ï÷Úú,9ÃÆÞW"OãMS3Cq¡X*ãJµ ×.v«=C[³µt@èÑKÌñΣǧ3,~cP¿wÅèerG¥!ºÝ#³ÊÔÿktîJ¡¯Gÿ²¿÷JÓÁÝD'^þî%UnÂæí鸯¸Ô×F§}uU³Tc Í]û©.ÿlquÅ´V²Ì ^;Â4ʲ9Hì 55ò³À~-`+A&tå±gÜ3W{l/ïÜ(çß s}Cnû÷p}ºIuáHU1ewÀ6ÛÉx¹\`ðËSD$G,$Mk-SxïM÷b~3Þ³ä=¸»ïùGò^ÌnÄ[³óù] FøFI�),þ�¥¡î,ª± âÁêqìXò)½5>GI§éÚ >%ÑÛw´ èkaÖb¤ù¥ ÿr°1ê4L²$Ô\tÌ|æ¿KLÆÓÙÒ{öÞâÍ°h Eòz-´·Q[áO÷)|J2Oí�ôfUÈg F%±æBÍ^¶ìÊ^y¥×üÕ\BÁ+>0 xwNìyò > ÕZpSh;(&ã¦vÈ¡¯ú~ÉÂ>&ôCÁ´ÕY[±6ìd³¬hùïv=¡´Ä==¹ô¼÷¹|[:;O.WUk|²µ/ªõ·<ìñçéwk°ËËw >ùöªg?¿j»k;ß/îfýÒ\Îã+h}dÄæÈ%n_]â]E_µß¬ïªy¬ñ³ûsÔ¼¾ÆmY¨GðÉ-A±jÜÒ[í¶<íù){óPK1_ñÐÉ����PK����'Aï¹éå��å�����Thumbnails/thumbnail.pngPNG > >��� IHDR���»������d?��¬IDATxíÚ?Niá±£` >Ä 8UKh¶£Ü.ÍR#¤J=¢0¾ËløSÀ >+y±#=OõYþüêýüaÇ~Û}_�ÅÐ(F14Ó³½þ8¿üwÎ7óçõãrùîæõj5ܼ|÷zÍ^M[ÌÃýéñöé_¯¾}~oëÕõvyqôz×sWçççÃÙ5`Òb¶»¯³¯OgÌÙpzüØÉñÉÿw¿Ü_ãr½}Î^o¦¼Tv´£ÛñbxºÇ¬án³Ãæ~¿»y~²xwÍ~M{Ƽ<Æ,þyøykÚü=]>7ow-ÿ:ù8}Z,§W¯×S^);íåyöæÃÎmË]»Øo×4¡QbhC£ÅÐð$4i1/£ål·ë/;'²)Ùn»o³Ù§_L"9hSst<^=þÙá·&¦IïJ/sŧ3f9ß5ä MûäûfƸsÉ!óvM£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡QbhC£ÅÐ(F14¡Qbhþ©Û ³cÃ:(����IEND®B`PK����'A���������������Configurations2/images/Bitmaps/PK����'A���������������Configurations2/popupmenu/PK����'A���������������Configurations2/toolpanel/PK����'A���������������Configurations2/statusbar/PK����'A���������������Configurations2/progressbar/PK����'A���������������Configurations2/toolbar/PK����'A���������������Configurations2/menubar/PK��'A������������'���Configurations2/accelerator/current.xml�PK�����������PK����'A���������������Configurations2/floater/PK��'A������������ >���styles.xmlÝYmÔ6þÞ_ Ôl²{@ÙåvO}©úÑ8Y'lg_ø;ý'ýeÛ±7¯{ >Þî.ö3ãÇ3ãqîòêSo¹ ¬XûóYä{¸YBlí¿»y<õ¯6?\²4%1^%,®r\È@È#ÅÂáB¬ÌäÚ¯x±bH±*PÅJÆ+Vâ >è^ÊheSÅ5¸)-ñANVØ,º¾²7¥öS8m§lªðAÐ eAÌòIÒ±â@Iñ~ío¥,Wa¸ßïgûãY8_.¡uÇWVjTbµç³yh±9hª} >Û4©¨ò[Ì'S$êíjɱ�¸«âr¢¦L+¾vÙäèÚe#4Ç[Ä'Ç·Cå"*IS6Gr;²¿OÃkÔ?®ÿ8Åϧ®¥°-ªbNÊÉntS1æLU&Ùµ¹(zçz¾çDbÞÇgá1¢±cåC¤n"À;òÍÓ£KgH:½Ø;ª[ÓñTU³ñ$9!¤-$M°#x¯UËÎó¿5È4Ðu*<så=eU42ÎáC9QSj±UKC+O¸Cß¼ Õ\ j0Túh=cÏÁ¢ ©Ø\úà=ó¬[û?s7H]È =Æ¢j&ÈpÞ@(=¢(!ÙvdS᥽w{×o¬¸J&ufô¼qG!qþ9Ö]£"dÆM|ÑÕIÌ`©ôþD/0¥¦û*̼ÅÃÞ»£FYÀW±æmYlq»z8Wõ¸iç¬ NQEë&Ïj®MÒ$1¥¾££rj:C3hÐÂÊ !B¢B5çãüD*}Amh+½S¶¢¶Ê`z :%9Xõû/~W0ÚÁÕ@«Ìâ>líLÕNüúª¯[µº;ätºù-éjuS/_é |si¨ºjíáäUäw@^ý" ÄÈ%$#R�åz¡NG\qmÿqh©y´xY/v¹ zfÉ+ì(8æ·ZkÚ;f±]Ûüý³¬£cÄA\#Â[øç]·³gU©o5Úò#mç§rrò]Eð&pêôã÷Ìñ4G¥Ü"!¦ß!ZáïgòÙÚÅ*KZ³´bæÇF²Ïìo&ü»«ÎuÃfoÿKåúP<å䦾Áâ¼¥+îÆ´½óJ6°¾èºHlõi0ôgÃÕ[`$#=IÔ U bFÜ×ô¢úoßÙ°Ç$ÛBC|,9Ob§M¬nt»Áu >ÓþÒ/0Ro/þqBg¢6&+Á*®Î¶¬r¸0`¤ÈÄ+¾QÑÈ®Á3(?)]û1Âågô¤tQB>¨sõI)ý±Èù¼Í¬¥v;¦Pʹ¼ÊüeÔ72ì´,õ£ >n¸(8h÷2¥:):²J¶»Ó2û ¾Qê >9ôkò@ÞödÞNÓÖXÊl_gÃT-ÞÖÍ~z<VH#ÁÅ©hòÞ½eRª+näú©pܤÚo`&46¶í {»0a÷ÿ§ÝS3·'ê¥ÙböhY»ª {÷"ý¥%JÌkÙhÍZ)¿WGxØ"~/Ô·£§!ýHé¹úÒ°»ã:WõDS!NÍTεKÍL(sÆüÍ¥~^Ö¿ÅcÞ\]]]ÝÁz¤ìÐÙzµöÀ&zÐcïÈ3ܸÕ_+_êe¶i7s»^c¬gUÕ"ý¬ aÇ»¨}S¿ñ;Ãì¢Ç¬=û3u)>lïÁI"iböhÔÒ)ÔYZ)<ÚUA¯æ@îó!³¢ù"ºíDQ¨?QT[¡=kp~·j²ª¢@nóÕÅrõèÉìÉ¿9y<{mç¾Y@za¨ïmå² 4c_(pÃáRÿnóPK!ðD��ä��PK��'A���������������META-INF/manifest.xmlSÁjÃ0½÷+ï±·iÚÃ`_Ð}ç(©Á%öïÚtõ&YÒ{O<y³;_!ØWù"*@[}#>÷õØmW`Ðu@¬¯A5Ì!ÝÒF:r¤Ñ ÍVÇØF[ ëýúÂtËî¬ÅvUM|óPóù<uwÅû:>4BÍLÏZgj>'hIÉ;kxhSGlåE°¼×))e0-�X¨%R°Ã3Ô'Vcy(ó`=ØFäqÝgãî%|¡q_C°!qÁô Æú"÷ëK¾8Ike¬C³²%ç¿7ûקEG ²8iïúÏgº¿Q¿¾éöPKhk��á��PK�����'Al9.���.��������������������mimetypePK�����'A²?.��.���������������T���meta.xmlPK���'A§ÐïÉ��Û!���������������¨��settings.xmlPK���'A1_ñÐÉ�����������������«��content.xmlPK�����'Aï¹éå��å��������������� ��Thumbnails/thumbnail.pngPK�����'A�������������������������È��Configurations2/images/Bitmaps/PK�����'A���������������������������Configurations2/popupmenu/PK�����'A�������������������������=��Configurations2/toolpanel/PK�����'A�������������������������u��Configurations2/statusbar/PK�����'A���������������������������Configurations2/progressbar/PK�����'A�������������������������ç��Configurations2/toolbar/PK�����'A���������������������������Configurations2/menubar/PK���'A�����������'�������������S��Configurations2/accelerator/current.xmlPK�����'A�������������������������ª��Configurations2/floater/PK���'A!ðD��ä�� >�������������à��styles.xmlPK���'Ahk��á���������������5��META-INF/manifest.xmlPK������6������
Sorry - didn't mean to do that - just trying to change type of attachment so it opens (which it does now). I have tried this and by selecting two sheets I can see that it is very easy to inadvertently edit data in multiple sheets and that it would be better if this were more obvious. Tested in 4.0 beta 2 on windows XP.
on tab color, would be nice to change tab contrast universally in settings rather than in each file and tab individually.
As a work around, I would set all my tabs with colours using Tab Colours. Tabs with colours are more obvious when they are selected for editing.
*** Bug 88840 has been marked as a duplicate of this bug. ***
*** Bug 104564 has been marked as a duplicate of this bug. ***
We have multiple requests for better visibility of multiple selected sheets. Other bugs and this one were marked as a dupe of Bug 57822, probably just because it's earlier. But that bug is messy so that's not correct and I rearrange. *** This bug has been marked as a duplicate of bug 88840 ***