Chris Pijl
Member since Dec 11, 2008
- Profile: /members/2369-chris-pijl.htm
- Comments: 5
Recent Blog Comments By Chris Pijl
-
POI Utility Now Supports Formulas And Cell Aliasing In Custom Tags
Posted on Sep 25, 2008 at 6:05 AM
Great Ben, thanx ;)... read more »
-
POI Utility Now Supports Formulas And Cell Aliasing In Custom Tags
Posted on Sep 16, 2008 at 5:38 AM
Ben, I've found myself wanting to be able to influence the magnification default when Excel opens, since my data overflows the screen on a default resolution... I've added the following to the sheet.cfm: <!--- The magnification of the sheet. Defaults to 100%. ---> <cfparam name="ATTRI... read more »
-
POI Utility Now Supports Formulas And Cell Aliasing In Custom Tags
Posted on Sep 5, 2008 at 9:07 AM
Ben, In Excel you can choose to refer to your cells using R(ow)C(olumn) names. There is a option you can check in Extra -> Options -> General to change the referral type from A1 to R1K1. If you'd be able to use that, things will get a lot easier! Chris... read more »
-
POI Utility Now Supports Formulas And Cell Aliasing In Custom Tags
Posted on Sep 5, 2008 at 4:53 AM
Ben and Zac, Great functionality! To make things even more variable, is it possible to change the cell reference in Excel to R1C1? Then if the row an column numbers could be replaced by variables the following should be possible: <cfloop from="1" to="12" index="I"> <poi:... read more »