EasyXLS
http://forum.easyxls.com/

Accounting Formatting
http://forum.easyxls.com/viewtopic.php?f=5&t=2215
Page 1 of 1

Author:  masseym [ Thu Apr 14, 2016 11:59 am ]
Post subject:  Accounting Formatting

Using Classic ASP, I would like to format a few cells with Accounting formatting ($ left aligned, #.## right aligned + () for negative numbers). How would I accomplish that?

Thanks.

Author:  oana [ Fri Apr 15, 2016 6:25 pm ]
Post subject:  Re: Accounting Formatting

Hi! Please see this chapter in our online User Guide
http://www.easyxls.com/manual/basics/ex ... tting.html

Author:  masseym [ Fri Apr 15, 2016 6:52 pm ]
Post subject:  Re: Accounting Formatting

I have reciewed that MANY times. I still can't figure out how to apply accounting formatting. I have been able to implement currency formatting, just not accounting format.

Author:  oana [ Sat Apr 16, 2016 12:12 am ]
Post subject:  Re: Accounting Formatting

Please try to use ExcelStyle.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)") method.

Author:  masseym [ Sat Apr 16, 2016 4:54 pm ]
Post subject:  Re: Accounting Formatting

This works PERFECTLY except when a cell contains a formula. is there a way to format cells with formulas?

Author:  masseym [ Sat Apr 16, 2016 8:01 pm ]
Post subject:  Re: Accounting Formatting

Figured it out. Have apply the formatting BEFORE setting the values. Also, do you have a table of similar codes for other fomatting options?

Author:  oana [ Sun Apr 17, 2016 3:08 pm ]
Post subject:  Re: Accounting Formatting

You can do the formatting in Microsoft Excel.
Right click on the cell / Format Cells / choose your formatting / then select "Number" tab / "Custom" category.
Copy paste the characters in "Type:" textbox in your code.

Author:  masseym [ Sun Apr 17, 2016 3:10 pm ]
Post subject:  Re: Accounting Formatting

but the whole point is to do it programatically lol. that is why we purchased the component - to export excel formatted the way we want.

Author:  oana [ Wed May 04, 2016 9:18 am ]
Post subject:  Re: Accounting Formatting

You misunderstood. You are doing it programmatically. You are only using Microsoft Excel to find the predefined Excel formats. Then you are applying them, programmatically, with EasyXLS. The Excel number formats are unlimited and you can make unlimited combinations with them.

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/