Relative table column references work differently than excel

Relative table column references work differently than excel

Posted by: jeff on 6 May 2020, 7:32 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 May 2020, 7:32 pm EST - Updated 3 October 2022, 10:22 am EST

  Relative table column references work differently than excel.

  1. Click an adjacent row in a table while in cell edit mode gives the A1 notion not column reference. Clicking should [@olumn1]

  2. The whole col is highlighted in Spreadjs. Excel only does the relative row.

  3. Excel by default populates the entire column with the relative references.

  

  1280×490 69.6 KB

  

  1408×312 17.8 KB

  

  1596×188 15.9 KB

  

  1596×188 15.9 KB

  

  1370×652 84.2 KB

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 6 May 2020, 7:33 pm EST

  Duplicate of https://www.grapecity.com/forums/spread-sheets/relative-table-column-refe

  Closing.