Ho i can link tabwork with sheet on document
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
eldonfsr · 2017-10-06 22:56

Hello friends i can open a workfile but i dont get when i change of
tab to the sheet in document still on the same sheet, i can open the
example come with pfspread ask me for Tfonstyleaction unit i dont
found this file on source code, home can help me thanks.
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  if
Odlg.Execute then  begin     sWorkbookSource1.FileName
:=ODLG.FileName;     
 sworksheetGrid1.WorkbookSource.FileName:=ODLG.FileName;  if
sworksheetGrid1.Visible = false then sworksheetGrid1.Visible:=true;  
 FExcFile.Text :=oDlg.FileName;          end;

----------------------------------------------------------------------
wp · 2017-10-07 08:33

Sorry, I don't understand. Please post your question in your native
language, maybe somebody else can translate it for me.

TsFontStyleAction is in unit fspActions.

----------------------------------------------------------------------
eldonfsr · 2017-10-07 19:23

well thanks for your replay

after work some time with this packages i got works for me what i do
and what i understand is.

1.-  Workseetbook must be a put it in the component wsworkseet and
wstabworksheet
      at property workbooksource
      reference to workbook
2.- When you open a file we need to open like this
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 ODlg.Filter:='All spreadsheet files|*.xls;*.xlsx;*.ods;*.csv|All
Excel files (*.xls, *.xlsx)|*.xls;*.xlsx|Excel XML spreadsheet
(*.xlsx)|*.xlsx|Excel 97-2003 spreadsheets (*.xls)|*.xls|Excel 5
spreadsheet (*.xls)|*.xls|Excel 2.1 spreadsheets
(*.xls)|*.xls|LibreOffice/OpenOffice spreadsheet (*.ods)|*.ods|Comma-
delimited files (*.csv)|*.csv';  sWorkbookSB.AutoDetectFormat :=
true;  sWorkbookSB.AutoDetectFormat := true;  if Odlg.Execute then  
begin        sWorkbookSB.FileName :=ODLG.FileName;     
 sworksheetGrid1.WorkbookSource.FileName:=sWorkbookSB.FileName;   if
sworksheetGrid1.Visible = false then sworksheetGrid1.Visible:=true;  
 FExcFile.Text :=oDlg.FileName;  end;       first assign the file to
open to the workbook
second assign the file workbook.filename to worksheet

this way all work fine
sorry but how i can't open the test file i made some mistakes.

thanks for you help.

----------------------------------------------------------------------
wp · 2017-10-07 21:06

Quote from: eldonfsr on October 07, 2017, 09:23:32 pmCode: Pascal
 [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i      
 sWorkbookSB.FileName :=ODLG.FileName;     
 sworksheetGrid1.WorkbookSource.FileName:=sWorkbookSB.FileName;
One time is enough... You probably did not select the fileformat to be
loaded and you probably forgot to add the unit with the file
reader/writer to "uses" (or: use unit fpsAllFormats).

In the attachment there is a simple demo which illustrates how to load
a LibreOffice test file into the grid. All required parameters are set
here in code to show you what you must do. Of course you can set these
parameters also in the Object Inspector at designtime.