How to hide formula bar on spreadsheet

["Murphy, Mark" <mu...@metalexmfg.com>]

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?

RE: How to hide formula bar on spreadsheet

["Murphy, Mark" <mu...@metalexmfg.com>]

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:dominik.stadler@gmx.at] 
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 <mu...@metalexmfg.com> 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: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org

Re: How to hide formula bar on spreadsheet

[Dominik Stadler <do...@gmx.at>]

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 <mu...@metalexmfg.com> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org