Bug 79314 - FORMATTING: Fonts changing when cell is clicked
Summary: FORMATTING: Fonts changing when cell is clicked
Status: RESOLVED DUPLICATE of bug 71797
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: bibisected, regression
Depends on:
Reported: 2014-05-27 14:25 UTC by Adam Niedling
Modified: 2015-12-17 08:18 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:

Example spreadsheet (12.50 KB, application/vnd.ms-excel)
2014-05-27 14:25 UTC, Adam Niedling
Video recording of the problem (361.00 KB, video/ogg)
2014-05-27 14:26 UTC, Adam Niedling

Note You need to log in before you can comment on or make changes to this bug.
Description Adam Niedling 2014-05-27 14:25:39 UTC
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: release
Comment 1 Adam Niedling 2014-05-27 14:26:44 UTC
Created attachment 99949 [details]
Video recording of the problem
Comment 2 sophie 2014-06-05 14:30:33 UTC
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
Comment 3 Adam Niedling 2014-06-06 08:00:51 UTC
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.
Comment 4 Yousuf Philips (jay) (retired) 2014-06-08 14:20:52 UTC
(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.
Comment 5 Joel Madero 2014-07-26 21:11:07 UTC
 fa884dc86639e1925692df2117e53599726e366d is the first bad commit
commit fa884dc86639e1925692df2117e53599726e366d
Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com>
Date:   Thu Oct 17 00:09:03 2013 +0000

    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
Comment 6 Adam Niedling 2014-08-06 08:29:21 UTC
This is still an issue in
Comment 7 Kevin Suo 2014-10-23 02:31:25 UTC
Reproducible with
Build ID: 7d55112667c8fcddb67bc3803796b46c93aa56b0
Windows 7 X64

mark OS as ALL.
Comment 8 Matthew Francis 2015-01-14 16:11:43 UTC

*** This bug has been marked as a duplicate of bug 71797 ***
Comment 9 Robinson Tryon (qubit) 2015-12-17 08:18:28 UTC
Migrating Whiteboard tags to Keywords: (bibisected)