Just spent some time exporting a couple of dimmer rack configs to ODS files to make some naming changes and create some panel schedules for a job, and noticed an feature that I have a problem with.
When exporting a dimmer rack layout to an ODS file to edit it's circuit name, module type, etc, the columns for numerically identified items (lug, circuit, dmx A, dmx B, etc.) all have an apostrophe at the beginning of the number. In the OpenCalc program of Open office, this makes those columns not affected by formulas, as well as left justifying them in the column boxes for easy reading. It also makes them not sortable by numerical order. For example- My racks in the config are phase balanced. I was trying to sort first by Circuit number, so I could rename a couple of circuits by finding their circuit number, then print out a panel schedule by circuit number. Then I wanted to re-sort the file by Lug Number, so I could print out a panel schedule how the rack is laid out in phase balanced fashion. What I found was I had to re-enter all the numbers in the Lug and Circuit columns to remove the apostrophe at the beginning so I wouldn't end up with a sort of Lug or Circuit number order of 1,10,11,12,13,14,15,16,17,18,19,2,20,21 etc.
Can Concert in a future version either remove the apostrophe from the Lug and Circuit number columns or make it an option that we can select in the Preferences display? It would make manipulation of the spreadsheet file by using standard sort options much easier.
Thanks.
