Bug 108672 - Strange iteration between spellcheck and conditional cell format
Summary: Strange iteration between spellcheck and conditional cell format
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-06-21 12:11 UTC by m_a_riosv
Modified: 2017-06-23 10:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Test file (52.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-06-21 12:11 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2017-06-21 12:11:27 UTC 
Description:
On the attached file, with automatic spellcheck enable, cell B5 shows the date number, with it disable show the date.

Steps to Reproduce:
1.Open attached file
2.Enable disable spellcheck.[Shift+F7]
3.Cell B5 change the format between number and date.

Actual Results:  
Automatic spellcheck affects cell format.

Expected Results:
Automatic spellcheck doesn't affect cell format.


Reproducible: Always

User Profile Reset: No

Additional Info:
Verifiably since 5.1 because before conditional format behaves different. 


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 m_a_riosv 2017-06-21 12:11:50 UTC 
Created attachment 134187 [details]
Test file
Comment 2 Jacques Guilleron 2017-06-21 14:32:22 UTC 
Hello Miguel,

Selecting and applying again the Tohoma font on B5 makes the issue vanish.
Does it work for you too?
No explanation however.
Comment 3 m_a_riosv 2017-06-21 21:02:40 UTC 
Hi Jacques,
correct, but I think we can agree that something strange is happening when spellcheck interfere the cell format, and is corrected applying a font to the cell.
Comment 4 Jacques Guilleron 2017-06-23 09:11:54 UTC 
Hi Miguel,

I don't reproduce with
LO 5.5.0.0.alpha0+ Build ID: 0e6297932252403883a6057feee488e4ee2bc360
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-05-23_00:14:17
Locale: en-US (fr_FR); Calc: CL
nor with
LO 6.0.0.0.alpha0+ Build ID: 9e4502f0e393d2bc2810488b3ebb0a5c23038436
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-06-16_08:52:00
Locale: fr-FR (fr_FR); Calc: CL
Comment 5 m_a_riosv 2017-06-23 10:33:35 UTC 
I can reproduce with
Version: 5.4.0.0.beta2 (x64)
Build ID: 3cc1cdd8ee50f144e5514da51800a08119754d8f
CPU threads: 4; OS: Windows 6.19; UI render: default; 
Locale: es-ES (es_ES); Calc: group

but not with
Version: 6.0.0.0.alpha0+
Build ID: 438c0ed5ea4116e93eb2167a53a740ba5097565f
CPU threads: 4; OS: Windows 6.19; UI render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-06-22_11:26:54
Locale: es-ES (es_ES); Calc: group

Closed as works for me, for now, but I'll test when we have released versions because they are not the same than dailies.