Created attachment 63959 [details] rows to repeat in print When printing with print ranges n lines header, an error occurs from the second page: Only the n-th row is printed. Also occurs in version 3.5.4. Ao imprimir com intervalos de impressão n linhas de cabeçalho, um erro ocorre a partir da segunda página: somente a n-ésima linha é impressa. Também ocorre na versão 3.5.4
Hello If I understand what you want to get (repeat lines 3 and 4 on all pages) it's not a bug but from mishandling. You have defined "Rows to repeat = $4" but you have to define $3:$4 Sorry if I have not understood what you want... Regards Pierre-Yves
Dear Pierre-Yves, Hi I can not write in English. Sorry for the inconvenience. I'll try... In the worksheet Line 1 = abc Line 2 = def Line 3 = ghi Line 4 = jkl In printing the lines 1-3 are not displayed from the 2nd page. What is expected is the display of all four lines. Congratulations, João Prezado Pierre-Yves, Olá. Não sei escrever no idioma inglês. Desculpe-me pelo transtorno. Vou tentar... Na planilha linha 1 = abc linha 2 = def linha 3 = ghi linha 4 = jkl Na impressão as linha 1 a 3 não são exibidas a partir da 2ª página. O que se espera é a exibição de todas as 4 linhas. Congratulações, João
(In reply to comment #2) > Hi I can not write in English. Sorry for the inconvenience. Don't worry, mine is not good (I'm french...) Did you tried what I suggested ? You have to defined the "range" of Rows to repeat, here $1:$4 If you ask for repeating $4, it's only the fourh line that will be reproduced from the 2nd page In the attached spreadsheet "Format>Print ranges> Edit" is defined to reproduce on all pages the cells I have coloured (yellow) : lines 1 to 4 and col. A I hope it is what you want :) Regards Pierre-Yves
Created attachment 64001 [details] erro na tabela dinâmica modified
Thank you. Work fine! ============== >Hi I can not write in English. Sorry for the inconvenience. Don't worry, mine is not good (I'm french...) Did you tried what I suggested ? You have to defined the "range" of Rows to repeat, here $1:$4 If you ask for repeating $4, it's only the fourh line that will be reproduced from the 2nd page In the attached spreadsheet "Format>Print ranges> Edit" is defined to reproduce on all pages the cells I have coloured (yellow) : lines 1 to 4 and col. A I hope it is what you want :)