| 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/ |
|