Thanks for your interest, the kind words and these questions. You've certainly done your homework and experimenting.
Your goal, as I understand it, is to "display" PDF documents, derived from Excel spreadsheets, in landscape format. Here's how I would approach that:
- Create the spreadsheet. In Excel (2010), click the "Page Layout" tab, click "Orientation" and select "Landscape".
- Save the spreadsheet as a PDF document. If you have Acrobat, you can just do "File", "Save As", "Save as type: PDF". Otherwise you can use some other tool like "Cute PDF" to create the PDF document.
- Upload the PDF document(s) to your WordPress site
- Create a page or post containing an
[mla_gallery] shortcode to display a list of the document(s).
[mla_gallery] step builds a list of your PDF documents so the site visitor can choose the document they want to display. When they click on a document in the list, the actual PDF will be downloaded and displayed in their browser. This is where the "Landscape" orientation comes in - during document display - and it's handled by the Adobe Reader component that displays the PDF in the browser. WordPress and
[mla_gallery] do not play any part in the Landscape/Portrait display mechanics.
Here's a simple
[mla_gallery] to start with:
[mla_gallery post_mime_type="application/pdf" link=file mla_target="_blank" mla_viewer=true]
In this example,
post_mime_type="application/pdf" selects all the PDFs in your library. You can substitute any item selection parameters you want, e.g.,
link=file parameter makes each gallery item a link to the actual PDF document, and the
mla_target="_blank" parameter will open the document in a new browser tab/window.
mla_viewer=true since your examples included it. All this parameter does is to replace the default text or icon "thumbnail" in the gallery with an image of the first page of the PDF document (generated by the Google Viewer app). This parameter does not affect the display of the document itself. You could also try
size=icon to display an icon for each document, or rely on the default display of the title text for each document. The other
size= parameters (e.g.,
size=full) are for images only; they do not affect the gallery display of PDF items. In your first example,
size=300x150 would be ignored, and
add_image_size(300x150) is not a valid parameter.
You can try adding
columns=1 mla_viewer_width=400 to your shortcode to get a single-column list with fairly large thumbnail images. Again, the list isn't displaying the actual document(s), just an image representation of the first document page. The document isn't really displayed until you click on one of the items in the list.
I hope that's enough to get you going. If you have any problems or further questions, let me know and I'll expand on this first pass.