We currently export our orders from the accounting software to an OS X numbers spreadsheet and pull that data into our small newspaper layout for classifieds as text, then we have to manually re-format the data for underlines, bold, spacing, etc.. Trying to bring the spreadsheet directly into ID have seen the following :
1. The "place" function (inDesign CC) does not see "numbers" files (OS X), so we have to either export the data to a text file, or export the data to .xls.
2. If we prepare the numbers spreadsheet, pre-formatting the data within the spreadsheet the formatting is lost when we place it within the layout.
If we do no formatting, each cell must be manually formatted within ID.
Clearly Adobe has a sweet suite of software here, but we have not been able to find a good method to streamline this workflow.
Good Local News
I might have some useful suggestions. First, though, would you clarifying something for me?
Classifieds. So every ad has a predictable format, correct? There's headline, then body, then something else? Does this vary?
Each ad has a "somewhat predictable" format
First line may or may not be BOLD or ALL CAPS
other lines are typical sentence case, standard arial font All ad text is the same point size. Hope that helps!