FlexCel Studio for VCL/LCL
ContentsIndex
PreviousUpNext
XlsFormatValue Function

This method has been deprecated. Use XlsFormatValue1904 instead.

Pascal
function XlsFormatValue(const V: variant; const Format: UTF16String; var Color: Integer): UTF16String; deprecated;
C++
UTF16String XlsFormatValue(const variant V, const UTF16String Format, int Color);
Parameters 
Description 
const V: variant 
Value to convert. 
const Format: UTF16String 
Format to be applied to the value. This must be an standard Excel format string. 
var Color: Integer 
Returns the color the text should be in, if the format contains color information. 

The value formatted as a string.

Excel has two different date systems: one starts at 1900 and the other at 1904. While 1900 is the most common (it is the default in Windows), 1904 is used in Macs and also might be set in Excel for Windows too in the options dialog. 

 

This method assumes always 1900 dates, so it is not safe to use and you should use "1904" overloads instead.

Copyright (c) 2002-2008 TMS Software. All rights reserved.
What do you think about this topic? Send feedback!