Display: Cloud | List
Most Popular Tags
Results (46 total) All > format (x)
Range.NumberFormat PropertyExcel Developer ReferenceReturns or sets a Variant value that represents the format code for the object.Syntaxexpression.NumberFormatexpression   A variable that represents a Range object.RemarksThis property returns Null if all cells in the specified range don't have the same number format.The format code is the same string as the Format Codes option in the Format Cells
Last modified by Microsoft on 8/19/2009 11:30:06 PM
Tags:  2007  excel  format  range  vba
Solution to ArgumentNullException (Image.Save Method (Stream, ImageFormat) (System.Drawing))
It is true that ArgumentNullException always occurs when using this overload of Save method. Solution I found is to create System.Drawing.Bitmap from current Image instance and call its Save method instead of calling Image's Save method.
Last modified by Ondřej on 2/10/2012 12:30:18 PM
Get Indented Xml String (XmlNode.OuterXml Property (System.Xml))
static void Main(string[] args) { XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml("<book><page></page></book>"); // unindented xml using (MemoryStream ms = new MemoryStream()) { XmlWriterSettings xws = new XmlWriterSettings(); xws.Indent = true; using (Xm
Last modified by soyuz on 10/7/2011 7:00:27 PM
Tags:  format  indent  pretty  spaces  tab
more date options (CAST and CONVERT (Transact-SQL))
SELECT DATEADD([day], - 0, CONVERT(datetime, CONVERT(varchar, GETDATE(), 113))) as A,CONVERT(varchar, DATEADD([day], - 7, CONVERT(datetime, CONVERT(varchar, GETDATE(), 113))), 113) as B,UPPER(REPLACE(CONVERT(varchar, DATEADD([day], - 7, CONVERT(datetime, CONVERT(varchar, GETDATE(), 113))), 113),' ','-')) as C,STUFF(UPPER(REPLACE(CONVERT(varchar, DATEADD([day], - 7, CONVERT(datetime, CONVERT(varcha
Last modified by kookixxfun on 12/3/2010 12:54:14 AM
Tags:  cast()  convert()  datetime  format  time
SQL Server 2005 Books Online (November 2008)Formatting Numeric and Date Values in a ReportYou can specify a format for numeric and date values by updating the Format property of its text box with a formatting string. For example, you can set a text box for a numeric field to display the number as currency. Reporting Services uses Microsoft .NET Framework formatting strings or you can create a cust
Last modified by Microsoft on 12/16/2008 7:50:20 AM
Tags:  format  formatstring  tag
InfoPath SharePoint Integration (Lab 12: Using SharePoint Server Workflows with InfoPath 2007)
http://blog-sharepoint.blogspot.com/2009/07/integrate-infopath-form-with-sharepoint.html How to integrate InfoPath forms with workflow in SharePoint to give greater control over the functionality and user interface. http://blog-sharepoint.blogspot.com/2009/07/infopath-update-repeating-elementsnodes.html How to update repeating elements/nodes in a secondary data source by attribute.
Last modified by daniels99 on 1/6/2010 12:36:20 AM
InfoPath SharePoint Integration Tutorials and Resources (Lab 12: Using SharePoint Server Workflows with InfoPath 2007)
http://blog-sharepoint.blogspot.com/ SharePoint InfoPath Development http://blog-sharepoint.blogspot.com/2009/07/summary-how-to-programmatically-update.html Update existing SharePoint List item from an InfoPath from using a CAML query and secondary submit data connections. http://blog-sharepoint.blogspot.com/2009/07/infopath-caml-date-time-format-in-when.html InfoPath CAML D
Last modified by daniels99 on 1/6/2010 12:33:24 AM
Custom Formatting for Number (Custom Numeric Format Strings)
Hi I have double variable which contains value 908123456789I want to format it like this: (908) 123-4567Ext.89I am using following code: CDbl(ContactPhone).ToString("(###) ###-####'Ext'.####")But I get output like this:(9) 081 2345Ext.6789 Can help me in this????
Last modified by R Petrusha - MSFT on 1/6/2010 7:20:19 PM
Tags:  custom  format
doesn't work for multiple selections (Copy and reuse formatting)
2+ years later.....still broken 1. The feature to apply the formatting via the format painter to multiple selections by double-clicking does not work.It has been tested in EW3 (SP1) on the following OSs:Windows 7, x32Windows 7, x64Windows Vista, x32 2. The "format painter" icon is not in the "Style Application" toolbar, but in the "Standard" toolbar instead. Please amends the help file or fix t
Last modified by Tombaker on 3/16/2012 12:41:25 AM
How about other font formats? (@font-face rule (Internet Explorer))
Is there any plan to support other font formats like TrueType, OpenType, etc?Thanks
Last modified by dcaravana on 12/7/2009 1:51:30 PM
Tags:  font  format  future  plan
Page view tracker