Recent

« previous next »
Pages: [1]

Author Topic: fpspreadsheet, Excel-specific workbook properties  (Read 3465 times)

HHick123

  • New member
  • *
  • Posts: 8
fpspreadsheet, Excel-specific workbook properties
« on: November 30, 2016, 09:49:01 am »
Hi,
fpspreadsheet works very well for me. :-)

Unfortunately I have a view remaining requirements, that I could not solve until now. But I think maybe the are out of scope at fpspreadsheet (and should be because they are Excel-specific).

In an xlsx file saved by fpspreadsheet...
(a)  ...I would like to automativcally set an Excel-Autofilter-Row

(b)  ...I would like to automativcally hide some Columns
(b)  ...I would like to automativcally set "worksheet protection" such that the user cannot modify some cells

Has anyone got an idea?
Maybe there are other solutions beside fpspreadsheet (but an Excel installation must not be required)?

Regards, Helmut
Logged

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: fpspreadsheet, Excel-specific workbook properties
« Reply #1 on: November 30, 2016, 11:00:09 am »
At the moment I don't have plans to implement these features.

Did you try this: http://avemey.com/zexmlss/index.php?lang=en ?
Logged

SeregaKR

  • New Member
  • *
  • Posts: 35
Re: fpspreadsheet, Excel-specific workbook properties
« Reply #2 on: May 14, 2018, 11:56:02 am »
Quote from: HHick123 on November 30, 2016, 09:49:01 am

(b)  ...I would like to automativcally set "worksheet protection" such that the user cannot modify some cells

It's already there) At least in current svn version
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018