Is possible change checkbox's cell type's value?

Is possible change checkbox's cell type's value?

Posted by: gssmis on 8 September 2017, 12:55 am EST

• 

  gssmis

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 12:55 am EST

  Hi,
  
  I assign cell’s type to checkbox .
  
  I checked the checkbox, the export file’s cell will show TRUE.
  
  May I change the default checkbox’s value from TRUE to others?
  
  Thanks.

• 

  kevinashley

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  If you mean the text that is displayed by the check box then the following code can be used to change it:

  var cellType1 = new GcSpread.Sheets.CheckBoxCellType();
  cellType1.textTrue("correct");
  

  Let me know if that is what you are looking for.

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  KevinAshley’s solution seems to be correct. Let us know if you are looking for something else.

  Thanks,
  
  Reeva

• 

  gssmis

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Thanks for reply.
  
  I change cell type to CheckBoxCellType.
  
  Then click the checkbox that the checkbox checked.
  
  And post spreadjs json string to ExcelIO API to Export Excel File.
  
  The exported excel’s checkbox will become TRUE.
  
  Is possible to change the CheckBoxCellType’s cell default true value to others? like V or Y ?
  
  Thanks.

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  This is the design behavior in case of Exporting to excel that it will exported a boolean “TRUE” OR “FALSE” and not as displayed text.

  Thanks,
  
  Reeva

• 

  gssmis

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hi Reeva,
  
  Is possible let us to change the value or assing the bool value to other word?

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  Its not possible to change exported value anyhow or assign some new value to it.

  We regret the inconvenience caused.

  Thanks,
  
  Reeva

• 

  gssmis

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hi Reeva,
  
  OK! Thanks for reply.

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  We are glad to know that your issue is resolved.

  Thanks,
  
  Reeva

• 

  samuelstein

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  i also have the problem, that i want to have as cell value for checkbox type 0 and 1. Is that possible?

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:55 am EST

  Hello,

  This is directly not possible. You need to create a CustomCheckBoxCellType and override it’s format and parse it to desired values.

  Please try creating a sample and let us know if you need any further help.

  Thanks,
  
  Reeva

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 28 September 2017, 3:34 pm EST

  Hello,

  You can download the attached working sample for the requested functionality:-

  https://www.dropbox.com/preview/Spread_Samples/SpreadJS_CheckBoxCellType_01(1).zip?role=personal

  Hope it helps.

  Thanks,
  
  Reeva

• 

  stein

  • Post Options:
  • Link
    Copy

  Posted 15 November 2017, 8:47 pm EST

  hello reeva,
  
  the dropbox link isn’t working. can you check it please?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 December 2017, 9:17 pm EST

  Hello,

  I have attached the sample application which was provided through the dropbox. Please download the same and check.

  Thanks,
  
  Deepak SharmaSpreadJS_CheckBoxCellType_01(1).zip