I was wondering if you support, or plan to support the preservation of Equations in Objects (Shapes, Text Boxes, Etc)
When loading and saving a xlsx sheet that has a shape (eg rectangle) that contains an equation to equal the text in cell A1, the equation has been removed, and the object is blank.
Flexcel Version 184.108.40.206
I think it is fasible to preserve those indeed: the reason they aren't is that I wasn't even aware you could do that. I'll investigate and let you know when I have more information.
Thanks for looking into it for me.
I have a test case if that will help you out.
When I copy sheets from one spreadsheet to another my equations get turned into text in a textbox. There is nothing fancy about my equations, they just sit on the sheet. Is there any way of preserving equations. I'd even accept turning them into images if that would keep the equation looking correct.
Obviously keeping the equation as an equation would be preferable.
I am using TMS FlexCel Studio for VCL and FireMonkey 220.127.116.11
Update. It is not the copy operation. If I load an Excel file with an equation in it and immediately save it, the equation is converted to text in a textbox.
I think you are speaking about a different topic than the previous thread: The original post wasn't about equation objects but about formulas associated to autoshapes or objects (you associate formulas with objects by writing the formulas with the object selected in the formula bar).
Now, about your particular issue, it is not that they are converted into textboxes, as no conversion is going on (if you look at the original file you'll see the equation is also a textbox). The issue is that not all the subscript/etc stuff is being preserved in the comboboxes in xlsx.
I am taking a look right now to see how this can be fixed. In the meantime, if you can save as xls instead of xlsx, I think it should work fine.
As said, the equation is not being converted: It is always a textbox (also in the original file). The problem is that Excel 2010 added some extra formatting to allow the textbox to show equations, and it is saving both versions in the file. FlexCel is reading the oldest version available (2007) to ensure all Excel users can read the file it creates. We should modify it to read both versions and save both too, but this isn't technically simple. As said, I'll study what can be done and let you know. Right now, FlexCel is behaving in this case as if an user of Excel 2007 opened and saved the file.
Any progress on reading Excel 2010 format yet?
It is in our todo list. We are planning a new release for monday, and while I am not sure it will make it for that, we'll try it. If not, it will be in the release after monday.
There were 2 different issues in this thread (Excel 2010 equations and textboxes linked to cells).
Both of them should have been fixed in 6.7.1, released moments ago. Please check it out and let me know if there are still issues.