Recent

Author Topic: FPSpreadSheet Grid [6258] Select merged cells.  (Read 3683 times)

wofs

  • New Member
  • *
  • Posts: 16
FPSpreadSheet Grid [6258] Select merged cells.
« on: March 31, 2018, 09:26:17 pm »
Hello!
FPSpreadSheet rev 6258
If the document has merged cells, their selection is incorrect.
I attach a test document and highlight behavior in FPSpreadSheet and LibreOffice Calc.
« Last Edit: April 01, 2018, 01:50:14 pm by wofs »
-----
Best Regards, Alexander D.

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: FPSpreadSheet Grid [6285] Select merged cells.
« Reply #1 on: March 31, 2018, 09:55:56 pm »
What do you mean? I don't see any difference. And even if there is something different the grid of fpspreadsheet is not intended to mimic every aspect of Excel or Calc.

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: FPSpreadSheet Grid [6285] Select merged cells.
« Reply #2 on: March 31, 2018, 10:56:34 pm »
What do you mean? I don't see any difference.

Take a look on the Name Box on left upper corner of the image.
On FPSpreadSheet, when he clicks on the merged cells, the information that appears on Name Box is B5, C5 and D5.
And when he clicks on the same three cells on LibreOffice Calc, the information that appears on Name Box is only B5.

wofs

  • New Member
  • *
  • Posts: 16
Re: FPSpreadSheet Grid [6285] Select merged cells.
« Reply #3 on: April 01, 2018, 07:46:05 am »
Take a look on the Name Box on left upper corner of the image.
Thank you for clarifying.

Quote from: wp
And even if there is something different the grid of fpspreadsheet is not intended to mimic every aspect of Excel or Calc.
Sorry, I agree - it was necessary to describe the behavior.
I didn't mean the behavior of the grid. Above absolutely correctly described behavior. This is a problem if you use the FPSpreadSheet grid as the format wizard when importing tables. Data resides in a different address than indicated by their grid.
-----
Best Regards, Alexander D.

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: FPSpreadSheet Grid [6285] Select merged cells.
« Reply #4 on: April 01, 2018, 12:56:42 pm »
Please test r6284.

wofs

  • New Member
  • *
  • Posts: 16
Re: FPSpreadSheet Grid [6258] Select merged cells.
« Reply #5 on: April 01, 2018, 02:19:13 pm »
Please test r6284.
The indicator is working, but there is still a problem in the column definition (sWorksheetGrid1.Col).

Propose the allocation of a merged cell always to provide basic.
Please check my decision.
« Last Edit: April 01, 2018, 02:50:22 pm by wofs »
-----
Best Regards, Alexander D.

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: FPSpreadSheet Grid [6258] Select merged cells.
« Reply #6 on: April 01, 2018, 03:43:22 pm »
Applied. Thanks.

 

TinyPortal © 2005-2018