Like sheet excel

Post Reply
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Like sheet excel

Post by Silvio.Falconi »

where is this sample ?

Image
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: Like sheet excel

Post by nageswaragunupudi »

Code: Select all | Expand


#include "fivewin.ch"

function Main()

   local oDlg, oBrw, oFont
   local aData

   aData    := Array( 50 )
   AEval( aData, { |u,i| aData[ i ] := Array( 20 ) } )

   DEFINE FONT oFont NAME "CALIBRI" SIZE 0,-14
   DEFINE DIALOG oDlg SIZE 860,400 PIXEL TRUEPIXEL ;
      FONT oFont ;
      TITLE FWVERSION + " : Excel Sheet"

   @ 60,20 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
      DATASOURCE aData AUTOCOLS ;
      CELL LINES NOBORDER FASTEDIT STYLE 2015

   WITH OBJECT oBrw
      :nEditTypes       := EDIT_GET
      :nColDividerStyle := ;
      :nRowDividerStyle := LINESTYLE_LIGHTGRAY
      :nMarqueeStyle    := MARQSTYLE_SOLIDCELL
      //
      :bRecSelData      := { |brw| brw:KeyNo }
      :nRecSelWidth     := "99"
      :SetRecSelBmp( 0 )
      :nRecSelHeadBmpNo := { 20, 16, { { "L", CLR_HGRAY, 0, 16, 16, 15, 3, 0, 15, 15, 15 } } }
      //
      :nWidths    := 60
      :CreateFromCode()
   END

   @ 20,20 SAY 'Like Excel Sheet' ;
      SIZE oDlg:nWidth - 40, 20 PIXEL OF oDlg CENTER COLOR CLR_RED,oDlg:nClrPane

   ACTIVATE DIALOG oDlg CENTERED
   RELEASE FONT oFont

return nil
Regards

G. N. Rao.
Hyderabad, India
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: Like sheet excel

Post by Silvio.Falconi »

thanks rao
On oldest Clipper test ( Clipper 5.01 - TBrowse Spreadsheet) I found the possibility to simulate a excel table
on a folder there was the table with numbers and on the other folder there was another table with functions
if you want I can send you this test to see if you can insert this possibility
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: Like sheet excel

Post by nageswaragunupudi »

ok
Regards

G. N. Rao.
Hyderabad, India
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: Like sheet excel

Post by Silvio.Falconi »

I made a small test inserting the two dbfs

Table folder

Image


Formulas folder

Image

the cols header are wrongs
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: Like sheet excel

Post by Silvio.Falconi »

Mr Rao
do You have found time to see that I send you ( spreadsheet) ?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: Like sheet excel

Post by Silvio.Falconi »

Image

look in your mail pls
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: Like sheet excel

Post by nageswaragunupudi »

Mr Silvio

The above sample demonstrates how to make xbrowse to look like an excel sheet but not to work like full excel and FWH does not have any plans to produce an Excel like program.

I would be glad to help with your work, but at this time I am extremely busy with some FWH maintenance work and unable to take out any time for this work. Please bear with me for a few more days and hope you understand.
Regards

G. N. Rao.
Hyderabad, India
User avatar
Silvio.Falconi
Posts: 7136
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: Like sheet excel

Post by Silvio.Falconi »

thanks Mr Nages.

I Know it cannot work as excel sheet ....

because it use a function called Calculus() calc all formulas there are on second aray but this function make only (/+-*). and only from A to F

Many year ago there was a Class ( at that time it did not exist xbrowse but only wbrowse) called FileXls but was not the class filexls you can downlooad from Linares 's Archive

that class I mean created excel like paper with function and operations but that procedure was several dollars to purchase

perhaps someone have that procedure ...
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Post Reply