Topic: Change spreadsheet

Hi everyone, I would like to know how to replace the 'Excel' function with another spreadsheet because I use 'MyOffice Standard'.
Sabine

Post's attachments

Attachment icon Excel.jpg 11.92 kb, 27 downloads since 2023-09-08 

Re: Change spreadsheet

Hi Sabine,
Like you, I don't use Excel or LibreOffice Calc.
To export the contents of a tablegrid, what I do instead is

procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
  form1.tablegrid1.dbPopupMenu.Items.Find('Copy all').Click;
  openfile('C:\Program Files\Spread32\Spread32.exe');
end;

The script
1.  copies all rows in the tablegrid
2.  opens my spreadsheet software (Spread32)
3.  I then manually use ctrl+V (or right-click+paste) to copy the tablegrid contents.  If you wanted to automate this, I guess you could use something like 'AutoIt' or 'Autohotkeys' (but it's not something I do very often so it's not really worth setting up).
Regards,
Derek.

Re: Change spreadsheet

Thanks Derek it works well. I tried directly putting a 'desktop' shortcut in the program and it worked.

Re: Change spreadsheet

Do you know 'Essential Office', it's a very nice all-in-one that replaces Microsoft Office and is free.
Here is the link:
https://www.neoteo.com/essential-office … tibilidad/

Re: Change spreadsheet

Thanks Sabine,  I'll check it out.
Derek.