Bug 116492 - Change of forma is lost when you leave the cell.
Summary: Change of forma is lost when you leave the cell.
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.2.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-19 12:08 UTC by Jacinto Canales de Caso
Modified: 2019-06-27 02:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc file to test (8.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-28 10:10 UTC, Jacinto Canales de Caso
Details
Result 1 (188.86 KB, image/jpeg)
2018-03-28 10:10 UTC, Jacinto Canales de Caso
Details
Result 2 (199.92 KB, image/jpeg)
2018-03-28 10:11 UTC, Jacinto Canales de Caso
Details
screenshot (80.99 KB, image/png)
2018-03-29 10:35 UTC, Xavier Van Wijmeersch
Details
second screenshot (114.47 KB, image/png)
2018-03-29 10:50 UTC, Xavier Van Wijmeersch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jacinto Canales de Caso 2018-03-19 12:08:29 UTC
Description:
For example, you are in the content of a cell and you change part of the text to be bold and other part of text to be cursive, when you do cursive a 2nd part you lost the changes done in the 1st part.

Steps to Reproduce:
1. Write a text in a cell
2. Select a word and bold
3. Select o different word and cursive

Actual Results:  
You get de second word in cursive, but lost the format of the first word in bold.

Expected Results:
You get first word in bold and second word in cursive.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36
Comment 1 raal 2018-03-19 18:29:49 UTC
I can not confirm with Version: 6.1.0.0.alpha0+
Build ID: cab04bc39b5164ea74216cd849c3af5f5b298f79
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 2 Jacques Guilleron 2018-03-20 09:15:46 UTC
Nor I with
LO 6.0.2.1 Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: CL
or
LO 6.1.0.0.alpha0+ Build ID: 0d1479cbd442c3ec3bdd20333c341ea24dcca21e
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-03-10_01:47:26
Locale: fr-FR (fr_FR); Calc: CL
Windows 10 only issue?
Comment 3 Buovjaga 2018-03-25 17:07:10 UTC
Not reproduced on Win 10.

Can you attach a file, where this always happens to you?

Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: fi-FI (fi_FI); Calc: group
Comment 4 Jacinto Canales de Caso 2018-03-27 15:41:32 UTC
1) Write a text in a cell of Calc.
2) Select a word of the text.
3) Bold such word.
    a) then the word appear bolded.
4) select other word 5 positions ahead.
5) Bold such word.
    b) Then the second word appear bolded but the first one has left to be bolded. We have lost the first word bolded.

And It happen if you do two formats in the same cell. When you do the second, you lost the format of the first word formated.
Comment 5 Buovjaga 2018-03-27 17:28:48 UTC
(In reply to Jacinto Canales de Caso from comment #4)
> 1) Write a text in a cell of Calc.
> 2) Select a word of the text.
> 3) Bold such word.
>     a) then the word appear bolded.
> 4) select other word 5 positions ahead.
> 5) Bold such word.
>     b) Then the second word appear bolded but the first one has left to be
> bolded. We have lost the first word bolded.
> 
> And It happen if you do two formats in the same cell. When you do the
> second, you lost the format of the first word formated.

No problem for me.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: f98040a273b14e8e3f4b7206d4e6c8b93dde262f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 27th 2018

