C1TrueDBGrid1 SaveExcel

C1TrueDBGrid1 SaveExcel

Posted by: s.wortmann on 21 April 2022, 5:21 am EST

• 

  s.wortmann

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 April 2022, 5:21 am EST - Updated 3 October 2022, 10:31 pm EST

  Dear everybody,

  In a C1TrueDBGrid I hid many columns, because I don’t need them in the excel file (you can see in the attached picture).

  The Excel export starts with:
  
  C1TrueDBGrid1.SaveExcel(strExcelFile, False, False)

  In the created Excelsheet I do have some strange Entries an I hope you can help me:

  Why are there hashmarks in front of the values (those are Double values).
  
  Why are there the hidden columns?

  I hope you can help me.

  Best regards
  
  Stephan

  

  716×113 6.68 KB

  

  1082×443 89.5 KB

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 22 April 2022, 3:38 am EST

  Hi Stephan,

  We could see both the issue at our end. We have reported the issues to the development team and will let you know as soon as we have an update. In the meantime, as a workaround, you can use the C1Excel to open the excel file after the export and manually do some post-processing to remove the hidden columns and fix the Format for the Double DataType cells. Kindly refer to the attached sample showing the same.

  Kind Regards,
  
  Kartik

  ExcelExportSample_TDBG.zip

  [Internal Tracking ID: C1WIN-27262]

• 

  s.wortmann

  • Post Options:
  • Link
    Copy

  Posted 22 April 2022, 7:21 am EST

  Thanks Kartik,

  will you let me know, if the problem is solved?

  Best Regards
  
  Stephan

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2022, 4:59 am EST

  Hi Stephan,

  We will let you know once the issue gets resolved by the development team. You can also refer to the ChangeLogs that come with every release to know which bugs are fixed in this release. You can find the ChangeLogs at location C:\Program Files (x86)\ComponentOne\WinForms Edition in your system.

  Best Regards,
  
  Kartik

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 28 December 2022, 9:34 am EST

  Hi Stephan,

  This issue has been fixed in the latest 2022v3 (584) release. You can either update to the latest version using the ComponentOne Control Panel OR directly install the latest C1 packages through NuGet. Links for both are given below.

  (https://www.grapecity.com/componentone/download)

  (https://www.nuget.org/packages/C1.Win.C1TrueDBGrid/4.8.20223.584)

  Kind Regards,
  
  Kartik