It looks like you want to register a listener to a spreadsheet component. To satisfy your goal, you could add the listener to the spreadsheet object it self, or to another nested object that implements an interface that supports an add.+EventListener() method. Below is a pair (broadcaster/listener) that I can think you could use in … Read more
Do you need to do this once or is this going to be a repeated task every week/month? If it is something you need to do just once, here is what you can do: Next (right) to the column where your numbers are open (insert) a new column. Assuming the following: Numbers are in column … Read more
If you want your input to be interpreted as text and preventing Calc to do fancy (and annoying) things with your input, you have to change the format before entering any value. Select the cells/columns/rows. Right-click ‘Format Cells…’ Select the tab ‘Numbers’ In the list ‘Category’, select ‘Text’ (the last option) Select the format ‘@’ … Read more
This works for me: =CONCATENATE(“”””,A1,””””) Repeating the quotes escapes them (as it does in Visual Basic, I believe), so “””” reads as: ‘one quote to start a string, one escaped quote (“”), then one quote to finish the string’.