0

set column with and row higth

Jet Reports Historic Posts

July 01, 2013 11:13

None

Follow

Hi,
I'd like to set columns to a fixed width instead of using the jet function "Fit" (F.E. column with column B = 12). Is this possible? And is this also possible to set row hight to a fixed higth?
Kind regards,
Saskia

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts July 02, 2013 08:34 Official comment

  Hi Saskia,
  
  Hope I understand your question correctly - if you want fixed column widths on a pivot table, go to pivot table options and untick the 'Autofit column widths on update' check box.
  You can then set your column widths and they will not change when you run your report.
  
  Regards
  
  Tom

• 0
  
  Jet Reports Historic Posts July 01, 2013 17:43

  Hi Saskia,
  
  You are not required to use Fit. Just delete the Fit keyword from Row 1 of the columns in question and they will stay a fixed width when running the report. Does this help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 02, 2013 06:37

  Hi Hughes,
  In the sheet with my pivot tables the column width changes everytime after running the report. In the first row, the cells are empty (no Fit), in cel A1 I have tried "Auto, Auto+Hide, Auto+Hide+Values". But everytime after running the column width of the sheet with my pivot tables changes.
  
  I just like to have fixed column width. Is that somehow possible?
  
  Kind regards,
  Saskia

  • Column width before running.jpg
  • Column width after running.jpg