Hey all, I am trying to export some table data in the clipboard and I’d like to get the formatting so the width is consistent. I have been using the following with just the number of spaces and it looks alright, but I’m sure someones got a better solution? Thanks!
One of the things the tab key/character is for happens to be tabular data. Separate columns by tabs, and text programs designed to handle this appropriately will line the columns up.
I believe there’s even a hidden trick in Listbox where if you ask for the Cell value of -1, -1 you get the whole listbox content separated by tabs. Someone correct me if I’ve got something wrong there. Try resultString = ListboxManualData.Cell(-1, -1)
I would take the tabs approach because if the text editor isn’t displaying it properly, it’s the text editor. If you litter the data with spaces, the alignment can change for different font widths, and then you’ve also made the data harder to handle after the fact.
One other good thing about using tabs, is that you can paste the information to programs like Excel and will put each value on it’s own cell. With spaces each row will have all the data on the first column.
[quote=405281:@Tim Parnell]One of the things the tab key/character is for happens to be tabular data. Separate columns by tabs, and text programs designed to handle this appropriately will line the columns up.
I believe there’s even a hidden trick in Listbox where if you ask for the Cell value of -1, -1 you get the whole listbox content separated by tabs. Someone correct me if I’ve got something wrong there. Try resultString = ListboxManualData.Cell(-1, -1)
I would take the tabs approach because if the text editor isn’t displaying it properly, it’s the text editor. If you litter the data with spaces, the alignment can change for different font widths, and then you’ve also made the data harder to handle after the fact.[/quote]