Created attachment 99948 [details] Example spreadsheet Problem description: When I click on a cell its content's font changes by itself. I attached an example spreadsheet and a video I recorded. Steps to reproduce: 1. Open attached spreadsheet. 2. Click on any cell that contain some text like I do it in the video. 3. .... Current behavior: Text's font is changing. Expected behavior: Text's font should not change. Operating System: Ubuntu Version: 4.2.3.3 release
Created attachment 99949 [details] Video recording of the problem
Hi Adam, the font is changing because there is a direct formatting that is applied to the cell style. Go under Format > Cells, under the Font tab, you'll see that this is the Time New Roman CE that is set upon the Default style. In C column, the style that is set is Excel_BuiltIn_Comma. If you open the Style and formatting window (F11) and right click on the name of this style, then select Modify, you'll see that the Font setting is Arial. If you want to remove the direct formatting applied, select the columns containing text, right click and select Clear direct formatting. So it's not a bug. If you need help applying or modifying style in spreadsheet, please ask on our Ask site or the users mailing list, thanks. Closing as worksforme. Sophie
If I enter some text in C11 and I clear its direct formatting then its font changes to Mangal but it still changes randomly when the cell is selected/unselected. Also the font of the text in the B column changes randomly when the cells are selected/unselected. Sometimes they change sometimes they don't. If this was a feature and not a bug then they would always change. Also if this is a feature then please direct me to the documentation in which it is explained how to make fonts change upon clicking on their cells. I really don't think fonts should be changing randomly all the time. They should just stick to one style until they are changed manually.
(In reply to comment #3) > If I enter some text in C11 and I clear its direct formatting then its font > changes to Mangal but it still changes randomly when the cell is > selected/unselected. Tried to reproduce this with 4.1.6 and 4.2.4, but couldnt. Testing the issue in LibO 4.0.6 and it keeps the text as Times New Roman even when selecting it, similar to Excel 2013 and Kingsoft Writer. In LibO 4.1.6, it displays as Times New Roman and when you select it, it changes to Arial and wont change back no matter where else you click. In LibO 4.2.4 and 4.3 beta 2, it acts like 4.1.6, but if you click on other cells, it will eventually jump back to Times New Roman, as the reporter reported. I'm classifying this as a regression. @jmadero: @meeks: please correct me if i'm wrong.
fa884dc86639e1925692df2117e53599726e366d is the first bad commit commit fa884dc86639e1925692df2117e53599726e366d Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com> Date: Thu Oct 17 00:09:03 2013 +0000 source-hash-86fd1240bbbb8ee72899abc24daf5e4402a61add commit 86fd1240bbbb8ee72899abc24daf5e4402a61add Author: Rene Engelhard <rene@debian.org> AuthorDate: Tue Apr 16 00:39:25 2013 +0200 Commit: Rene Engelhard <rene@debian.org> CommitDate: Tue Apr 16 00:43:48 2013 +0200 no comma after gid_<whatever>_ALL as otherwise the next entry is ignored Change-Id: If0e86e5d9740bd6dde3343c8fb468384b7367e27 :100644 100644 b4ae4276966dd04a235f93e06811bbaf85f069d6 98e7786a1b712b665b0f11491562c3ca45143133 M ccache.log :100644 100644 72a68e85f3ec4874df57f44e4c59176b35568fe1 12ddcdfda9bd62a4b1915ba9d9a9a4635ae4f6f5 M commitmsg :100644 100644 7d8918ebdd196b2d41f17e988111aa6f3e0ef7cb 89d3828788d24b0deae5be6ac0783b7f48d2b363 M dev-install.log :100644 100644 0ccc5c466da2571a608f6af2df3e738e980704af 6c2625072bf52db290b346d0583c6f1b54ff6ff5 M make.log :040000 040000 2877f1f554a288b090ef603a1e3227c8a0cb8229 292842af34bcdc94cc2da8f90ce6888d2be60bfa M opt # bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e # good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932 git bisect start 'latest' 'oldest' # bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574 # good: [8f4aeaad2f65d656328a451154142bb82efa4327] source-hash-1885266f274575327cdeee9852945a3e91f32f15 git bisect good 8f4aeaad2f65d656328a451154142bb82efa4327 # good: [9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02] source-hash-8600bc24bbc9029e92bea6102bff2921bc10b33e git bisect good 9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02 # good: [8ad82bc1416a07501651e8d96fe268e47d3931d3] source-hash-13821254f88d2c5488fba9fe6393dcf4ae810db4 git bisect good 8ad82bc1416a07501651e8d96fe268e47d3931d3 # bad: [d084d250b04446535ca1d7c29cf2062e6bd042b3] source-hash-688f72e3a2c3ef923389bbd21f6aea3afe1114db git bisect bad d084d250b04446535ca1d7c29cf2062e6bd042b3 # bad: [013adf05b6bf8e5d44a4e820d43177d7fb749079] source-hash-a16a4006e40bdb2cb4671846295fe2bf5a856e68 git bisect bad 013adf05b6bf8e5d44a4e820d43177d7fb749079 # good: [ff4b17247dc05a006a5c4c57dced132c87f2396c] source-hash-d74ba0c4147f33abd9d0c03883cc88f15e160ee5 git bisect good ff4b17247dc05a006a5c4c57dced132c87f2396c # bad: [0e1044821fb18012f74e2c8fd79abba13944ac9d] source-hash-11b851d2f2f8ee6230b8c732d5b157e472c21be2 git bisect bad 0e1044821fb18012f74e2c8fd79abba13944ac9d # bad: [4c57c51cf101def05bdde024fdc877a08ffd01ca] source-hash-e75ddb91c3d52ea9e6939325118cf906d971c41e git bisect bad 4c57c51cf101def05bdde024fdc877a08ffd01ca # bad: [fa884dc86639e1925692df2117e53599726e366d] source-hash-86fd1240bbbb8ee72899abc24daf5e4402a61add git bisect bad fa884dc86639e1925692df2117e53599726e366d # first bad commit: [fa884dc86639e1925692df2117e53599726e366d] source-hash-86fd1240bbbb8ee72899abc24daf5e4402a61add
This is still an issue in 4.3.0.4.
Reproducible with 4.3.3.1 Build ID: 7d55112667c8fcddb67bc3803796b46c93aa56b0 Windows 7 X64 mark OS as ALL.
*** This bug has been marked as a duplicate of bug 71797 ***
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]