SpreadJs border problem, Lines and color are overlapped

SpreadJs border problem, Lines and color are overlapped

Posted by: gagandeep.singh on 3 August 2022, 1:35 am EST

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Posted 3 August 2022, 1:35 am EST

  Hi there,
  
  I am using spreadJs 15.0.3 trial right now for proof of concept, but I have problem with this section in format cell where Line and color are overlapped as you can see in screenshot. How can I fix it?
  
  Regards
  Gagan
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 3 August 2022, 5:53 pm EST

  Hi Gagandeep,
  
  I was unable to replicate the issue at my end with the latest version of SpreadJS(V15.1.4) and also with the SpreadJS Version that you have mentioned i.e., 15.0.3.
  
  Please find the attached sample of SpredJS(v15.0.3) that we have used for testing.
  
  We tested with the latest version of SpreadJS on hosted designer: https://www.grapecity.com/spreadjs/designer/index.html
  
  Also, please find the attached gif that shows the steps we have performed. Please let us know if we are missing any step.
  
  If the issue still persists for you, please share the following details so that we can test again on a similar environment:
  
  1. working sample(also mention the steps)
  
  2. Operating System Info
  
  3. Browser Version
  
  4. Hardware configuration
  
  Regards
  Ankit
  
  SpreadJSV15.0.3.zip
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 3 August 2022, 5:54 pm EST

  Steps I have followed:
  
  
• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Replied 4 August 2022, 1:51 am EST

  Thanks Ankit, for getting back to me. I was doing some css changes of gc-line-editor class that's why it has the problem. Now I have 2 questions
  
  1) My column headers are numeric, I did like this
  sheet.options.colHeaderAutoText = GC.Spread.Sheets.HeaderAutoText.numbers;
  But when I am trying to find the element using FIND it came back with Alphabetic result
  as you can see in screen shot.
  2) In my application I don't want replace in Find and Replace, how can I achieve it?
  
  Thanks
  Gagan
• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Replied 4 August 2022, 1:51 am EST

  
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 7 August 2022, 2:44 pm EST

  Hi Gagan,
  
  1. Regarding the first issue you have mentioned, I have checked at my end by changing the reference style to R1C1, and I was able to see that the cell reference always remains "A1". I have forwarded this to the dev team for further investigation. The internal id for this is: SJS-14158. I will let you know when I have an update for you.
  
  2. You can remove the find/replace options from the default config and then set the default config using setConfig() method.
  
  For example, you can refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/BGXauJsbO020CifRYJzgNw/
  
  API Docs:
  
  Designer Customizations: https://www.grapecity.com/spreadjs/docs/latest/online/customizations.html
  
  DefaultConfig: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJSDesigner~GC.Spread.Sheets.Designer.DefaultConfig.html
  
  setConfig method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJSDesigner~GC.Spread.Sheets.Designer.Designer~setConfig.html
  
  Regards
  Ankit
• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Replied 8 August 2022, 1:46 am EST

  Thank you Ankit, I really appreciate that.
  
  How can I change Alphabetic to numeric column when I do find as I mentioned in attached screenshot above
  
  Regards
  Gagandeep
• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Replied 8 August 2022, 2:16 am EST

  Hey Ankit,
  
  Although I removed the Replace and other functionalities like Go to Special and replace. But when I click on Find, I can still see there is tab for Replace. As you can see in below Screen Shot
  
  Regards
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Replied 8 August 2022, 3:31 pm EST

  Hi Gagandeep,
  
  You can change the Alphabetic to numeric column by going to the Settings-> Sheet Settings -> Headers -> Column Header Auto Text and change the type to numbers.
  
  Regarding the second issue, I couldn't see the find and replace dialog on clicking the Find. Could you please help me with that? Could you please share the steps you are performing? In the sample that I earlier shared with you, clicking the Find option won't open the Find/Replace dialog.
  
  Regards
  Ankit