SpreadJs - Row height is not retained

SpreadJs - Row height is not retained

Posted by: tegbir.singh on 18 November 2020, 4:53 pm EST

• 

  tegbir.singh

  • Post Options:
  • Link
    Copy

  Posted 18 November 2020, 4:53 pm EST - Updated 3 October 2022, 1:05 am EST

  Hi,

  We are using Spread v13.1.1 for our angular application. We are facing row height issue in spreadJs.
  
  In spread, we have set the row height for particular rows (see the attachment) and created a json through workbook (code is mentioned below). After using the json, row height is not retained in spreadJs. This is working fine if create json through ExcelIO library.

  Below are details about the code for your reference.

  //creating json using excelio library (earlier code)
  
  form.Spread.SaveExcel(stream, FarPoint.Excel.ExcelSaveFlags.SaveAsViewed);
  
  GrapeCity.Spread.Sheets.License.LicenseKey =“xxxx”
  
  var importer = new Importer();
  
  var json = importer.ImportExcel(stream);
  
  result = “{"spread":” + json + “}”;

  //creating json using workbook (current code).

  form.Spread.SaveExcel(stream, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
  
  var workbook = new GrapeCity.Documents.Excel.Workbook();
  
  workbook.Open(stream);
  
  var json = workbook.ToJson();
  
  result = “{"spread":” + json + “}”;

  Please check and let us know…

  Thanks,
  
  Tegbir

  

  1104×421 39.5 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2020, 7:24 pm EST

  Hi Tegbir,

  Could please share a small sample that replicates the issue? also please provide the information about the SpreadJS build version so that we could investigate the issue and assist you accordingly.

  Regards
  
  Avinash

• 

  tegbir.singh

  • Post Options:
  • Link
    Copy

  Posted 1 December 2020, 2:46 pm EST

  This issue has been resolved by doing the changes in the frontend logic. Thanks for your reply.