I have a custom list named “Employees' which has the
following columns.
- FirstName – Single line of text
- LastName – Single line of text
- FullName – Calculated Field
In this blog you will see how to get the calculated field
formula using SharePoint Object Model.
Formula for FullName
=[LastName]&","&[FirstName]
Code Snippet:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
namespace CalculatedField { class Program { static void Main(string[] args) { using (SPSite site
= new SPSite("http://shashankpc:2012/sites/test")) { using (SPWeb
web = site.OpenWeb()) { SPList list = web.Lists.TryGetList("Employees"); if (list != null) { SPFieldCalculated
calculatedField = list.Fields.GetFieldByInternalName("FullName")
as SPFieldCalculated; Console.WriteLine(calculatedField.Formula); Console.ReadLine(); } } } } } } |