Support Board

Date/Time: Thu, 02 May 2024 15:17:30 +0000

Post From: Spreadsheet File Conversion Failed

[2017-01-04 12:36:25] Link To Thread - Link To Post [Go To First Post]
user58907 - Posts: 83
I do have .NET4 Installed. 1) I actually have 13 files and >300 sheets to convert. I only sent you the one because when I opened the installation with 4 chartbooks and 4 spreadsheet files, it went into a seemingly endless loop of conversion, so I set it such that only one workbook would open upon launching. 2)I tried for the 1 file today to see if copying formulas over would work. This is because I use a lot of formulas and syntax unsupported by the new spreadsheets, so I was looking at this as an alternative. After attaching spreadsheet studies to 21 charts, I renamed the sheets to match the charts. Upon closing and relaunching the installation, every sheet was duplicated by a numbered sheet with the same data. The same thing happened with the installation I managed to convert in situ, mentioned in my first post above. I do not know if this is standard, but the renamed sheets do not seem to update after they are duplicated. Also, one of the sheets had the studies scrambled, ie the first study was not in column AA. I'm trying to solve this best I can without being a burden, but this is really not getting anywhere. Kindly advise. I can send you the files for conversion, but it's a lot more than 1.