cell contents from different tab
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
iteh · 2019-07-30 08:29

(initially tabs and data were more, I left only those that demonstrate
the problem)

1) there are two tabs: "4" and "5"
2) on the tab "4" a lot of data (more than 3600 rows), in cell O3628
there is text and hyperlink
3) on the tab "5", the last data cells (press Ctrl End in MS Excel to
go to the last) is S278

but when we open this file in the FPSpreadsheet component, the tab "4"
is displayed normally, and on the tab "5" the last cell is not S278,
but O3628 and it incorrectly displays the URL of cell O3628 from the
tab "4".

----------------------------------------------------------------------
wp · 2019-07-30 14:48

I cannot reproduce this effect with fpspreadsheet trunk when loading
the provided file into the "spready" application. Which version of
fpspreadsheet are you using?

There is no "FPSpreadsheet component". Please be more specific. Or
provide sample code (ideally as a compilable project) which shows the
issue.

----------------------------------------------------------------------
iteh · 2019-07-30 18:22

yes, sorry, TsWorksheetGrid.

OS: OpenSUSE Leap 15.1, Lazarus 2.0.2, FPC 3.0.4

last version from https://svn.code.sf.net/p/lazarus-
ccr/svn/components/fpspreadsheet (svn) : laz_fpspreadsheet.lpk -
compile. laz_fpspreadsheet_visual.lpk - compile,
laz_fpspreadsheet_visual_dsgn.lpk - compile and install.

source: tab6-src.zip
screenshots:
tab5-ok1.png - the latest data on the tab "5" according to ms excel
(ctrl end).
tab5-ok2.png - cell O3628 on tab "5" according to ms excel
tab5-err2.png - cell O3628 which I see in the compiled program, after
opening the tab6.xlsx file and opening the tab "5".

Maybe I incorrectly load the file or select the sheet?

----------------------------------------------------------------------
wp · 2019-07-30 19:40

Please try r7089. Thanks for reporting and providing a demo project.

----------------------------------------------------------------------
iteh · 2019-07-30 19:50

the problem does not appear in r7089, thanks !