Turns out that this flag is not stored in the workbook like the Display 
Gridlines attribute is, so I don't think this is possible.

-----Original Message-----
From: Dominik Stadler [mailto:[email protected]] 
Sent: Tuesday, July 14, 2015 10:08 AM
To: POI Users List
Subject: Re: How to hide formula bar on spreadsheet

Hi,

I don't know of a ready-made interface being available right now, but you can 
likely set it via some of the lower-level APIs in POI.

If yes I suggest you create two very similar files in Excel which just differ 
in this setting and save them as XLSX, then you can unzip both files (XLSX is 
actually a ZIP) and do a file-compare on them to find out where this is stored, 
with this information we can likely guide you to how you can use the lower 
level API to set this.

Thanks... Dominik.

On Tue, Jul 14, 2015 at 1:52 PM, Murphy, Mark <[email protected]> wrote:
> In Excel under the View menu, I can uncheck the Formula Bar checkbox to 
> remove the formula bar from the display. Is there a way I can do that with 
> POI?

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected] For additional 
commands, e-mail: [email protected]

Reply via email to