Issue 125619 - currency format cannot be set back to standard
Summary: currency format cannot be set back to standard
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-13 09:07 UTC by stbartelslg
Modified: 2014-09-14 10:40 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0
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 stbartelslg 2014-09-13 09:07:14 UTC 
Cell A1 has currency format.
Enter formula =A1*B1 in cell C1; thus C1 gets currency format.

You will never be able to set this format back to standard even if format of cell A1 is set back to standard. You can change the format to all other formats. When trying to set the format to standard the original currency format is again active.

The format is set back to standard in case of
* changing the formula
* close and open document (therefore no attachment is added)

Stefan Bartels
Comment 1 Oliver Brinzing 2014-09-14 07:03:27 UTC 
and the format is set back to standard in case of:

Sub Main
	ThisComponent.calculateAll()
End Sub

pressing F9 - ThisComponent.calculate() - will not help

btw: why not adding an entry for "calculateAll" to the menu?
Comment 2 mroe 2014-09-14 10:14:32 UTC 
(In reply to brinzing from comment #1)
> and the format is set back to standard in case of:
> 
> Sub Main
> 	ThisComponent.calculateAll()
> End Sub

It's the same as [Ctrl]+[Shift]+[F9] (= Recalculate hard)


> btw: why not adding an entry for "calculateAll" to the menu?

You can do it by yourself. In the most of cases users don't need to recalculate hard.

A change of formatting calls not a reformatting of dependent cells. (There is a special trigger missing.)
But a change of the value calls a recalculation (with a reformatting) of dependent cells.


BTW: There is always no 4.1.1 value for "Latest Confirmation on:". :-(
Comment 3 mroe 2014-09-14 10:40:25 UTC 
> It's the same as [Ctrl]+[Shift]+[F9] (= Recalculate hard)
> In the most of cases users don't need to recalculate hard.


Additional: If you set AutoCalculate to off, Recalculate ([F9]) does the same as Recalculate hard ([Ctrl]+[Shift]+[F9]).