Excel to pdf converion issu


i have a excel document that have to following settinhg:

.PageSetup.PrintTitleRows = "$1:$8"

.PageSetup.PrintTitleColumns = "$A:$C"

.PageSetup.Order = PrintOrderType.OverThenDown

when i covert to pdf i notice 3 things:

if the sheet feet the print area everything is fine

if the sheet do not feet the print area the in the second page i loose the formula values

if i manualy set the page break i do not loose formula values but i loose the PrintTitleRows and PrintTitleColumns settings

i could attach you the files

you can download the files at this link http://wind.robit-informatica.it/DOCUMENTI.zip


I cannot download the file from your url. Please post them in the forum. Thank you.