I have been doing a lot of coding for export to Excel spreadsheets. Formatting strings such as '$#,0.00;[Red]($#,0.00)' appear to be used also by some formatting routines in Delphi. So I am curious now to know where--at the lowest level--such strings have been defined. Do they exist as system constants in some library unit?
Please elaborate with some examples: where did you find which formatting-string to be used. The one most prominently used should be the ones supported by System.SysUtils.Format: http://docwiki.embarcadero.com/Libraries/en/System.SysUtils.Format#Format_Strings
ReplyDeleteJeroen Wiert Pluimers Comparable examples are here: http://docwiki.embarcadero.com/CodeExamples/XE5/en/FormatFloat_(Delphi)
ReplyDeleteI will have to try to backtrack to locate the lead which made me think there might be a collection of constants somewhere in Delphi.
We have (legacy) definitions in existing code; my concern is whether, going forward, we should have these, or whether they already exist.