Cells containing paired square brackets rendered as hyperlinks

[amir-zeldes]

Hi everyone, is there a way to prevents cells containing square brackets from being rendered as hyperlinks?

[enemali]

Click on the cell then click format bar from the toolbar , select text , from the drop down , select plain text or any text formatting , then click save to under CELL SETTINGS: . The default cell formatting is wikitext . So wikitext format causes those square brackets to be rendered as hyperlink

[amir-zeldes]

Hi @enemali - thanks for that! I was wondering on a more programmatic level whether I can shut that off, so that users starting a new table already have all cells in that mode. My problem is with users entering a new sheet, typing content that has square brackets, and reporting that it 'disappears and becomes a hyperlink'.

Some of the data is pasted in in large quantities, so manually changing the formatting is not a good option for us.

[eddyparkinson]

Default format

You could change the default;

Sets value to default
https://github.com/marcelklehr/socialcalc/blob/master/js/socialcalc-3.js#L5642
but I am not sure where the default is defined.

Paste format

You can select many cell and paste a format to all selected cells - is easy to paste formats on mass.

[amir-zeldes]

This is helpful, thanks! I could start messing with the code itself and hardwire it somehow, but is there any chance this could be made parametrizable in some configuration file?

[eddyparkinson]

is there any chance this could be made parametrizable

It does read parameters in. This could be done. Should not need much code, but would
need some searching to workout how best to set the default.

[amir-zeldes]

Thanks @eddyparkinson ! In the meantime I was able to figure out that I can append something like tvf:1 at the end of the row in SocialCalc format (after the format, e.g. ...:f:1:tvf:1). Since I'm programmatically manipulating the SocialCalc format this more or less solves my use case, but I may come back to this if I have a chance.

For anyone with this problem who is uploading user data and generating SocialCalc themselves, I hope this may be helpful!