<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-NZ link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hi Charles (& others)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Thanks for the advice guys. I’ve come up with this, it works a treat.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'>[%'Scale 1:' || format_number(round(map_get(item_variables('Main-Map-1'), 'map_scale'),0),0)||<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt;text-indent:36.0pt'>CASE<o:p></o:p></p><p class=MsoNormal style='margin-left:108.0pt'>WHEN @layout_pagewidth IS 297 AND @layout_pageheight IS 210 THEN ' @ A4'<o:p></o:p></p><p class=MsoNormal style='margin-left:108.0pt'>WHEN @layout_pagewidth IS 210 AND @layout_pageheight IS 297 THEN ' @ A4'<o:p></o:p></p><p class=MsoNormal style='margin-left:108.0pt'>WHEN @layout_pagewidth IS 420 AND @layout_pageheight IS 297 THEN ' @ A3'<o:p></o:p></p><p class=MsoNormal style='margin-left:108.0pt'>WHEN @layout_pagewidth IS 297 AND @layout_pageheight IS 420 THEN ' @ A3'<o:p></o:p></p><p class=MsoNormal style='margin-left:72.0pt'>ELSE ' @ ???'<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt'>END%]<span style='mso-fareast-language:EN-US'><o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Cheers<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Tony<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> Charles Dixon-Paver <charles@kartoza.com> <br><b>Sent:</b> Friday, 21 May 2021 9:46 am<br><b>To:</b> Tony Shepherd (FarmMaps NZ) <tony@farmmaps.nz><br><b>Cc:</b> qgis-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] Layout page size variable?<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Yeah I am not aware of a variable for this... But page sizes are actually more complicated than they seem. You can emulate it pretty easily with something like the following expression on a layout as you suggested:<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>[%CASE<br>WHEN @layout_pagewidth IS 297 AND @layout_pageheight IS 210 THEN 'On A4 Landscape'<br>WHEN @layout_pagewidth IS 210 AND @layout_pageheight IS 297 THEN 'On A4 Portrait'<br>WHEN @layout_pagewidth IS 420 AND @layout_pageheight IS 297 THEN 'On A3 Landscape'<br>WHEN @layout_pagewidth IS 297 AND @layout_pageheight IS 420 THEN 'On A3 Portrait'<br>ELSE 'With page dimensions of ' || @layout_pagewidth || ' x ' || @layout_pageheight<br>END%]<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Thu, 20 May 2021 at 23:13, Tony Shepherd (FarmMaps NZ) <<a href="mailto:tony@farmmaps.nz">tony@farmmaps.nz</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi All<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Is there a variable that returns the page size of a print layout?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I would like to add the page size to the scale below so it reads something like “1:5,000 @ A3”<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I can see variables for width and height, but not Page Size?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Or would I need to code in some ‘if’ & ‘then’ statements using the width variables to arrive at the page size?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><img border=0 width=356 height=104 style='width:3.7083in;height:1.0833in' id="gmail-m_2357712367802510580Picture_x0020_4" src="cid:image001.png@01D74E2A.4A29B800"><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Cheers<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Tony<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='color:#404040'>Tony Shepherd</span></b><span style='color:#595959'> </span><b>|</b><span style='color:#595959'> GeoSpatial / Mapping Manager</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#595959'>Ph 027 435 6193 </span><b>|</b><span style='color:#595959'> E <a href="mailto:tony@farmmaps.nz" target="_blank"><span style='color:#0563C1'>tony@farmmaps.nz</span></a></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#595959'>FarmMaps NZ, 3 Kerwood Place, Gore 9740</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#595959'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#595959'><img border=0 width=160 height=75 style='width:1.6666in;height:.7812in' id="gmail-m_2357712367802510580_x005f_x0000_i1027" src="cid:image002.jpg@01D74E2A.4A29B800" alt="FM_logo1_small (Custom)"></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='color:#7B7B7B'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-family:"Arial",sans-serif;color:#7B7B7B'> </span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><a href="http://tonyshepherd8.wixsite.com/home" target="_blank"><b><span style='font-family:"Arial",sans-serif;color:windowtext;text-decoration:none'><img border=0 width=157 height=34 style='width:1.6354in;height:.3541in' id="gmail-m_2357712367802510580Picture_x0020_1" src="cid:image003.png@01D74E2A.4A29B800"></span></b></a><a href="https://www.wunderground.com/personal-weather-station/dashboard?ID=ISTLGORE2" target="_blank"><b><span style='font-family:"Arial",sans-serif;color:windowtext;text-decoration:none'><img border=0 width=170 height=37 style='width:1.7708in;height:.3854in' id="gmail-m_2357712367802510580Picture_x0020_3" src="cid:image004.png@01D74E2A.4A29B800"></span></b></a><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div><p class=MsoNormal>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p></blockquote></div></div></body></html>