View original (French)

Print table with frozen panes

Solved
alainjjb Posted messages 747 Registration date   Status Member Last intervention   -  
alainjjb Posted messages 747 Registration date   Status Member Last intervention   -
Hello,

I created a table with the first 3 columns frozen, and now I want to print it on 2 pages (cut vertically). However, when printing the second page, I no longer have those 3 frozen columns. It's impossible to set the print area of the second page with those famous 3 columns. Yet I'm convinced it's definitely possible, right?
Thanks in advance for your insights.
Alain

Configuration: Windows / Firefox 64.0

5 answers

  1.
    alainjjb Posted messages 747 Registration date   Status Member Last intervention   112
     
    Hi Raymond,
    I understand that it's not easy to respond to a virtual file. I managed to get by with "Layout":
    - Decrease / increase = 50%
    I also narrowed the width of the columns on the second page, which had one more column.
    And it works.
    Thank you for everything
    Alain
    1
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    it's in 'Page Layout / Print Titles', rows to repeat and columns to repeat.
    eric

    --
    By trying continuously, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes, it happens!!!), remember to mark it as resolved. Thank you.
    0
  3. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Attention, Alain:
    The DISPLAY/Window/Freeze Panes tool only affects the screen; not the print.
    The tool indicated by Eric, whom I greet, only affects the print; not the screen.

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  4. alainjjb Posted messages 747 Registration date   Status Member Last intervention   112
     
    Hello,
    thank you Raymond for this clarification. It's always good to know.
    Eric, that's fine, I am indeed getting my 2 pages with the 3 fixed columns. That was my initial request.
    BUT now I have an additional question:
    - This table contains the weeks of the 1st semester of 2019 in columns. I would therefore like to print it on 2 pages by cutting this table at the end of the 1st quarter. Currently, it cuts off in the middle of April, which is not compliant.
    Can we specify the cut column?
    Thank you
    Alain
    0
    1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      You need to select the first week of April and insert a page break.
      0
  6. alainjjb Posted messages 747 Registration date   Status Member Last intervention   112
     
    Hi Raymond,
    it's not working with this procedure:
    - To insert a page break, I selected the column for the 1st week of April
    - In "page layout": Fit to 2 pages wide and 1 page tall
    - The print area defined: the entire table (both pages)

    Thank you
    Alain
    0
    1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      Just in case it might help you: I don't have your file, I don't know how your table is structured, nor how your rows and columns are distributed ...
      So I replied with the only information you agreed to give us!
      0