C1Excel File Error

C1Excel File Error

Posted by: dennis on 9 August 2020, 7:16 pm EST

• 

  dennis

  • Post Options:
  • Link
    Copy

  Posted 9 August 2020, 7:16 pm EST

  Hi,
  
  I used C1Excel to create a xlsx File, and edit it by MS Office. After MS Office edited, I used C1Excel to read the value of the file, but it give me the format!!.
  
  1. Use XLSheet.Item(1,1).Value= "Test123" to Create a file
  2. MS Office edit B2 of the file to "Test234
  3. Use A=XLSheet.Item(1,1).Value , but A="{\rtf1{\fonttbl{\f0\fnil Arial;}............."
  
  Environment
  Windows 7, Vistual studio 2017 (VB.Net), Microsoft Office 2007, C1Excel 2020v1
• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Replied 10 August 2020, 4:10 pm EST

  Hi,
  
  I could not observe the value in rich text format using the above steps. Please see the attached sample for the same.
  
  C1Excel_SheetValue.zip
  
  Also, note that this can happen when a cell text is partially formatted in Excel (for instance, making only 'Test' part of 'Test234' bold). To preserve the formatting, Excel stores the value (with formatting) in rich text format.
  
  From the partial cell text you have posted ("{\rtf1{\fonttbl{\f0\fnil Arial;}............."), it does seem like part of the text is bold. Please check if that's the case.
  
  Regards,
  Jitender
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 10 August 2020, 7:44 pm EST

  Hi,
  
  The issue is not reproducible at our end. Please try to run the attached application and share if you can observe the issue with it?
  
  Regards,
  Test_C1Excel.zip
• 

  dennis

  • Post Options:
  • Link
    Copy

  Replied 10 August 2020, 8:11 pm EST

  Hi, Ruchir,
  
  It is the same result by Test_C1Excel.zip.
  
  Export File: ExcelExport-NoEdit.xlsx
  Modify File: ExcelExport-Edit-byExcel2007.xlsx
  Import Result: Capture.JPG
  
  https://drive.google.com/file/d/124zcBGq1Wo4irzW8DR2BQY737oAyR5kY/view?usp=sharing
  
  Regards,
  Dennis
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 13 August 2020, 5:33 am EST

  Hi Dennis,
  
  I have escalated the issue for further investigation [ID: 457447] and will keep you updated.
  
  Regards,

• Marked as Answer

  

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 14 August 2020, 3:39 am EST

  Hi,
  
  The team has confirmed that its by design. To get your expected output, use the Text property instead, as follows:

  Dim text = book.Sheets(0).Item(1, 1).Text

  Thanks,