Bug 87039 - EDITING existing instances may force same letter capitalisation on new cells content
Summary: EDITING existing instances may force same letter capitalisation on new cells ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: unspecified
Hardware: All All
: medium minor
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: bibisectRequest
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-12-05 21:17 UTC by davidpbrown
Modified: 2014-12-29 06:33 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


Attachments

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.