View original (French)

OpenOffice - overlay 2 spreadsheets

akaspy Posted messages 45 Status Member -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

I would like to know if it is possible to print two spreadsheets (or even three, or more) in such a way that the two sheets overlap when printed as a single document.

I have prepared a main sheet (for presentation), and several other sheets that contain data. My goal is to "merge" my main sheet with each of the data sheets in succession. Since my main sheet contains variables (like the date), I do not want to include it directly in my data sheets for fear of having to modify them one by one before each print.

I initially tried to include a dropdown list on my main sheet to allow for the selection of which data sheet to include based on the choice made. However, while I can include the content of a single cell, I am stuck when it comes to including a range (or an entire sheet, since in my case, the range to include is ultimately the entirety of a sheet).

So, if what I described at the beginning of my post is impossible, I would not mind being directed to a tutorial that explains how to include a range in a sheet based on a selection made previously via a dropdown list.

Sorry if I am not clear (I really tried to use the appropriate terms, but I am a beginner).

Thank you in advance.

Configuration: Windows 7 / Firefox 6.0.2

4 answers

  1.
    pépé35530 Posted messages 2951 Registration date   Status Member Last intervention   1 390
     
    Hello,

    In my opinion, the simplest way would be to create a new sheet and use the special paste option.
    All you need to do in each sheet is select what you want, copy it, and then use the Special Paste function to insert only the values into the new sheet.

    Another solution is to use Word and insert your sheets as objects.

    Talk to you later!

    Grandpa
    0
  2. akaspy Posted messages 45 Status Member 2
     
    Thank you, grandpa.

    To be honest, this is how I'm proceeding for now, while waiting to find a better solution that would be quicker.

    As for Word, I will try, even though I don't really know how to do it at first, but I will look into it.

    Mastering drop-down lists would be ideal, so I will keep searching in that direction.
    0
    1. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      September 27, 2011 at 04:50

      No! A drop-down list only allows for the display of the content of a cell, nothing more.
      There’s no way to use it to insert a range of data!
      0
  3. akaspy Posted messages 45 Status Member 2
     
    It seems to me that you have approached the problem the wrong way. A drop-down list can indeed only display the content of a single cell, but the choice made from the list can influence several cells, and that is the goal I am trying to achieve.

    To put it simply, I want to display data from sheet 2 or 3 or 4, etc., on my sheet 1 after having previously made the choice "2" or "3" or "4", etc., in the drop-down list.
    0
  4. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    It hardly resembles what you presented the first time ...
    your request from post #4 is easier to solve;
    but it would help us to respond if we had your file (after you have modified the proper names)!
    --
    Retirement is nice! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    0