[prev in list] [next in list] [prev in thread] [next in thread]
List: poi-user
Subject: Re: Macro
From: Chitão <christian.teixeira () neogrid ! com>
Date: 2008-01-07 19:36:54
Message-ID: 14673935.post () talk ! nabble ! com
[Download RAW message or body]
dont know if that will answer your questions but anyway
http://poi.apache.org/hssf/limitations.html
so i would guess not
can't you create your xl file based on an xl previously created, which \
would contain the macro?
that may be a solution for you, if i understood your problem correctly
cheers
Lauren Riley wrote:
>
>
> I am writing an Excel file that uses VLOOKUP, INDEX, and MATCH functions
> to
> look up information in other sheets, that I am also writing. As I come
> into the spreadsheet, the values are shown as #VALUE. If I go up to the
> top and view my function, all I have to do is hit enter at the end, and
> then the correct value will display. I played with the
> HSSFFormulaEvaluator some, but since those 3 functions aren't supported
> yet, that didn't work either. So my last option was to create a macro
> that
> would just go hit enter on all those cells, hopefully showing my values
> immediately. I'm not sure how to do this, however. Is it possible to
> have
> a macro run upon opening the spreadsheet created totally in HSSF?
>
> Thanks, Lauren
>
> __________________________________________
> The information contained in this message may be privileged and
> confidential and protected from disclosure. If you are not the intended
> recipient of this message, you are hereby notified that any \
> dissemination, distribution, or copying of this communication is strictly \
> prohibited. If you have received this communication in error, please \
> notify us immediately
> by replying to the message, and please delete it from your computer.
>
--
View this message in context: \
http://www.nabble.com/File-Size-Problem%21-tp14604200p14673935.html Sent \
from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic