Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
We need to bring an area schedule into a spreadsheet so the client can
play with numbers however, the total are exported as a number and not a
formula.
This means we need to sum the values on the spreadsheet to calculate the
total areas again.
The other thing is that we cannont sum values with decimal figures. Only
whole numbers, otherwise the spreadsheet won't calculate. We've checked
the regional settings, but with no success.
We need to bring an area schedule into a spreadsheet so the client can
play with numbers however, the total are exported as a number and not a
formula.
This means we need to sum the values on the spreadsheet to calculate the
total areas again.
The other thing is that we cannont sum values with decimal figures. Only
whole numbers, otherwise the spreadsheet won't calculate. We've checked
the regional settings, but with no success.
Yes, I know. the thing is that the spreadsheet won't calculate number
with decimal places exported from rvt. Only whole numbers.
Em 16-03-2010 14:27, waltermullett9350 escreveu:
> You can set the number of places to show in your schedule so in your case - 0
>
> Just change the settings for that field not to use the project settings.
>
> Edited by: waltermullett9350 on Mar 16, 2010 2:26 PM
Yes, I know. the thing is that the spreadsheet won't calculate number
with decimal places exported from rvt. Only whole numbers.
Em 16-03-2010 14:27, waltermullett9350 escreveu:
> You can set the number of places to show in your schedule so in your case - 0
>
> Just change the settings for that field not to use the project settings.
>
> Edited by: waltermullett9350 on Mar 16, 2010 2:26 PM
It works - I just did it. And BTW, decimal places also work.
Are you sure you are exporting numbers? Don't let Revit put in something like SF because the field then becomes text when exported and then it will not add in excel.
It works - I just did it. And BTW, decimal places also work.
Are you sure you are exporting numbers? Don't let Revit put in something like SF because the field then becomes text when exported and then it will not add in excel.
