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

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

Calculated Columns in a Form Library receive error: Value does not fall within the expected range.

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

I have a forms library that posts the date the form was created. We would like to create a calculated column that allows us to look at these forms based on the month and year they were created. I had created a calculated column that extracts the month and replaces the number with a text string by using an if statement; "IF(MONTH([Proposal Date])=1,"January","") It goes on to evaluate each month and replace the number with the text string. This formula worked for quite some time, though now when I try to add any calculated columns or edit any existing calculated columns on this form library I receive the following error: Value does not fall within the expected range. Now my existing calculated columns (like the one above) do not work and I can not create new calcualted columns. Any insight would be awesome as this has been plaguing me for a couple of months now.

View Complete Post

More Related Resource Links

Projects giving the error "Value does not fall within the expected range."


I have a solution that contains four projects. This morning, when I opened up the solution in SQL Server Management Studio 2008, three of the projects gave the error "Value does not fall within the expected range" and were marked as unavailable. I removed them from the solution. When I attempt to add them back to the solution, nothing happens. How do I fix this?


AddPermissionCollection returns error: Value does not fall within the expected range



I'm trying to add permissions to a new subsite by getting the permissions from an existing one using the following method from the _vti_bin/Permissions.asmx webservice:

    XmlNode xnode = spPermissionsWS.GetPermissionCollection("http://SharePointServer/MyNewSite", "Web");

    spPermissionsWS.AddPermissionCollection(http://SharePointServer/MyNewSite, "Web", xno

Dim CalendarList As SPList = Web.Lists(NameOfList) error: value does not fall within expected range



The following line  is throwing error message " value does not fall within expected range "

Using Site As New SPSite(SitePath)

   Using Web As SPWeb = Site.OpenWeb()

    Dim CalendarList As SPList = Web.Lists(NameOfList) ''''''''' throws error

tha value of NameOfList is 'Project%20Calander'

the url of the list is 'http://dev/working/landing/testsite/Lists/Project%20Calendar/calendar_copy(1).aspx'

Its the correct name of the list so not sure what as it could be expecting?


Infopath form and forms library error

I've created an InfoPath 2010 form and associated it with a forms library on a SharePoint site. When I go to the library and choose "Add document" the form opens up to be filled out by the user. When the form is filled out, and the user tries to submit, they get an error saying that I need to configure SharePoint to allow cross-domain data access for user form templates that use connection settings in a data connection file and store a UDC file in the same site collection as the form. So I've enabled cross-domain data access and I've already created a Data Collection Library for Forms in the Site that is approved. What am I missing?  Why am I still getting the error?  

Value does not fall within the expected range.

I am trying to upload a csv file into a sharepoint list. (as demonstrated in SDK sample that i downloaded from here http://www.microsoft.com/click/SharePointDeveloper/html/Default.html)                 //open the CSV file for reading using (StreamReader fileRdr = File.OpenText(paramFileName)) { // connect to the site collection using (SPSite spSite = new SPSite(paramWeb)) { //open the web using (SPWeb spWeb = spSite.OpenWeb()) { //get the List from the site SPList spList = spWeb.Lists[paramList]; //read the files in the header string line = fileRdr.ReadLine(); string[] fieldNames = line.Split(splitArray); //get an Array of field from the List - this assumes that the fields name match // we need the field id when inseting rows SPField[] spFields = new SPField[fieldNames.Length]; for (int looper = 0; looper < fieldNames.Length; looper++) { string strName = fieldNames[looper];

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

windows form control library error in asp.net

Can some tell me what is this problem?my windows form control library have the drag and drop.when i open in web, the below error pop out.

Cannot access Workflow from List Item menu: "Value does not fall within the expected range."


We are using Sharepoint 2007 sp2.

I am using Sharepoint Designer 2007 to create workflow for some List, suddenly I cannot acess some list items' workflow,and was informed  "Value does not fall within the expected range." , but other items are all ok.

I don't know whether this is concerned with the service pack 2, I installed sp2 yesterday.

Altering in-document form layout for Document Library Columns



My users need to add metadata to documents they check out of a Document Library while they are in the document. That works fine (the forms appear at the top of the Word Document, underneath the task bar). However, the layout of the forms is kind of bad. Is there a way to redesign the forms in the top of a word document so that they look better?



"This feature installing a form template does not match the expected format" error


I'm trying to create a new SP Feature that consists of the following components -- an InfoPath form, a document library (list) where these forms will be used, and a custom Task list (that will be used in a workflow that is triggered when the form is submitted).  Each of these components was created in a DEV env and is working.  I then created my feature in Visual Studio 2008 and successfully created the WSP file.  I then (successfully) installed the WSP (I got no errors on install and all seemed well -- the "solution" shows up under Central Admin and shows as being deployed. 

When I go to site settings, the feature shows up, but deactivated.  WHen I attempt to activate it, however, I get this error in the SP Logs:

09/24/2010 09:38:19.12  OWSTIMER.EXE (0x07C4)                    0x07F0 Forms Server                   Forms Services Deployment      

82mz Exception FeatureInstalled failed with unhandled exception Microsoft.Office.InfoPath.Server.Util.InfoPathLocalizedException: This feature installing a form template does not match the expected format: CAPital EXpenditure Request. Refer to the

Getting error msg while trying to upload a document inot the document library using the form which i


I have designed an upload form with the columns that have to be filled in while uploading a document into the document library.The form is designed in .net.

I get "Error Access Denied" message when i try to upload the document using that upload form.When i go back to site,the document is uploaded in that particular document library.But this problem doesnot exist when i upload the document as admin.There is no " Error Access Denied" message.I have checked the document library permissions.The problem is not with the permission to that particular document library.

Can someone help me out in this issue?

Value does not fall within the expected range? Using Internal Field Name returned from SPListItem Fi

Here's the code.

myDocument is an SPListItem.
string fieldName = "Document Category";
string internalFieldName = myDocument.Fields[fieldName].InternalName.ToString();
Type myType = myDocument[internalFieldName].GetType();
internalFieldName gets the value "Document_x0020_Category"

But myType = myDocument[internalFieldName].GetType() throws an exception error of "Value does not fall within the expected range"??

If the fieldname is found in the fields collection, and returns the internal field name, why would using the internal field name as an indexer into the document throw an exception?

myDocument has a value in field "Document Category" when I view properties on the document in the document library! I am expecting the field type to be of

SharePoint Form Authentication site showing Error for few actions in Picture library.


I have extended my web application (with zone Extranet) and enabled Form Authentication, Enabled Client Integration and SSL.

My problem is: In my picture Library 

     1. Actions - Download/Send to actions are not working, getting error message: "Picture Manager is unable to open   pictures over the internet that are not from a windows SharePoint Services picture Library. Please specify a valid picture library and try again".

    2. Actions - Open with Windows explorer getting the error message:"Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server".

   3. In the Explorer view i am getting : "Please wait while Explorer View is loaded. If Explorer View does not appear, your browser may not support it".

But when I open the same library and do the above actions in default zone (port 80), it is working perfectly.

I have SharePoint service pack 1 and infr

Document CopyTo() Failed with "Value does not fall within the expected range"


Hi there,

I have a very strange issue...when I want to copy document file from document library A to another B (in C# code - document.CopyTo(destinationUrl)) I get an error "Value does not fall within the expected range".

But when I want to copy document file backwards from B to A with the same code, it works!

So I made a test with SharePoint feature "Send To"...I select file in doc lib A and choose option Send To -> Other Location...here I selected doc lib B and click OK to copy the file, but the operation also failed with the error "Unable to contact the source server." if I make backwards operation (from B to A) it's works again!

Am I missing something or what? Both Document libraries are the same...I don't know where the problem is :\

Thanks for help!

Filter Form Library View using promoted columns from InfoPath

I have a form that requires two levels of approval. This is published to a form library on SharePoint 2007. I only want users to see their own forms as there are monetary values involved. I can achieve this using the view filter “Created by” & “Modified by” = [Me], however the line approvers can only see the forms after they have interacted with them. Once the next person in the workflow edits, they cannot see the form.

I have tried using columns I promoted where I have stored the username of the approvers and using the [Me] filter, I get a “Filter value is not a valid text string”. I created two more calculated columns in SharePoint making them equal to my InfoPath fields, and I still get the same error.

Can anyone tell me how I can set a filter so that these line managers can at all times see any forms that have required their approval?

Many thanks in advance.

InfoPath Form Error on SharePoint Form Library


Hi All,

When I try to reopen an InfoPath 2007 form from the SharePoint site (InfoPath Form Deployed on SharePoint Form Library), I got the following error message:

" The form cannot be filled out because you do not have adequate permissions, another user has the form open, or the form is open in another program. Do you want to open a read-only copy of the form? "
Any idea to solve this problem ?
With Best Regards,
Muhammad Tariq Khan.

Passing Calculated Columns from Sharepoint into Word Document Library Template


Hi all...

Another noob question.  I have been able to figure out how to pass single line text, date, etc. data from a Sharepoint List into a Word Template, but I am still trying to figure out how to pass a calculated column.  Is there a workaround?


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