Change Panes, Freeze Panes, Split a Window into Panes, Unfreeze Percent Style Format. Editor’s note: Once again it is an honor and a privilege to present an in-depth guest article written by Beverly Voth.Table 3: Microsoft Excel 2011 for Mac Quick Reference Summary. Freeze the top row and the first column. When you do this, the border under row 1 is a little darker than other borders, meaning. On the View tab, click Freeze Top Row. Freeze panes to lock the first row or column in Excel for Mac.
Ze Panes In Excel 2011 Series By Kevin1 The freeze is indicated by the bottom line of the row becoming darker than other lines showing that the row is currently frozen.This is a follow-up to the User-Friendly Excel Exports series by Kevin Frank, but using an XML export along with various XSLT to give you. Click Freeze Top row from the pop-up Window to lock your row. Grab the bar on the far right side and drag down. To freeze horizontal and vertical headings simultaneously:How to Freeze Panes in Excel for Mac. Excel inserts a thin line to show you where the frozen pane begins. Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes.There is another grammar, FMPDSORESULT, and just for comparison, you might test Export to see what that looks like. Demo 1 – XML to simple CSVFor our demos, the export as XML from FileMaker Pro, we will use the grammar called FMPXMLRESULT. The XML is valid even if it is not indented for human viewing. Some browsers will “pretty-print” (indent) the XML document with a default style sheet. Some browsers require you to view the source. You can view the file in any text editor or in any browser.Pay close attention to the “Apply current layout’s data formatting to exported data”. The Export order (as in your dialog) will be the same order (or position) that appears in the XML document. A ROW will be repeated for every record that you export. The link to the full grammar is here:FileMaker Help FMPXMLRESULT Grammar, FMPXMLRESULT Minimal OutlineUsing the basic outline above, notice how there is a FIELD that corresponds to every COL in every row (in the same relative position). You may find the FMPXMLRESULT grammar is somewhat similar in structure to the xml that Excel uses.These style sheets will automatically download with the different types of demos (details on this below). Ignore the HTTP request option for these demos. So we apply an XSLT in the export dialog: Use XSL style sheet Option addedWhen you click the “Specify” button next to the File radio selection, you use the standard OS navigation to find the file. The XSLT style sheets that will be creating CSV “text” will use this method. The full file can be downloaded from the linked demo database and viewed in the browser or text editor: Snippet of the xml2CSV XSLTNotice the xsl:output attribute method=”text”. Xml2CSV.xslThe XSLT is XML with special commands/tags and functions. But we are trying to simplify here to move on to the more complex later.A tip about the XSLT “command/tags” used. We could test for the TYPE in the corresponding METADATA/ FIELD and apply double-quotes for all types except numbers. Every column gets double-quoted regardless of field type. Keep that in mind if you are creating your own XSLT.This XSLT loops through the METADATA/ FIELDs for the column header and for the ROWs/ COLs for all the records and columns (in an inner loop). These are all a text-format but will produce different results. There are actually three methods that can be used with the transformation, including the two just mentioned as well as method=”html”. The comments inline inside each of the XSLT will also help you understand what command/tag and/or function is used and why. Relative and absolute paths may be used in the demos provided here. XPath is used to get the “location” in the source XML. Somewhat like FileMaker Pro functions and scripting, you can have logic and loops and text functions act upon the XML source. Xml2CSV_headers.xsl(Only this part changes — download the full file from the example database): Enter static text for headersKeep in mind that every time there is a new export with different fields or export order, this static text needs to change in the XSLT. We can revise the XSLT to contain static values instead of a loop call to the FIELDs in METADATA. This does NOT solve our problem with “custom header”. You do get all the field names (including related table names). This Sample shows what is returned in the raw XML export if any related field (parent or child) has no DATA.We can leverage the METADATA/ FIELD attribute MAXREPEAT to set some variables and use a test to only process the non-empty repeats. This shows an example from a simple ORDERS database with related Customers and related Items (for the order). Empty portals (or any empty related single field) will return empty:Or Included in the demo download is a file called “related_export_sample.xml”. Enter custom headers in the repeating field in the popoverWhen exported to the raw XML the METADATA/ FIELD will show this field as:Each ROW will show one COL, but many DATA elements:Why use a repeating field here instead of other field types or related fields? The Repeating fields exported as XML will give you one DATA for every repeat (as shown on the layout), even empty ones:Related fields exported as XML will give you only as many children DATA as there are records in the portal. When this is clicked, the Popover will allow you to set the values for your custom values in this field. Setting up a global repeating fieldAnd include this field in your export order: Field export order with new fieldIn the demo on the Donations layout, I’ve included a Popover Button “Custom Headers”. The second demo may be less complex, but requires more manual entry. This demo has more things in common with the first demo (dynamic loops to get the column header values). Notice that variable names in XSLT are case-sensitive (unlike FileMaker variables) and are called with the “$” prefix. Any variable set inside a ROW loop, for example, will change for every record it finds. The global field will actually be duplicated in every ROW and we cannot prevent that. The absolute path to the first ROW (the bracketed “1”) is because we only need these values once. This actually replaces our less complex for-each loop of the FIELD elements in the first demo. We do not want this “header column” to be used in itself or as a column of data. This will be used other places to limit the number of columns in the header row and limit the columns in each row. A variable is set based on the number of columns we are exporting. For example, this would then be: COL. The function last() would also have worked here, as it is the last column/field in the export order. We only want the column that matches the number of fields we exported. The next part of the path: COL, uses that variable we set above. Outlook for mac torrent kickassAll of the above is XPath and understanding it better is what makes it easier to create XSLT.“User-friendly” for the export means more work for the developer at the beginning. Because “<” is a reserved character in XML & XSLT, we use the encoded version for the comparison (see the screenshot and XSLT file). DATA means to give me every DATA element in that COL in the first ROW, but only if its position is less than the number of columns. Hopefully you entered the same number of values in the repeating field as the columns headers you desired. The rest is all dynamically determined by processing the XML with the XSLT upon export.
0 Comments
Leave a Reply. |
Details
AuthorAmanda ArchivesCategories |