Bug 87039

Summary:	EDITING existing instances may force same letter capitalisation on new cells content
Product:	LibreOffice	Reporter:	davidpbrown <openforum>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	minor
Priority:	medium	CC:	fdbugs, jbfaure, raal
Version:	unspecified	Keywords:	regression
Hardware:	All
OS:	All
Whiteboard:	bibisectRequest
i915 platform:		i915 features:

Description davidpbrown 2014-12-05 21:17:06 UTC

Confirming a cell's content, to be different to existing cells with the same content in the same column, will see Calc prefer the existing cell's format for capitalisation, overriding the user's input.. but not for certain words. Perhaps those exceptions are those words in the dictionary. This behaviour also seems to stop after any successful change and reverse of that change.

So, make two cells as "test" or "apple" and those are fine. Make two cells random new word e.g. "dfgdfgdgdfgdfg" and try to capitalise one character in that string that is not the last letter. The cells return to be both exactly the same capitalisation "dfgdfgdgdfgdfg".

If you capitalise the last letter in one, then that works and any future corrections are retained too.

Perhaps that non dictionary word is added to a helpful anticipation of typing list that unhelpful forces the capitalisation.

Comment 1 Jean-Baptiste Faure 2014-12-06 17:38:31 UTC

Please, describe step by step how to reproduce the problem.

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding.

Best regards. JBF

Comment 2 davidpbrown 2014-12-06 18:31:01 UTC

1. Make two cells in the same column equal to a random new word e.g. "dfgdfgdgdfgdfg" - a word not in the dictionary.

2. Try to capitalise any one character in that string, that is not the last letter. Confirm the change.

Result I see: The cells return to be both exactly the same capitalisation, instead of acknowledging the change the user was trying to make to one of them.

Comment 3 Jean-Baptiste Faure 2014-12-06 22:35:30 UTC

Not reproducible for me.
Please, which version are you using ?

Best regards. JBF

Comment 4 davidpbrown 2014-12-06 23:16:01 UTC

Version: 4.2.7.2
Build ID: 420m0(Build:2)

Comment 5 davidpbrown 2014-12-06 23:18:18 UTC

and Linux Mint 17, if that makes a difference.

Comment 6 raal 2014-12-07 12:35:17 UTC

I can not confirm with LO 4.3.3, linux. 

I can confirm with Version: 4.5.0.0.alpha0+
Build ID: a26222f5af55e8ffe9784dd411485d3c5c72e983
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-07_01:55:26

Setting as new.

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.