Issue 126822 - Cannot convert cell formatting to Number for cell range containing combination of formats
Summary: Cannot convert cell formatting to Number for cell range containing combinatio...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-04 00:58 UTC by richardbaxter
Modified: 2016-02-05 19:39 UTC (History)
1 user (show)

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

Attachments
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 richardbaxter 2016-02-04 00:58:50 UTC 
It is not clear how to convert the cell formatting to Number for a cell range containing a combination of formats (e.g. Number and Currency).

When selecting a range of cells of mixed formats, and then Format - Cells, it would be expected to see the category as something like "Mixed"; such that the user a) knows that the formatting is mixed, and b) can change the formatting of the cells to "Number".

Currently, the only way to change the formatting of a mixed selection of cells (e.g. containing a combination of empty Number and Currency cells) to Number is to temporarily change the cells to another format (e.g. Scientific), then change them back to the Number format.