Support for single/double accounting underlines

Support for single/double accounting underlines

Posted by: yijia on 13 April 2026, 9:08 am EST

• 

  yijia

  • Post Options:
  • Link
    Copy

  Posted 13 April 2026, 9:08 am EST

  Hi, wondering if SpreadJs has support for single/double accounting underlines?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 14 April 2026, 2:41 am EST

  Hi,

  SpreadJS does support both single and double underlines.

  These are available via the GC.Spread.Sheets.TextDecorationType enumeration. Here’s a quick overview of the relevant options:

  • underline — Displays a single line below the text.

  • doubleUnderline — Displays a double line below the text, ideal for grand totals in financial reports.

  Here’s a quick code example to apply them:

  // Single underline
  activeSheet.getCell(0, 0).textDecoration(GC.Spread.Sheets.TextDecorationType.underline);
  // Double underline
  activeSheet.getCell(1, 0).textDecoration(GC.Spread.Sheets.TextDecorationType.doubleUnderline);

  You can also combine decoration types using the bitwise OR operator (|), for example, pairing an overline with an underline.

  For full details, you can refer to the official API documentation here:
  
  https://developer.mescius.com/spreadjs/api/enums/GC.Spread.Sheets.TextDecorationType

  Regards,
  
  Priyam

• 

  yijia

  • Post Options:
  • Link
    Copy

  Posted 14 April 2026, 9:05 am EST

  Hi Priyam, I specifically am referring to single/ double accounting underlines - this is different from just single / double underlining: https://a4accounting.com.au/single-accounting-underline/

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 15 April 2026, 3:01 am EST

  Hi,

  Apologies for misunderstanding the requirement.

  We have checked this, and it is currently not supported. However, it is already in our product backlog under the internal ID SJS-12519. It is expected to be released in version 19.1.0, which is tentatively planned for the end of April 2026. I will update you as soon as any information becomes available.

  Regards,
  
  Priyam

• 

  yijia

  • Post Options:
  • Link
    Copy

  Posted 21 April 2026, 1:37 pm EST

  Hi Priyam - wondering if this is still on track to be released!

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 22 April 2026, 2:31 am EST

  Hi,

  Yes, it is on track to be released with version 19.1.0 and is expected by the end of April 2026. We will update you as soon as we receive any information.

  Regards,
  
  Priyam

• 

  peter

  • Post Options:
  • Link
    Copy

  Posted 22 April 2026, 1:18 pm EST

  thanks, also looking forward to this

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 13 May 2026, 2:27 am EST

  Hi,

  The mentioned feature has been added in the latest version of SpreadJS V19.1.0. Kindly upgrade to the latest version of SpreadJS and let us know if you still face the same issue.

  You may also download the latest version using the following link: https://cdn.mescius.com/spreadjs/19.1.0/SpreadJS.Release.19.1.0.zip

  Regards,
  
  Priyam

• 

  yijia

  • Post Options:
  • Link
    Copy

  Posted 13 May 2026, 5:47 pm EST - Updated 13 May 2026, 5:52 pm EST

  Hi this is a partial fix, where single accounting underline is supported, but it is not supported for single accounting underline where the cell is centered across a range. Is it possible to prioritize this fix for single / double accounting underline when a cell is centered over a range?

  Please see repro file and image in Excel vs. SpreadJS

  

  792×272 2 KB

  

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2026, 6:27 am EST - Updated 14 May 2026, 6:32 am EST

  Hi,

  As per our understanding, when a range of cells is merged and the text is centered, applying a single accounting underline does not span the full width of the merged cells as it does in Excel. Instead, it only applies to the width of the starting cell.

  We tried to replicate the behavior with the available information but were unable to reproduce the issue. On our end, it is working as expected. Please refer to the attached image and sample.

  Image:

  Sample: Sample.zip

  To better assist you, could you please share a minimal working sample along with the steps to reproduce the behavior you observed, or modify the existing sample to demonstrate the issue? This will help us investigate the problem more thoroughly. Additionally, it would be helpful if you could provide a GIF or video illustrating the issue.

  Regards,
  
  Priyam

• 

  yijia

  • Post Options:
  • Link
    Copy

  Posted 14 May 2026, 8:52 am EST

  Hi Priyam, I am attaching the zipped test file

  There is a difference between merged & center, vs. a cell that is just centered across a selection of cells (doesn’t merge the cells)

  I have attached an Excel that has the centered across selection (note: not merged and centered)

  singleaccounting.xlsx.zip

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 15 May 2026, 1:51 am EST

  Hi Jay,

  Apologies for the inconvenience caused.

  We can replicate the behavior you mentioned on our end. We have escalated this matter with the concerned development team and will update you as soon as we get any further information from their end.

  Internal Tracking ID: SJS-34883

  We appreciate your patience in the meantime.

  Kind Regards,
  
  Chirag

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 15 June 2026, 8:23 am EST

  Hi Jay,

  The mentioned issue has been resolved in SpreadJS v19.1.2. Therefore, we recommend that you upgrade to this version to resolve the issue on your end.

  Please let us know if you encounter any further issues or require additional assistance.

  Kind Regards,
  
  Chirag