Forum Replies Created
-
AuthorPosts
-
Elisabeth Straumoey
MemberThank you! :) It turned out I had to change the inset values for all three cell styles for the body rows, in order for them to take effect. The larger inset value of one style probably blocked the others, since they were all on the same row, I think.
March 22, 2024 at 1:41 am in reply to: Placing Excel tables with numbers in InDesign: Ê instead of white space #14401260MemberThank you! The problem is the Excel number spaces that turn into Ê in InDesign, every time the linked Excel-file is updated. Easier with a regular find/change of Ê into non-breaking space in InDesign than the GREP suggestion above, but this remains a workaround. I suppose I’ll save the query in the find/change palette and hope for a limited number of revisions in Excel. :-)
March 21, 2024 at 6:23 am in reply to: Placing Excel tables with numbers in InDesign: Ê instead of white space #14401221MemberThank you for your reply. I also suspect an Excel function of separating the numbers into threes contains some sort of special character that translates poorly upon import into InDesign.
I don’t see anything that might amend this in the Import Options, unformatted tabbed text etc produces the same result.
There are no hidden characters along with the Ê.
Beforehand thanks again for trying to solve this!
March 21, 2024 at 5:00 am in reply to: Placing Excel tables with numbers in InDesign: Ê instead of white space #14401219MemberApologies, UTF is all new to me, of course you are right, UTF16 was available to me.
When I place this UTF16/CSV file all I get is a seemingly empty box with overset text. The story editor tells me the data is there, but it is spread really wide apart (I have to do a find/change operation on words I know should be there to be able to see anything at all). If UTF16 is a solution I must be doing something wrong.
The client will be working in Excel.
If I can get the placing of CSV right somehow (I don’t know how :-/), will changes in the CSV file reflect automatically in InDesign as they would with an Excel file?
March 21, 2024 at 4:33 am in reply to: Placing Excel tables with numbers in InDesign: Ê instead of white space #14401217MemberI didn’t know that was an option. :-) I only see UTF8 on my Excel for Mac here. Does this mean I need to use Data Merge to get the table into InDesign?
Seems a clunky workflow and I don’t see how it would work in this case. These are annual report type tables and I need to place them as they are, not start naming columns / changing things to adhere to Data Merge limitations? Data Merge dislikes empty fields/cells in the first table row, correct?
When I do try placing the CSV file (UTF8) I get the error message “The data source file you selected either has no records or is not a supported file format. Please fix the file, select a file that contains records, or select a supported file type.” :-/
MemberDear Mr Blatner, thank you so much for your quick reply. I can hardly believe I have indexed scriptless all these years. IndexMatic is a marvel and my right arm is saved. B-)
MemberSo simple! I did a small scale test with your suggestion and it seems to work like a charm. Thank you so much. :)
MemberThank you so much for your reply, Chris. As long as I can’t define what I would like the character between TOC entries to be, I still need the find/replace workaround to get the TOC the way I want. Too bad!
MemberSolved, very happy! :D
I deleted the text boxes containing the index, made sure character style was set to NONE and set the paragraph style to “index entry” in the new text box, regenerated the index and – ta-daa!
I am so grateful, thank you! Have a great day!
MemberNo, no GREP style in the paragraph style either.
Yes I can select the whole index and click NONE in the character style panel, but that doesn’t solve the problem since I need to format the page numbers with a character style.
MemberAlso, the paragraph style assigned to the index entry itself has nothing abnormal about it that I can see, 10 pt font with 12 pt leading, optical kerning and normal case + position – and no nested styles.
-
AuthorPosts