| Summary: | EDITING: When multiple sheets selected for editing please provide more obvious visual feedback | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | ian.cross |
| Component: | Spreadsheet | Assignee: | 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
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. |
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.