topic Re: Saving Quantity Lists from AC to Excel in Collaboration with other software

Saving Quantity Lists from AC to Excel

Anonymous — Wed, 20 Jul 2016 10:02:23 GMT

Hi guys!

I'm experiencing a rather irritating and possibly very stupid problem.
When I export a simple schedule of zone areas into XLSX format it saves ok.
When opened in Excel though every number that is not whole ("23,56" for example) is changed to only "23".

Any ideas?
Am I explaining it clear enough?

Thanks a lot!

Re: Saving Quantity Lists from AC to Excel

Laszlo Nagy — Wed, 20 Jul 2016 15:08:20 GMT

Can you format those cells in Excel to display them as Number with 2 decimal places? Maybe by default it displays them to zero decimal places.

When you select any cell you can see its value in the Formula Bar located under the Ribbon. That shows its true value. What you see displayed in the cells are a matter of cell formatting.

Re: Saving Quantity Lists from AC to Excel

Anonymous — Wed, 20 Jul 2016 20:51:28 GMT

The cells' formatting is correct - with two decimals after the coma.

I've just tried doing the same operation from my laptop at home and here everything is fine.
I'll consider this a bug in my workstation in the office.

Thanks you anyway!

Re: Saving Quantity Lists from AC to Excel

Laszlo Nagy — Thu, 21 Jul 2016 14:45:16 GMT

Could it be something that is different in your operating system settings? The way numbers are set to be formatted maybe?

Re: Saving Quantity Lists from AC to Excel

Barry Kelly — Sun, 24 Jul 2016 03:09:33 GMT

It seems someone else was just having the same problem.

http://archicad-talk.graphisoft.com/viewtopic.php?t=53250

Are you using version 19 as well?
Check you have the latest update installed.

Barry.