Imported Excel has Formula Errors | Version : 16.0.7

Imported Excel has Formula Errors | Version : 16.0.7

Posted by: rssabu on 6 June 2023, 6:13 am EST

• 

  rssabu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 June 2023, 6:13 am EST - Updated 8 June 2023, 2:37 am EST

  Hi
  
  Formula not working as expected in the imported excel,

  I have attached the sample excel and images for your understanding

  Sheet Name : Evaluation-Bewertung ONE MPA

  =COUNTIF(BM36:CE36,“>-”) has problem which is not working properly in spread JS

  

  959×1024 59.5 KB

  

  2450×192 57.5 KB

  

  914×978 58 KB

  

  2328×220 63.3 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 7 June 2023, 1:49 pm EST

  Hi,

  Thanks for sharing the excel file with us. I could see that the formulas for some cells are not correctly calculated. However, for further investigation, we would need the sheet to be unprotected. Currently, the sheet “Evaluation-Bewertung ONE MPA” is protected.

  I could also see that you have created a new ticket on our private portal for which the ticket id is: CAS-41021-H1J0K9. Could you kindly share the password of the sheet on the private portal or share the unprotected excel file so that we could investigate the issue at our end?

  We have already replied on the ticket raised at the private portal.

  Looking forward to hear from you.

  Regards,

  Ankit

• 

  rssabu

  • Post Options:
  • Link
    Copy

  Posted 8 June 2023, 2:32 am EST - Updated 8 June 2023, 2:33 am EST

  Hi

  We will continue in private portal, if possible , kindly delete this post

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2023, 6:08 am EST

  Hi,

  I have removed attachment (excel file) from the first post. However, I have kept this Forum Post for tracking purposes. We have already responded to the ticket on the private portal with tracking id: CAS-41021-H1J0K9.

  Further all the communication regarding the case will be updated on the private portal only.

  Regards,

  Ankit