Bug 50684 - UI: Currency-fields in forms should get additional FORMATTING fields for Color, conditional formatting
Summary: UI: Currency-fields in forms should get additional FORMATTING fields for Colo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 3.3.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-04 08:04 UTC by robert
Modified: 2015-01-03 17:38 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Currency value in formated fields (negative: red) and currency fields (2.89 KB, image/png)
2012-06-04 08:04 UTC, robert 		Details
Database with one form with a formatted field and a special currency field (11.75 KB, application/vnd.sun.xml.base)
2012-09-02 15:46 UTC, robert 		Details
View All

Description robert 2012-06-04 08:04:01 UTC 
Created attachment 62517 [details]
Currency value in formated fields (negative: red) and currency fields

With currency-fields in forms you can only show the values in black color. It doesn't change when reaching negative values. This behaviour could not be changed in the properties from the field.
If you use the formated-field you could show negative values like negative currency-values in Calc.
Comment 1 Jochen 2012-08-28 18:49:54 UTC 
@Robert,

1) bug or enhancement?

2) which LO-version?
Comment 2 robert 2012-09-02 15:45:38 UTC 
@Jochen

Could it be an enhancement, when it works with one controlfield, but not with the controlfield which is special made for this datatype? I think it's a bug.

I have set the version to 3.3.4 The bug does exist since the beginning of LO.
Comment 3 robert 2012-09-02 15:46:51 UTC 
Created attachment 66494 [details]
Database with one form with a formatted field and a special currency field
Comment 4 Jochen 2012-09-02 16:02:45 UTC 
I can confirm your observation.
Bug or enhancement -> difficult question.
More likely a bug respectively the bug is the absence of a formatting field for "currency fields" as available for the "formatted fields".

Changed status to "NEW".
Comment 5 Rainer Bielefeld Retired 2012-09-02 17:27:59 UTC 
[Reproducible] with parallel installation of Master "LOdev  3.7.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: 9bb30a4]"  {tinderbox: 2008R2@20, pull time 2012-08-30 23:44:35} on German WIN7 Home Premium (64bit)

I have no knowledge there, I did not find any formatting possibility for Currency field except Currency symbol, Min/Max and number of decimals. 
Where can such a setting be expected  to get negatives red"? For the "Formatted Field" that's explicitly selected in the properties, for the currency field I can't find such a property. 

With current knowledge I see this one as enhancement request for more Currency field formatting properties (also may be thousands separator, ...)
Comment 6 robert 2012-09-02 17:58:45 UTC 
@Rainer,

the thousands-separator could be choosen in the properties of the field. You have to scroll a little bit down ... 
The changing of color between negative and positive/zero couldn't be choosen.

I think the bug could be solved very easy: Put away the currency-field. The formatted field allows all the formatting we could need. I do not know why there is another field special for currency.
Comment 7 Rainer Bielefeld Retired 2012-09-02 20:25:24 UTC 
> why there is another field special for currency.

Yes, that exactly is the exciting question, may be currency fields have a special function in particular database applications? I can't tell whether this kind of fields only is historical ballast or additionally has a special sense.
Comment 8 robert 2012-09-03 14:44:30 UTC 
(In reply to comment #7)
> > why there is another field special for currency.
> 
> Yes, that exactly is the exciting question, may be currency fields have a
> special function in particular database applications? I can't tell whether this
> kind of fields only is historical ballast or additionally has a special sense.

Databases don't save data as "currency". There are number-fields where you choose, how many decimal places you will get. The formatting with currencies is a question of GUI, not of the database.
Comment 9 Rainer Bielefeld Retired 2012-09-03 17:08:27 UTC 
> Databases don't save data as "currency". 

I don't know enough, may be there are exotic Databases saving currency for what this field might be required? Help does not help very much. So I believe a quick improvement can be an additional sentence in Help under More Controls - Currency Field like "It's recommended to use ????? instead of Currency Field because of the more advanced formatting features ..."

The field can not be dropped, we have to keep compatibility with existing .odb
Comment 10 Alex Thurgood 2015-01-03 17:38:51 UTC 
Adding self to CC if not already on

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.