Jump to content


Photo

Adding solid cells in the table

nextgrid columns header

  • Please log in to reply
89 replies to this topic

#41 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 18 September 2016 - 11:35 PM

Hi,

1) You can use formulas. Check again this page:

http://dn.bergsoft.n...quick-start.htm

There is a section with formulas support, so you can use:
 
Cell[x, y].Text := '=SUM(A2:A6)';
Not sure if you used Excel before, it's similar in this way.

2) To avoid editing, you can try to use next property:
 
NextSheet1.Cell[0, 0].ReadOnly := True;

boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#42 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 20 September 2016 - 12:53 PM

And brother of the cursor can be changed on the arrow when you move ? ... And then the cross is not exactly )  :rolleyes:



#43 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 20 September 2016 - 05:01 PM

Hi,

You want to replace default + cursor to arrow? I will try to see how it can be done.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#44 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 20 September 2016 - 11:10 PM




Two of my program with your component.



#45 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 20 September 2016 - 11:15 PM

The biggest flaw in NextGrid is that you can not do hats for championships in NextSheet ... Brother , please make in NextGrid, opportunity unites cell .. beg .  :wub: 



#46 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 21 September 2016 - 12:34 PM

Hi,

I will write for tomorrow tutorial how you can use NextGrid6 to merge cells. It's will still be a hack, but will work.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#47 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 25 September 2016 - 10:34 AM

Hi,

I will write for tomorrow tutorial how you can use NextGrid6 to merge cells. It's will still be a hack, but will work.

Boki I have all of the work is constructed by the host component.



Please write a tutorial how to make hats for the championships on NextGrid6 ... without it everything that I'm doing looks shabby .

... Updating , updating and textbook and there is still no.  



#48 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 25 September 2016 - 10:57 AM

Here is how I have now :

----------------------------------------------------
 But how to make it :

Attached File  Clip2net_160925110136.png   611.99KB   2 downloads

Attached Files



#49 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 25 September 2016 - 05:15 PM

Hi,

Just couple of more days, I have implementing Visible feature for Cell now.

You will simply hide some cells in row and only leave one which can be header. Visible cell will simply expand over non-visible.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#50 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 25 September 2016 - 05:56 PM

Yes Bro its Best idea! Im waiting for you! Great!~

 

 

I'll give you advice ... add this update to my premium services . Thus there will be many who want to buy NextGrid6. ;)



#51 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 25 September 2016 - 06:11 PM

I hope that will be out in 1-2 days. It started working.

All what you need to do is something like:

  with NextGrid61.AddRow do
  begin
    Cells[0].AsBoolean := True;
    Cells[0].Visible := False; // <--- hide 1st cell and merge with 2nd (which is visible)
    Cells[1].AsString := 'Proba';
    Cells[1].Color := clMoneyGreen;
    Cells[2].Color := clRed;
  end;

boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#52 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 25 September 2016 - 06:22 PM

I love you Boki:) 

#53 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 27 September 2016 - 02:43 PM

Hi,

If you want, I can send you new update of v6. It's still require testing for at least couple of days, but you can at least start working.

Here is how it's look when you set Visible of some Cells to False (I have changed colors for testing).

Attached File  Windows_10_x64.jpg   40.28KB   0 downloads
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#54 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 27 September 2016 - 03:35 PM

Thank you. But I will wait 1 or 2 days as you said to be able to do it in caps NextGrid .. it is vital for me. And buying a component that I did not get what he wanted. I need to make hats in the table it is in NextGrid ...  :rolleyes: 

 

 


If it is possible then it is better to have it all together.



#55 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 27 September 2016 - 05:23 PM

Ok,

It's already working well (see attachment), but I need to solve few keyboard problems (for example key up in over invisible cell.

Attached File  full_row.jpg   39.09KB   0 downloads

Anyway, it will be fully completed in couple of days and then you can decide.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#56 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 01 October 2016 - 04:26 PM

Greetings! Please tell me how things are with the updates? .. You said 1 or 2 days)



#57 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 01 October 2016 - 05:20 PM

Hi,

I will do upload in Monday.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#58 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 03 October 2016 - 07:22 PM

Hello,

New version is out. You can download update from Members Section.

This video will demonstrate how to use this new feature:
http://www.bergsoft....lls_merging.mp4

If there are any bugs, I will fix it. It's a complicated feature.
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#59 Ltybcrf

Ltybcrf
  • Members
  • 59 posts

Posted 11 November 2016 - 10:49 PM

Hi brother! Please tell me the command. Here is a screen:

 

Attached File  a60b0-clip-7kb.png   6.55KB   0 downloads

 

 

I have to unite all the subsequent cells in that row.

I try not to get something else. Use the video as it turns out, and the cycle is not made automatically

 

It is necessary to somehow select all the cells and then write the following command:

NextGrid6.SelectedCell.Hide;

 

Which command can distinguish the cells to merge?

 

.. please tell me!



#60 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

Posted 11 November 2016 - 11:39 PM

Hi,

 

Cell where text have Index = 3. So you want to keep this cell visible.

 

But then, you want other to hide.

 

You will write something like:

 

NextGrid61.Cell[0, 4].Hide;
NextGrid61.Cell[0, 5].Hide;
...
NextGrid61.Cell[0, 18].Hide;

 

If you want, you can send me form file (pas and dfm) and I will hide them.


boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users