Please copy and paste here the contents of your Help - About. This allows us to know more about your system.
Comment 6 Jacinto Canales de Caso 2018-03-27 17:55:47 UTC
Do you use the same version than me?
Comment 7 Buovjaga 2018-03-28 06:53:52 UTC
(In reply to Jacinto Canales de Caso from comment #6)
> Do you use the same version than me?

Yes, see comment 2 and comment 3 where two people used the same version on Windows without seeing the bug. And please do what I requested in comment 5.
Comment 8 Jacinto Canales de Caso 2018-03-28 07:03:01 UTC
The content of Help-About:

Versión: 6.0.2.1 (x64)
Id. de compilación: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: CL

https://hub.libreoffice.org/git-core/f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
Comment 9 Buovjaga 2018-03-28 07:07:53 UTC
Can you reproduce the problem in Safe mode? Help - Restart in safe mode and then Continue in safe mode.
Comment 10 Jacinto Canales de Caso 2018-03-28 10:10:04 UTC
Created attachment 140934 [details]
Calc file to test
Comment 11 Jacinto Canales de Caso 2018-03-28 10:10:30 UTC
Created attachment 140935 [details]
Result 1
Comment 12 Jacinto Canales de Caso 2018-03-28 10:11:02 UTC
Created attachment 140936 [details]
Result 2
Comment 13 Buovjaga 2018-03-28 10:54:47 UTC
(In reply to Buovjaga from comment #9)
> Can you reproduce the problem in Safe mode? Help - Restart in safe mode and
> then Continue in safe mode.

Please try it.
Comment 14 Jacinto Canales de Caso 2018-03-28 14:16:29 UTC
I did it, and it continue the same problem.

What about you, have you got to reproduce the same problem?
Comment 15 Buovjaga 2018-03-28 14:32:59 UTC
(In reply to Jacinto Canales de Caso from comment #14)
> I did it, and it continue the same problem.
> 
> What about you, have you got to reproduce the same problem?

Well, as you've seen I've tried it many, many times. Even your attached file works fine for me.
Comment 16 Jacinto Canales de Caso 2018-03-29 08:29:21 UTC
Well, I have try it again on other computer on the same file and it works properly. 

But the version of LibreOffice in this other computer is diferent. It is 5.1.6.2

So, I unistall my actual versión and re-install other older version.

I need this funcionality due to the fact that I need to mark in bold or other color words in a same cell.
Comment 17 Jacinto Canales de Caso 2018-03-29 10:06:06 UTC
That's pitty!!!

I have uninstall version 6.0.2.1 and I've installed version 5.4.6.2 and the problem continue.

So, there are 2 possibilities:

1) It is the Operating System: Windows 10 Home.
2) It is my keyboard or his configuration.

Can someone give me a clue what can I do?
Comment 18 Buovjaga 2018-03-29 10:33:49 UTC
Last clue might be to try with a daily master build: https://dev-builds.libreoffice.org/daily/master/Win-x86_64@42/current/
It installs separately.
Comment 19 Xavier Van Wijmeersch 2018-03-29 10:35:27 UTC
Created attachment 140948 [details]
screenshot

I have no windows so, but with no repro

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.4.1.2
Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 20 Xavier Van Wijmeersch 2018-03-29 10:50:09 UTC
Created attachment 140949 [details]
second screenshot

Even with different font in the same cell no repro

Version: 6.0.4.0.0+
Build ID: 6d142e8f0a3dfb609ccaf9dd8905a16ed5525c36
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 21 Xavier Van Wijmeersch 2018-03-29 10:50:41 UTC
Try to reset your user profile
Comment 22 Buovjaga 2018-03-29 11:00:21 UTC
(In reply to Xavier Van Wijmeersch from comment #21)
> Try to reset your user profile

He already tested in Safe mode, so no need.
Comment 23 Jacinto Canales de Caso 2018-04-02 21:31:23 UTC
I have made more discoveries about it. 

If you press any key, SHIFT, Ctrl or Alt, any format entered in the cell is lost. 

I thought it happened just with SHIFT key, but it happens the same pressing ctrl or Alt key.
Comment 24 Buovjaga 2018-04-03 12:03:56 UTC
(In reply to Jacinto Canales de Caso from comment #23)
> I have made more discoveries about it. 
> 
> If you press any key, SHIFT, Ctrl or Alt, any format entered in the cell is
> lost. 
> 
> I thought it happened just with SHIFT key, but it happens the same pressing
> ctrl or Alt key.

So just pressing them on their own? No problem here.
Comment 25 Jacinto Canales de Caso 2018-04-11 07:13:53 UTC
Yes, Just pushing some key like shift, ctrl, alt.

If you cursor are in the cell and push a key like shift, automatically every text formated is lost in that cell.
Comment 26 Xisco Faulí 2018-11-27 20:08:52 UTC
Hello Jacinto Canales de Caso,
A new major release of LibreOffice is available since this bug was reported.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 27 QA Administrators 2019-05-27 02:46:32 UTC Comment hidden (obsolete)
Comment 28 QA Administrators 2019-06-27 02:55:29 UTC
Dear Jacinto Canales de Caso,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp