Recent

Author Topic: cell contents from different tab  (Read 323 times)

iteh

  • New Member
  • *
  • Posts: 33
cell contents from different tab
« on: July 30, 2019, 10:29:18 am »
(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".
« Last Edit: July 30, 2019, 10:44:05 am by iteh »

wp

  • Hero Member
  • *****
  • Posts: 6312
Re: cell contents from different tab
« Reply #1 on: July 30, 2019, 04:48:26 pm »
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.
Lazarus trunk / fpc 3.0.4 / all 32-bit on Win-10

iteh

  • New Member
  • *
  • Posts: 33
Re: cell contents from different tab
« Reply #2 on: July 30, 2019, 08:22:49 pm »
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

  • Hero Member
  • *****
  • Posts: 6312
Re: cell contents from different tab
« Reply #3 on: July 30, 2019, 09:40:16 pm »
Please try r7089. Thanks for reporting and providing a demo project.
Lazarus trunk / fpc 3.0.4 / all 32-bit on Win-10

iteh

  • New Member
  • *
  • Posts: 33
Re: cell contents from different tab
« Reply #4 on: July 30, 2019, 09:50:06 pm »
the problem does not appear in r7089, thanks !
« Last Edit: July 30, 2019, 09:53:10 pm by iteh »