FPSpreadSheet Grid [6258] Select merged cells.
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
wofs · 2018-03-31 19:26

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.

----------------------------------------------------------------------
wp · 2018-03-31 19:55

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 · 2018-03-31 20:56

Quote from: wp on March 31, 2018, 09:55:56 pmWhat 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 · 2018-04-01 05:46

Quote from: valdir.marcos on March 31, 2018, 10:56:34 pmTake a look on
the Name Box on left upper corner of the image.
Thank you for clarifying.

Quote from: wpAnd 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.

----------------------------------------------------------------------
wp · 2018-04-01 10:56

Please test r6284.

----------------------------------------------------------------------
wofs · 2018-04-01 12:19

Quote from: wp on April 01, 2018, 12:56:42 pmPlease 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.

----------------------------------------------------------------------
wp · 2018-04-01 13:43

Applied. Thanks.