Charts and CFs are missing after conversion

Hello,

I'm using FlexCel (Version 6.2.1) to change cell values in Excel files and convert these files from xls to xlsx/xlsm format. Everything works fine except that charts and conditional formattings are missing after the conversion. If I'm keeping the xls format after changing cell values, the charts and conditional formattings are preserved. Do you have any ideas how to preserve charts and conditional formattings while changing the file format?

Best regards,

Christian Sack

Hi,

About charts, they are sadly not converted between formats: we will preserve the charts in xls files when you modify them, and we will preserve the charts in xlsx files when you convert them, but we don't convert between xls and xlsx charts. They are just too different, even Excel itself has a lot of bugs when converting charts between formats, and they are out of the scope of the project. While we try to convert everything we can between xls and xlsx there are some limitations and charts are one of those. There are 3 categories of conversion:
1)Most of the stuff is converted back and forth between xls and xlsx. This even applies to stuff that isn't natively supported in xls, like true colors for cells instead of the indexed colors which is what xls supports.

2)Some stuff is converted just in one way. This basically applies to macros, which will be converted from xls to xlsx, but not from xlsx to xls. 

3)Some stuff isn't converted. Currently this would be charts and pivot tables, and stuff that just can't be converted because it isn't supported in xls (for example you can't have an xls file with more than 65536 rows)
 Some more stuff might be added in the future which isn't converted, but just preserved between xls->xls and xlsx->xlsx.

We really try to convert as much stuff as we can, but at the end of the day, FlexCel is a component to create xls or xlsx files, not really a component to convert between them. Charts (or pivot tables) are so different internally that making a converter would be a project on its own.

About Conditional formats, they aren't converted yet, but they should in a couple of months when we finish the cf support for xlsx. Even when xlsx/xls cond fmts wre quite different, the workload to do the conversion isn't that big as in tables, and it is in our plans to convert as much as possible of cond fmts between xls and xlsx. (some stuff might not be converted from xlsx to xls because cfs in xls are much more limited, and some stuff available in xlsx isn't available in xls)