#890 Currency symbol omit / user define

[OK Hoff]

Re: Sweet Home 3D 6.0 - on .csv export, especially currency indication not (easily) importing to spreadsheets.

It might help with the interchange (and otherwise) if there in addition to the predefined local currencies, also were a possiblity to:
1) remove the currency symbol altogether, and/or
2) use user-defined currency symbols such as the generic ¤ (¤)
Just a thought.
ok

[OK Hoff]

The currency symbol in brackets should be ¤ - i.e. html entity curren : currency, just in case the character did not display correctly.

[OK Hoff]

Just an elaboration of the cut/paste and .csv import/export, trick is importing this .csv.
1) the currency+number is not recognised as such, but imports as text,
2) decimal separator and thousands separator may not be the same - typically using EN version of SH3D and another national locale in spreadsheets.

No 1) I have not found an easy fix for, espeically with differnt currencies, unless a (quick) text-edit to either separate or remove currency denominator. (Percentages however, are recognised in all tested spreadsheets: gnumeric, libreoffice, excel.)

No 2) is proably only a problem for users with different languages and locales. And it is easily fixed, but could result in that not round numbers will import as text unless adjusted in the spreadsheet dialogue. In the example below, the third Aquarium W/D/H are not calculated in Excel import.

.csv / clipboard

Name    Width   Depth   Height  Model size (kB) Price   VAT %   VAT Price (VAT included)
Aquarium    60  30  35  22  SEK2,445.00 25% SEK611.25   SEK3,056.25
Aquarium    70.2    30.2    52  548 USD334.00   25% USD83.50    USD417.50
Aquarium    100 40  100 60  €245.00 20% €49.00  €294.00
Bucket  30  28  26.5    34  £4.00   20% £0.80   £4.80
Bathr tub water 170 75  35  21  NOK9,999.00 25% NOK2,499.75 NOK12,498.75

Import where 1) currency ends in same cell and 2) thousands and decimal separators are different in SH3D and spreadsheet (and number ends up as text or wrong value):

Name	Width	Depth	Height	Model size (kB)	Price	VAT %	VAT	Price (VAT included)
Aquarium	60	30	35	22	SEK2,445.00	25%	SEK611.25	SEK3,056.25
Aquarium	60	30	35	22	SEK2,445.00	25%	SEK611.25	SEK3,056.25
Aquarium	70.2	30.2	52	548	USD334.00	25%	USD83.50	USD417.50
Aquarium	100	40	100	60	€245.00	20%	€49.00	€294.00
Bucket	30	28	26.5	34	£4.00	20%	£0.80	£4.80
Bathtub	170	75	35	21	NOK9,999.00	25%	NOK2,499.75	NOK12,498.75

[OK Hoff]

A tiny additional suggestion if no currency sign/generic currency sign ever were to be implemented. As the above file shows it seems possible to use multiple currencies in one SH3D file. And SH3D behaves nicely. Of course, without calculating totals :-)

But to do this, one has to set the alternate currency in preferences (I think) before editing the furniture. And if I want to adjust the £ value for the bucket above, I must make sure the preference is also £, if not furniture price is changed both in price and currency.

Would it be more convenient to allow for setting the (alternative) currency in the Modify Furniture dialgue as well?

ok

PS - this may be a noticable issue only for non-euro countries, but in Scandinavia, the UK, Switzerland and around, the need for multiple currencies will occur at times.