.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint
Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

View Complete Post

More Related Resource Links

Is it possible to define metadata at Office 2007/2010 when saving to the SharePoint 2010 library

I have succesfully saved Excel 2007 document  to the document library. I wonder if it is possible to define meta data with client? Otherwiser end-user need to anyway open the SharPoint library and add metadata information there.  Example metadata is like "category".   Kenny_I

Office 2010 can not integrate with Sharepoint Server 2010 document library, both RTM

Hi I have one standalone SharePoint Server 2010 and Office 2010 on Windows Server 2008 SP2. Both SharePoint and Office are RTM. When I create new document from the document library, it can open the Office Word.  When I save the document, Office gives me the local browser dialog other than remote sharepoint library. When I try to enter the sharepoint site url in the dialog, it tells me: path does not exist. On another machine, Windows 7, the Office 2010 RTM can open and save docs from/into the document library. There seems something wrong with the Office client. Maybe someone can tell me how to fix it. Thanks. Xiaofeng?????,?????@??/??/????+????+????+all the context of the issue Hope Helpful | http://www.leoworks.net

Migrate/Move Document Library from Sharepoint 2007 to Sharepoint 2010

Hi, I have a customer that is setting up a new SPS 2010 environment. They have a Sharepint 2007 environment with one document library containing only PDF files. They will not need any metadata on these documents, but would like it to be moved to the new SPS 2010 environment only to be used for history and free text search. Is there an easy way to accomplish this?   Regards Christian GrannesChristianLLoyd

Error saving Office 2010 files opened from SharePoint Server 2007


I have recently started testing Office 2010 and have found only 1 major issue - I cannot save any Office 2010 files opened from a SharePoint Server 2007 location.  Upon save I receive an error message saying "Upload Failed. This file wan not uploaded because the specified path was not found on the server." and the file is captured in the Microsoft Upload Center.  Using the Upload Center action 'Open Web Site' opens the site without problem; however, a all subsequent resolve actions fail.  Any ideas?


  * MS Windows Server 2003 R2
  * MS SQL Server 2008 R2
  *Office SharePoint Server 2007
  *MS Office 2010 Premium

Custom Properties in Office 2010 won't promote to a document library in MOSS 2007



My company has built out their intranet portal using MOSS 2007, I have been asked to create a document library using an Excel 2010 form as a content type and to promote custom properties to the library.  In the past using Office 2007 I have been able to create an excel form as an content type and promote custom properties as metadata in a library.  I have done this by creating named ranges for the cells that i want to be promoted, in custom properties i linked the field and named it the exact same name it is in the library.  When i upload the form using those custom properties the properties promote into the library, it's when i select new and use the content type that the properties some how get lost sending it to the server.  I also noticed that when i enter information in the fields that i set as custom properties that the field isn't updated in the document panel that is located at the top of the document.  Can some one please help me if I am doing something wrong or could it possibly be an integration issue with MOSS 2007 and Office 2010.

Unable to save Office 2007 document to SharePoint My Site Personal Documents document library


...also when Office documents are saved to document library they open as Read-only and cannot be saved back to the same document library.

This only happens in my production SharePoint 2007 environment from client XP and IE7 machine.  It does not happen in developement environment (which mirrors production) from client XP/IE7 machines.

Save works fine to SharePoint document libraries from client Win 7 and IE8 machines in both production and development environments.

This only happens when attempting to save to a My Site Personal Documents document library.  Any other document library this behavior does not exist from XP or Win 7 machine.

What settings controls ones ability to save to a personal My site document library.  What setting could be different between prod and dev installations?  It only happens

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Sharepoint 2007 Document Search and Highlight in Office 2007 and PDF


We will be implementing Document Search (DOC, DOCX, PDF, TIFF, PPT, PPTX, XLS, XLSX) for one of our customers. We were evaluating a few MOSS 2007 based solutions, and happened to visit your site.  What we intend to achieve are the following functionalities:


a.       User should be able to search through 1000s of documents which are in a Sharepoint Document Library

b.      The documents could be in English, International Languages.

c.       Each document is 70-100 pages, and therefore it is important that the Search Results show the relevant pages on which the Search Text appears (Get Highlighted) within each document . Clicking on the link will take the user to the right page.

d.      The additional requirement is Synonym search. So, I can search for

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

unable to delete a column from library in sharepoint 2007

Hi When deleting  any column in document library we are getting the below error Unable to validate data.   at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)    at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString) Also tried to hide/remove the search content place hoder in master page but nothing works. Removed our custom master page with default master page still no changes are being observed. Thanks & Regards. Prerna

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Microsoft Office Picture manager is not launched in sharepoint 2010 picture library

Hi ? I am stuck up with :? Microsoft Office Picture manager is not launched in sharepoint 2010 picture library The description is : ? All the photos are stored in a picture library in the root of the My Sites called User Photos.? They are then stored in a folder called Profile Pictures. Navigate to your profile home page, delete default.aspx and type in ‘/user photos/’? (for example   ? But When I tried the edit option : Open Picture in a Picture Editor The page is blank : Microsoft Office Picture manager is not launched. ? Kindly help , if any service or step is missing. http://sp2010/my/user photos/).? This will take you to the root and then navigate to the folder Profile Pictures.http://sp2010/my/user photos/)

Sharepoint Foundation 2010 problems with Office 2007 ActiveX controls

I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I'm getting the following message whenever I try to create a new document using the New button: " 'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button." On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I've also had the same problem with systems running XP. In terms of troubleshooting, other activeX related features seem to be working fine. I can open datasheet views, if I click on a document, it will open in the appropriate client. However, I have some libraries where the Word document template opens the document information panel and those will give thhe following message on open: "One or more ActiveX controls could not be displayed because either: 1)Your current security settings prohibit running ActiveX controls on thi page , or 2) You have blocked a publisher of one of the contols. As a result the page mi

Sharepoint 2010 integration with Office 2010, 2007,2003

hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator

Upload documents to Sharepoint 2010 Document library

Is there a way to upload documents to an SP 2010 document library with Custom Actions or Workflows?  I have a requirement of taking the contents of several directories (older data files) and uploading them to Sharepoint.  Not sure which actions actually perform this operation.  Any help most greatly appreciated.

How to save Office 2007 documents to SharePoint 2010 sites

Is it possible to save Office Word/Excel/Powerpoint 2007 to SharePoint sites directly from Office Clients? Following website helps with saving a Office 2010 document to SharePoint 2010, but how to do it with Office 2007? http://office.microsoft.com/en-gb/word-help/save-a-document-to-sharepoint-from-office-2010-HA010380214.aspx  Kenny_I

Why saving to SharePoint library fails from Office 2007 client?

I have test environment where I have successfully able to create Excel document with the client and publish it to the SharePoint 2010 sites. In the test environment I was using my personal Windows 7 workstations for Office 2007. When I repeat process in the customer environment, it fails. I'm using front-end Windows Server 2008 machine for Office 2007. I'm using admin account and machine is certaily in the domain. 1. Open Excel 2007 and modify it 2. Publish 3. Document Publish Server 4. Input http://intra I get error: This location cannot open with program Why the error? What do I miss? Is the Windows Server 2008 the problem?Kenny_I
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend