Hi  

If you use the Microsoft Excel 2007 - 2013 filetype in Studio then you can set this up using the "Sheets and shapes" options.

Hi Paul,

Now that this facility is no longer (in Studio 2021), I suppose that there is another way to do this, but I haven't found it. Can you help?

Mats Linder

Mats Linder said:

Now that this facility is no longer (in Studio 2021), I suppose that there is another way to do this, but I haven't found it. Can you help?

There isn't one.  In January 2019 I discussed this with the filetype manager as I wondered why this had been removed.  The response was:

"...it’s making it all very complicated for very little benefit – since we removed that option I didn’t see any requirement for adding it."

As far as I'm aware we are now two years further on and your post is the first comment I have seen on this.  So I think he was probably right.  Why do you need to be able to do this?

Paul Filkin,

Paul Filkin said:

Mats Linder said:

Now that this facility is no longer (in Studio 2021), I suppose that there is another way to do this, but I haven't found it. Can you help?

There isn't one.  In January 2019 I discussed this with the filetype manager as I wondered why this had been removed.  The response was:

"...it’s making it all very complicated for very little benefit – since we removed that option I didn’t see any requirement for adding it."

As far as I'm aware we are now two years further on and your post is the first comment I have seen on this.  So I think he was probably right.  Why do you need to be able to do this?

I am surprised to hear that because I just did this with an Excel file (read content by columns instead of by lines):

Or did I misunderstand the question?

Daniel

Unknown said:

I am surprised to hear that because I just did this with an Excel file (read content by columns instead of by lines):

Not quite the same as this:

Expanding to this:

A lot more complex than the simple option that was actually added later on but still doesn't go as far as this.  Having said that perhaps you are right insofar as what Mats Linder is looking for?

Haha... I don't need to do it; I just found out that this feature has been removed during the work on updating the manual. I would not presume to be a better judge than the filetype manager.

Anyway, thanks for the swift reply!