Tugsol
asked on
SharePoint Create List Item Removes .00 Decimals
Hi,
I have created a Doc Library in SPD 2010 and created a Document Content type which I have then editied the template for so I can push the fields through using Words Document Properties Quick Parts.
I have then created an Approval Workflow which, when Approved, creates a document in the Doc Library and sets the Doc Properties in the doc to the same as the form fields.
Some of the fields are used to hold financial figures. Most of these have been set as a Currency field with 2 decimal points but one of them has been set as a Single Line of Text field - as it's held within a Repaeting Table.
If I set the figues as (for example) 100.26 it pushes this through to the Word doc fine. If I set it as 100.00 it will be displayed in Word as just 100.
I'm guessing this must be some kind of AutoCorrect when creating the Doc and setting the field but I can't figure out how to change this.
Any ideas?
Thanks!
I have created a Doc Library in SPD 2010 and created a Document Content type which I have then editied the template for so I can push the fields through using Words Document Properties Quick Parts.
I have then created an Approval Workflow which, when Approved, creates a document in the Doc Library and sets the Doc Properties in the doc to the same as the form fields.
Some of the fields are used to hold financial figures. Most of these have been set as a Currency field with 2 decimal points but one of them has been set as a Single Line of Text field - as it's held within a Repaeting Table.
If I set the figues as (for example) 100.26 it pushes this through to the Word doc fine. If I set it as 100.00 it will be displayed in Word as just 100.
I'm guessing this must be some kind of AutoCorrect when creating the Doc and setting the field but I can't figure out how to change this.
Any ideas?
Thanks!
livanescu
check how it's stored in sharepoint... maybe word is being smart, reformatting on its' own...
ASKER
Hi livanescu,
When you say "check how it's stored in sharepoint" I'll take it you mean on the Library it's creating the Document in?
In the Library it looks to be grand. I've tried playing around with the List Columns and changing them from Currency to Single/Multiple Lines of Text and on the Library the figures appear fine and have the .00 at the end of the figures.
When I open the Word doc though it has dropped the .00 off the figures. I can manually type these in in Word and they stay so I don't think it's an AutoCorrect option in word.
Is there something I could maybe set or change in the Doc Template to prevent this from happening?
I thought it could be to do with the SharePoint server default for decimals (which is Auto) when it writes the fields to the doc. To test this theory any idea where I can change the server default for decimals - top level site/Central Admin etc?
Thanks
When you say "check how it's stored in sharepoint" I'll take it you mean on the Library it's creating the Document in?
In the Library it looks to be grand. I've tried playing around with the List Columns and changing them from Currency to Single/Multiple Lines of Text and on the Library the figures appear fine and have the .00 at the end of the figures.
When I open the Word doc though it has dropped the .00 off the figures. I can manually type these in in Word and they stay so I don't think it's an AutoCorrect option in word.
Is there something I could maybe set or change in the Doc Template to prevent this from happening?
I thought it could be to do with the SharePoint server default for decimals (which is Auto) when it writes the fields to the doc. To test this theory any idea where I can change the server default for decimals - top level site/Central Admin etc?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Answered my question.