Bug 57822

Summary: EDITING: When multiple sheets selected for editing please provide more obvious visual feedback
Product: LibreOffice Reporter: ian.cross
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: lowest CC: mariosv
Version: 3.6.3.2 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Minimal example to reproduce bug

Description ian.cross 2012-12-02 21:45:44 UTC
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.
Comment 1 m.a.riosv 2012-12-03 00:55:43 UTC
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.
Comment 2 m.a.riosv 2012-12-03 00:57:10 UTC
At the moment have not the conditions to be a blocker.
Comment 3 ian.cross 2012-12-03 08:14:51 UTC
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.
Comment 4 m.a.riosv 2012-12-04 14:04:36 UTC
Hi Ian, maybe change to a better title, can get more attention as enhancement.
Comment 5 ian.cross 2012-12-04 19:39:04 UTC
Done, hopefully that's a bit better.
Comment 6 john.pratt 2012-12-21 15:46:07 UTC
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.xml­SÁ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������
Comment 7 john.pratt 2012-12-21 15:49:40 UTC
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.
Comment 8 dansorvari 2013-08-08 16:20:07 UTC
on tab color, would be nice to change tab contrast universally in settings rather than in each file and tab individually.
Comment 9 my_wong 2014-03-19 03:03:05 UTC
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.