Issue 123843 - Cell formatting does not hold
Summary: Cell formatting does not hold
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.0.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-12 21:49 UTC by Rob
Modified: 2014-02-10 11:50 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.1
Developer Difficulty: ---

Attachments
Call A2 will have the word "Client: " on the first change, but not if changed again, unless there is a number. (18.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-12 21:49 UTC, Rob 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Rob 2013-12-12 21:49:02 UTC 
Created attachment 82086 [details]
Call A2 will have the word "Client: " on the first change, but not if changed again,  unless there is a number.

Menu:
Format -> Cells... -> User-defined

Format entered: "Client: "@

Typed into cell: 'Home Depot'
Expected Result: 'Client: Home Depot'
Actual Result on first try: 'Client: Home Depot'

Next typed into cell: 'Lowes'
Expected Result: 'Client: Lowes'
Actual Result on subsequent try: 'Lowes'

At this point if I type something with a number: '1Home Depot'
Expected Result: 'Client: 1Home Depot'
Actual Result: 'Client: 1Home Depot'

As long as there is a number somewhere in it, it will work, but just text will no longer have 'Client: ' in front any more, unless I reload the file.
Comment 1 Edwin Sharp 2013-12-13 08:40:06 UTC 
Problem when word underlined by spell checker.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7
Comment 2 Rob 2013-12-13 12:43:40 UTC 
Thanks Edwin, I just figured that out this morning and was going to add the comment, any idea if there is going to be a fix? Other then turning off spell checker?
Comment 3 Edwin Sharp 2013-12-13 13:25:56 UTC 
I've hopefully added target milestone 4.1.0.
Comment 4 Rob 2013-12-13 13:59:20 UTC 
Got it, I see how this forum works now, Thanks for the quick replies!
Comment 5 Oliver-Rainer Wittmann 2014-02-10 11:50:48 UTC 
Reverting field Target Milestone has this should set, if we are more or less sure that it is/will be fixed in the given version.

If you think that this issue should be fixed in the next release, please raise it on the dev-list. Then it could be marked as a 'show-stopper'