Hi.
Here’s a trick:

Set up your TOC paragraph style as “invisible”.
– Font size 0.1 pt
– Color: none
– tracking: -1000
– horizontal & vertical scaling: 1%

Set up “Complejo de Culpa” character style like this:
– Font size 11 pt
– Color: [Black] or whatever color you wish
– tracking: 0
– horizontal & vertical scaling: 100%

Set up a character style for the TOC page numbers

Now, TOC should carry on “Complejo de Culpa” character style if you manually applied it, which is what I understood… and make all the rest invisible.

Would that work for you?

Hi David
Apparently, my version do not completely behave like yours. Without closing the document, my Indd keeps the last picked color, even if I close the xref panel.
That said, if you close the doc, it’s a different story. Unfortunately, after some testing, I must say the way the color behave is really inconsistent.
Sometimes it goes back to black, sometimes it picks another (random?) color…
It does not seem to be an document preference, nor an application one. Some sort of “cache” pref, out of the box…
I’m afraid you’ll have hard time finding a solution for this, unless someones pops up with an explanation and/or a solution…
Sorry i can’t help any further…
Vinny

Something like this maybe?

if (parseFloat(app.version) < 6) {
main();
}else{
app.doScript(main, ScriptLanguage.JAVASCRIPT, undefined, UndoModes.ENTIRE_SCRIPT, “Change cyan tint”);
}

function main() {

if (app.documents.length > 0) {

//Variables
var
myDoc = app.documents[0],
myCells = myDoc.stories.everyItem().tables.everyItem().cells.everyItem().getElements();

for (i = 0; myCells.length > i; i++) {

if (
myCells[i].fillColor.name != ‘None’ &&
myCells[i].fillColor.colorValue == ‘100,0,0,0’ &&
myCells[i].fillTint == 5) {
myCells[i].fillTint = 10;
}
}

} else {
alert(“Open a document”);
return null
}
}

https://codeshare.io/G8ZPlD

Hi!
Create a preflight profile. Under the “Text” submenu, go to “Minimum type size” and select 12pt.

Yeah, Indesign doesn’t handle custom cell format very well… (euphemism…)

What I would do is to forget about Excel custom cell formatting and use an Excel function to turn the number into formatted text.
Maybe the easiest way would be to create a new sheet and to use a function to get the real values from your working sheet while turning them into formatted text.
Then, in Indesign, tick “import options” and select that new sheet.

I guess the “TEXT” function is the one you are looking for.
See : https://support.office.com/en-us/article/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c

Type
=TEXT(YourWorkingSheet!A1;”#,##0.00 “)
in A1 in your new sheet and copy/paste in order to duplicate your working sheet.

If your table have always the same number of cells, it should be easy enough
If not (e.g. you have to add/delete rows from time to time), then you’ll have to deal with empty cells.
This would be more a call for an Excel forum…

Please note I use a French version of Excel. So I tried to “translate” the function, assuming you have an English version, with a comma as a thousands separator, and a dot as a decimal separator. But I could not test it properly, so hopefully it will be ok.

Hope that helps
Vinny

What kind of graphs are you after?
Maybe this thread could be of any interest : https://forums.adobe.com/message/10338191#10338191

Hi
I am not aware of such a hotkey in Indesign…
I’m afraid you have to switch permanently to direct selection (hitting <kbd>A<\kbd> or <kbd>Crtl<\kbd>+<kbd>Tab<\kbd>)
Tip: assuming you had your object already selected, all anchors points are now selected by default. To select directly the one you want, you can hit <kbd>Crtl<\kbd>+<kbd>Alt<\kbd>. While the cursor changes to a tailless white arrow, click on the desired anchor to deselect all the others. Release and drag.
Please note the shortcuts are for PC…
I know this does not really answer your question, but maybe someone else will come with a direct solution…