topic Re: Numbers format in schedule cell in Collaboration with other software

Numbers format in schedule cell

Anonymous — Wed, 21 Dec 2016 18:29:11 GMT

is there a way to change the format for numbers in cell?
for instance, adding a point as thousands marker.

Re: Numbers format in schedule cell

alemanda — Wed, 21 Dec 2016 20:48:15 GMT

I think it depends on the international settings in you operating system.

Re: Numbers format in schedule cell

Anonymous — Thu, 22 Dec 2016 17:01:10 GMT

alemanda wrote:
I think it depends on the international settings in you operating system.

Already checked, Archicad doesn't take the format from them.

Re: Numbers format in schedule cell

Eduardo Rolon — Thu, 22 Dec 2016 21:59:35 GMT

FYI, in MacOS X it does.
Don't know about Windows.

Re: Numbers format in schedule cell

Anonymous — Sat, 24 Dec 2016 00:31:05 GMT

ejrolon wrote:
FYI, in MacOS X it does.
Don't know about Windows.

I'm using Mac OS X and it isn't getting the format from the international settings. Anyway it should be editable my settings are not necessarily the way the client is asking for their schedules

Re: Numbers format in schedule cell

Eduardo Rolon — Sat, 24 Dec 2016 01:23:57 GMT

Sadly it cannot be controlled separately.
Under Preferences ->Language and Region->Advanced->…
Restart Archicad for changes to take effect
There you can add any item as a thousands separator provided though AC might just recognize the basic ones (, . ')

Re: Numbers format in schedule cell

Eduardo Rolon — Sat, 24 Dec 2016 01:25:39 GMT

ejrolon wrote:
Sadly it cannot be controlled separately.
Under Preferences ->Language and Region->Advanced->…
Restart Archicad for changes to take effect
There you can add any item as a thousands separator provided though AC might just recognize the basic ones (, . ')

Re: Numbers format in schedule cell

Eduardo Rolon — Sat, 24 Dec 2016 01:26:38 GMT

and in AC.
FYI, this is where I change my short date to match 20XX-XX-XX

Re: Numbers format in schedule cell

Anonymous — Sat, 24 Dec 2016 05:04:20 GMT

Eduardo, thanks for the tip, but my setting was already the way i needed to be, the problem is AC not getting them.
I´m using the standard "cost" parameter from basic AC library parts, when i try to write the cost of a product using the point AC deletes it automatically.

When it comes to other numeric parameter like Area, it works perfectly with the thousand mark.

Re: Numbers format in schedule cell

Anonymous — Sat, 24 Dec 2016 05:17:12 GMT

This is another schedule using area from zones

Re: Numbers format in schedule cell

Eduardo Rolon — Sat, 24 Dec 2016 13:13:51 GMT

You are correct.
Element Schedule does not use the formatting that Component or Surface Schedules do. This happens with Listing Items and with the New AC Properties when listing objects.
So it looks like a Bug and you should report it to your reseller.

Re: Numbers format in schedule cell

Anonymous — Sat, 24 Dec 2016 14:40:10 GMT

Mil gracias Eduardo!
Feliz navidad

Re: Numbers format in schedule cell

Eduardo Rolon — Sat, 24 Dec 2016 14:53:42 GMT

Por nada.
Felicidades también…