Quick access settings in Infor Spreadsheet Designer

You can view some settings in Infor Spreadsheet Designer on the Infor tab of the Microsoft Excel ribbon.

Query

  • Insert Query: Creates a list of records from Landmark application data to view, update, and report on Microsoft Excel.
  • Delete Query: Removes a query.
  • Properties: Opens the Query Properties window.

Upload

  • Insert Upload: Links Landmark business classes and actions to your worksheet.
  • Delete Upload: Deletes an upload.
  • Properties: Opens the Upload Properties window.

Query Settings

  • Batch Query Notifications: Enables notification if Batch Query is not selected.
  • Filter Notifications: Enables notification if the special characters '&' or '|' are used.
  • Always Sync Worksheet Headers: If this option is selected, the worksheet header fields are synced based on the sorting of the fields in the Query Properties pane field list box each time the query is refreshed.

Upload Settings

  • Batch Upload Notifications: Notifies the user when Batch Upload is not selected.
  • Locale mismatch notifications: Notifies the user when the locale for the Actor differs from the machine locale. Actor locale is always used to format dates when there is a mismatch.
  • Fast Feedback: Disables color coding of cells when Batch Upload is used. This can improve performance. Errors are marked with ****ERROR:.

User Interface

  • Legacy Settings: When selected, moves some settings from the Microsoft Excel ribbon to the Settings options dialog box. See Legacy settings view.