Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Spreadsheets Inside of Spreadsheets

  1. Aug 28, 2009 #1
    So, I can create a spreadsheet inside a spreadsheet as follows in Excel:

    1) Open the visual basic toolbar
    2) Select More controls
    3) Select Microsoft Office spreadsheet

    The spreadsheet seems to be a web component (which means I guess it is more light weight then a regular spreadsheet and probably has some security restrictions). I thought this would be a cool way to represent arrays inside of excel. However there are some things I don't like:

    -I don't think their are any options for hiding the things like, column headings, toobars and such.....these make it look very ugly and should only show if you are editing values in it.
    -The display in non compact. It is a good format for editing but not for display, besides if I want to edit a value in it I'd probably rather it open in a separate window.

    3. I suppose I could always create my own active x object for excel although that kind of defeats the purpose because I like excel because it is available on most computers. I might not have the rights to link additional libraries on other computers. Also for anyone who use the spread sheet it creates an extra step of linking a library they will have to go through before using the spreadsheet.

    Is there a way I can extend these objects from inside excel without writing any external libraries. Maybe make it so I can put some kind of canvas over it for display, and then move the canvas to the back when people are in edit mode. I notice when you are in visual basic edit mode excel gives you the option to move things to the front or move things to the back but I would like it so the display object could be treated as the same object as the spread sheet object.

    edit Thinking further perhaps it would be more fun to use something like mathype to represent arrays in excel instead of embedding a spreadsheet in a spreadsheet. It would certainly look prettier. Or maybe use something like mathtype for the visual part but store the data in a separate embeded spreadsheet.
  2. jcsd
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted

Similar Threads - Spreadsheets Inside Spreadsheets Date
Python How to reset counter to 0 inside loop Jan 29, 2017
HTML, add/delete element inside div Jan 7, 2017
Putting an Image inside of a Div block Mar 2, 2016
Excel spreadsheet that prevents using data Jan 7, 2016
Help with 3D matrix, 3D spreadsheet. May 25, 2008