Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Im creating an Excel Export class that fills Excel sheets with
various values created by some construction application.
So far everything works well, but now Users would like to use sheets as proper excel sheets, so all the cells that hold calculated values are supposed to be created as such, and not just hold my calculated value.
This is to enable the user to e.g. add values and sheet automatically calculates a new sum, multiplication, or division value. I could use string to format cell, like:
mExcelSheet.Cells[iRow, iColum] = "=SUM(D1:F1)";
but thatll be harder for localization,
does anyone know how to do it without localized strings???
0 · ·