"4D View Pro License required", but I have a license...

[eachilgers via 4D_Tech]

Hi Koen, 

thanks for your time to answer !

> Hi Ernie,
> 
> Just a wild guess. Could it be the current user/group doesn't have access to 
> the 4D View Pro plugin in your converted db?
You were correct, this part of the conversion process has eluded me completely. 
I need to read up on this part. 

Have to figure out how this works, because after allowing the ‘designer’ (me) 
access to the 4D View Pro plugin, (Users & Groups)
the expected variable line-height did not manifest itself, however the listbox 
DID display the information. 

Greetings

ernie hilgers(aruba)


> 
> 
>> Op 13 apr. 2021, om 16:54 heeft eachilgers via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> het volgende geschreven:
>> 
>> Mac, os X 10.13.6  4D v17.5 (with 4D View Pro license)
>> Took a v15 program and upgraded to v17 and wanted to implement in an array 
>> based listbox the optional “variable rowheigth’ 
>> 
>> I have the required 4D View Pro license and have successfully created other 
>> 4d solutions using Array based Listboxes with variable rowheight. 
>> 
>> I already replaced the array based listbox in the converted V15 to v17 
>> layout but get the same message. 
>> As long as I don’t tick the -variable rowheight- the listbox functions 
>> normal.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: "4D View Pro License required", but I have a license...

[Koen Van Hooreweghe via 4D_Tech]

Hi Ernie,

Just a wild guess. Could it be the current user/group doesn't have access to 
the 4D View Pro plugin in your converted db?

HTH
Koen

> Op 13 apr. 2021, om 16:54 heeft eachilgers via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> Mac, os X 10.13.6  4D v17.5 (with 4D View Pro license)
> Took a v15 program and upgraded to v17 and wanted to implement in an array 
> based listbox the optional “variable rowheigth’ 
> 
> I have the required 4D View Pro license and have successfully created other 
> 4d solutions using Array based Listboxes with variable rowheight. 
> 
> I already replaced the array based listbox in the converted V15 to v17 layout 
> but get the same message. 
> As long as I don’t tick the -variable rowheight- the listbox functions normal.
> 

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

"4D View Pro License required", but I have a license...

[eachilgers via 4D_Tech]

Hi All, 

Mac, os X 10.13.6  4D v17.5 (with 4D View Pro license)
Took a v15 program and upgraded to v17 and wanted to implement in an array 
based listbox the optional “variable rowheigth’ 

I have the required 4D View Pro license and have successfully created other 4d 
solutions using Array based Listboxes with variable rowheight. 

I already replaced the array based listbox in the converted V15 to v17 layout 
but get the same message. 
As long as I don’t tick the -variable rowheight- the listbox functions normal.

What is it that I forget or miss ???

ernie hilgers(aruba)
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View Pro question

[Peter Bozek via 4D_Tech]

Or rather, two: I play with conversion of 4D View to 4D View pro, and while
it seems it goes OK, I run into one problem: in 4D View it was to possible
to set column headers with PV SET COLUMN HEADER call. I did not found the
way how to set column headers in View Pro, and did not found a way how to
do that through UI, but converted areas have renamed column headers, so it
is possible.

One way that should work is to manipulate view pro object properties. But
call Import from / Export to object seems to be quite slow, so maybe there
is a better way?

And second question: as View Pro is extended LB area, is that posiible to
use LB calls to manipulate View Pro area? If yes, in what part of
documentation I can find which calls work?

Regards


--

Peter Bozek
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

I found a few knowledge base tips regarding the use of JavaScript to
manipulate SpreadJS (the backbone of View Pro) 
https://kb.4d.com/assetid=78395 for example.

I also found the following on the SpreadJS website.

 var spread =
GC.Spread.Sheets.findControl(document.getElementById('ss'));
var sheet = spread.getActiveSheet();
sheet.options.protectionOptions = {
  allowSelectLockedCells: true, 
  allowSelectUnlockedCells: true,
  allowSort: false 
};
var option = sheet.options.protectionOptions;
   console.log(JSON.stringify(option, null, 2));

I'm going to see if I can figure out how to set this from within 4D.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[John DeSoi via 4D_Tech]

With 4D 18 zip commands and the XML parser, Excel integration is easier than 
ever. It took very little time to convert CSV only import procedures to also 
support direct from Excel (xlsx) import.

John DeSoi, Ph.D.


> On Jan 30, 2020, at 11:40 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> I'll see if I can figure out in the file structure where the protection
>> info
>> is stored and see if I can do anything with it.  I would rather avoid a
>> separate plugin for this one issue.  View Pro is somewhat surprisingly
>> working very well for what I need.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Douglas von Roeder via 4D_Tech]

Scott:

Good luck with that. Let us know how it turns out.

--
Douglas von Roeder
949-910-4084


On Mon, Jan 27, 2020 at 9:34 PM Scott Staley via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Doug,
>
> Thanks for the advice.  I've used excel since it was created back in about
> 1984/85 but wasn't familiar with the underlying file structure of a current
> excel file.  Just opened one with BBEdit.  A lot more to it than I
> thought.
> I'll see if I can figure out in the file structure where the protection
> info
> is stored and see if I can do anything with it.  I would rather avoid a
> separate plugin for this one issue.  View Pro is somewhat surprisingly
> working very well for what I need.
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

Doug,

Thanks for the advice.  I've used excel since it was created back in about
1984/85 but wasn't familiar with the underlying file structure of a current
excel file.  Just opened one with BBEdit.  A lot more to it than I thought. 
I'll see if I can figure out in the file structure where the protection info
is stored and see if I can do anything with it.  I would rather avoid a
separate plugin for this one issue.  View Pro is somewhat surprisingly
working very well for what I need.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro - How to protect a sheet

[Douglas von Roeder via 4D_Tech]

Scott:

The Excel plugin from Pluggers has a command *xlSheetSetProtected* which
you could use to update the workbook after it’s been created using 4D VP.

As an alternative, an Excel workbook is a handful of files bundled up in a
folder. You might be able to do a diff on a protected workbook vs one that
is not protected and then write some code to change the value. It most
likely that you can’t change the value to not-protected but you *might* be
able to get away with changing the value to protected.

--
Douglas von Roeder
949-910-4084


On Mon, Jan 27, 2020 at 4:52 PM Scott Staley via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> The subject pretty much says it all.  Anyone know how to tell View Pro to
> programmatically protect a sheet.
>
> fyi... I basically have an excel template that I import into View Pro and
> then populate with data and save it back as an excel file.  The excel file
> is then given to others that populate other parts of the sheet.  I would
> like to turn the sheet protection on so that the data populated by 4D and
> any other protected cells are not accidentally modified.  If I protect the
> sheet in excel, than I can't use 4D to populate the protected cells.  I
> generate several hundred files so I don't want to do it manually.
>
> I'm using 4D v17 R6
>
> Thanks in advance for any suggestions...
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

The subject pretty much says it all.  Anyone know how to tell View Pro to
programmatically protect a sheet.

fyi... I basically have an excel template that I import into View Pro and
then populate with data and save it back as an excel file.  The excel file
is then given to others that populate other parts of the sheet.  I would
like to turn the sheet protection on so that the data populated by 4D and
any other protected cells are not accidentally modified.  If I protect the
sheet in excel, than I can't use 4D to populate the protected cells.  I
generate several hundred files so I don't want to do it manually.

I'm using 4D v17 R6

Thanks in advance for any suggestions...



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro: Setting column widths

[Jeremy French via 4D_Tech]

Hi Pat,

When there is no 4D command to do something in 4D Write Pro, try javascript. 

I suggest using an anomymous javascript function.

Build your javascript code using a 4D Object with the “New formula” command.

The basic shell — for an anonymous javascript function in 4D code — is the 
following 4-lines:

—
$js:=New object("val";"";"add";New formula(This.val:=This.val+$1))

$js.add("(function(){“)

// Your javascript code will go between these 2-lines: immediately above and 
below this comment.

$js.add("})();")

$t:=WA Evaluate JavaScript(*;$objName_vp_t;$js.val;Is text)
—

You then add as many “js.add(“”) lines as necessary to write javascript to 
accomplish the spread sheet behavior you want.

Here’s how I set a column width to a specific size. The size is in points.

—
  // local
C_OBJECT($js)
C_TEXT($t)

  // parameter
C_TEXT($1;$objName_vp_t)  // write pro view object name
C_LONGINT($2;$column_number_i)  // column number
C_LONGINT($3;$column_width_i)  // column width (in points)

$objName_vp_t:=$1
$column_number_i:=$2
$column_width_i:=$3

$js:=New object("val";"";"add";New formula(This.val:=This.val+$1))

$js.add("(function(){")
$js.add("var sheet = Utils.currentSheet;")
$js.add("sheet.setColumnWidth("+String($column_number_i)+", 
"+String($column_width_i)+",GC.Spread.Sheets.SheetArea.viewport);")
$js.add("})();")

$t:=WA Evaluate JavaScript(*;$objName_vp_t;$js.val;Is text)
—

Details on “setColumnWidth” are at:

https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html 
<https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html>

Best regards,
Jeremy



> On May 24, 2019, at 5:04 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> How do you set a column width (via code) in View Pro?

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

View Pro: Setting column widths

[Pat Bensky via 4D_Tech]

How do you set a column width (via code) in View Pro?
There doesn't appear to be a VP function to do this, and I am having
trouble getting a SpreadJS function to work ... this is my code to set
column 0 to 60mm:

$indivSheet.data.dataTable[*"0"*].width:=*New object*  // col

$indivSheet.data.dataTable["0"].width.setColumnWidth:="60mm"


Also tried:

$indivSheet.data.dataTable["0"][*"0"*].width:=*New object*  // col

$indivSheet.data.dataTable["0"]["0"].width.setColumnWidth:="60mm"


.. and a few other variations. But nothing works!


Any idea what I am doing wrong?


PB

-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View Pro Save Image of Current Sheet ?

[Allan Udy via 4D_Tech]

The 4D Tech Tip  (https://kb.4d.com/assetid=78210) showing how to use WA 
Evaluate JavaScript to save an image of a current 4DViewPro area is 
handy, but it appears that it only saves the current Viewport, not the 
whole sheet.


Is anyone here capable enough with the use of WA Evaluate JavaScript and 
the Spreadjs documentation to help me work out how to save the entire sheet?


While I've had quite a bit of luck extending the functionality of 4D 
View Pro at this early stage by using WA Evaluate JavaScript, this is 
starting to stetch my limits a bit too far  ;-)


Cheers,
Allan Udy

Golden Micro Solutions Ltd, Blenheim, New Zealand
http://www.golden.co.nz


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D View Pro (How to set the"options.autoFitType" property?)

[Keisuke Miyako via 4D_Tech]

the GC documentation has a search box

look for "autoFitType"

yields

https://help.grapecity.com/spread/SpreadSheets11/webframe.html#a2sheetselement.html

https://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.AutoFitType.html

and other pages.

2019/04/27 8:51、Jeremy French via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

Documentation at:
https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View Pro (How to set the"options.autoFitType" property?)

[Jeremy French via 4D_Tech]

How do I set the “options.autoFitT” type property?

I am using the command "WA Evaluate JavaScript” to access more features of 4D 
View Pro (which uses SpreadJS from GrapeCity.)

When I invoke “activeSheet.autoFitColumn”, I would like to **include** column 
header text for column resizing (as well as text in the column’s data).

The “options.autoFitType" property is mentioned in the documentation for "Using 
Automatic Fit". But where do I find the documentation on how to set the 
“options.autoFitType" property?

Documentation at:
https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html

Using:
4D v17R4 (release).

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D View Pro question

[Jeremy Roussak via 4D_Tech]

Tai,

That is exactly what I was asking. So there is no “New Offscreen VP Object” 
command. I’ll follow your suggestion; thanks.

Jeremy


> On 16 Apr 2019, at 23:14, Tai Bui  wrote:
> 
> Hi,
>  
> The VP Area is only available as a form object at the moment.
>  
> If you mean how do you do this as an offscreen area you would probably have 
> to build yourself a form that opens hidden from view and process your excel 
> file in the VP Area then close the form when complete.
>  
> Best Regards,
> -Tai B.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D View Pro question

[Tai Bui via 4D_Tech]

Hi,

The VP Area is only available as a form object at the moment.

If you mean how do you do this as an offscreen area you would probably have to 
build yourself a form that opens hidden from view and process your excel file 
in the VP Area then close the form when complete.

Best Regards,
-Tai B.



From: Jeremy Roussak 
Sent: Tuesday, April 16, 2019 1:52 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>; Tai Bui 
Subject: RE: 4D View Pro question

Thanks - that will read the Excel document; but how do I create the VP area?
On 16 Apr 2019, 21:14 +0100, Tai Bui mailto:t...@4d.com>>, wrote:

Hi,

It should be possible with the VP IMPORT DOCUMENT command
https://doc.4d.com/4Dv17R4/4D/17-R4/VP-IMPORT-DOCUMENT.301-4026489.en.html

The command should be able to import your .xlsx format Excel File into a 4D VP 
area.

Best Regards,
-Tai B.



Tai Bui
Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Téléphone : +1-408-557-4600
Standard : +1-408-557-4600
Fax : +1-408-271-5080
Email : t...@4d.com<mailto:t...@4d.com>
Web : www.4d.com<http://www.4d.com>





-Original Message-
From: 4D_Tech 
<4d_tech-boun...@lists.4d.com<mailto:4d_tech-boun...@lists.4d.com>> On Behalf 
Of Jeremy Roussak via 4D_Tech
Sent: Tuesday, April 16, 2019 12:07 PM
To: 4D iNug Technical <4d_tech@lists.4D.com<mailto:4d_tech@lists.4D.com>>
Cc: Jeremy Roussak mailto:j...@mac.com>>
Subject: 4D View Pro question

Sorry if this is a silly, or trivial, question.

I’m using V17R4.

I’d like to load an Excel document and pick bits out of it. I don’t need or 
want to display any of it. I don’t have any form active.

How do I create a VP area and load the document into it?

Jeremy

**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D View Pro question

[Jeremy Roussak via 4D_Tech]

Thanks - that will read the Excel document; but how do I create the VP area?
On 16 Apr 2019, 21:14 +0100, Tai Bui , wrote:
> Hi,
>
> It should be possible with the VP IMPORT DOCUMENT command
> https://doc.4d.com/4Dv17R4/4D/17-R4/VP-IMPORT-DOCUMENT.301-4026489.en.html
>
> The command should be able to import your .xlsx format Excel File into a 4D 
> VP area.
>
> Best Regards,
> -Tai B.
>
>
>
> Tai Bui
> Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Téléphone : +1-408-557-4600
> Standard : +1-408-557-4600
> Fax : +1-408-271-5080
> Email : t...@4d.com
> Web : www.4d.com
>
>
>
>
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeremy Roussak via 
> 4D_Tech
> Sent: Tuesday, April 16, 2019 12:07 PM
> To: 4D iNug Technical <4d_tech@lists.4D.com>
> Cc: Jeremy Roussak 
> Subject: 4D View Pro question
>
> Sorry if this is a silly, or trivial, question.
>
> I’m using V17R4.
>
> I’d like to load an Excel document and pick bits out of it. I don’t need or 
> want to display any of it. I don’t have any form active.
>
> How do I create a VP area and load the document into it?
>
> Jeremy
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D View Pro question

[Tai Bui via 4D_Tech]

Hi,

It should be possible with the VP IMPORT DOCUMENT command
https://doc.4d.com/4Dv17R4/4D/17-R4/VP-IMPORT-DOCUMENT.301-4026489.en.html

The command should be able to import your .xlsx format Excel File into a 4D VP 
area.

Best Regards,
-Tai B.




-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeremy Roussak via 
4D_Tech
Sent: Tuesday, April 16, 2019 12:07 PM
To: 4D iNug Technical <4d_tech@lists.4D.com>
Cc: Jeremy Roussak 
Subject: 4D View Pro question

Sorry if this is a silly, or trivial, question.

I’m using V17R4.

I’d like to load an Excel document and pick bits out of it. I don’t need or 
want to display any of it. I don’t have any form active.

How do I create a VP area and load the document into it?

Jeremy

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View Pro question

[Jeremy Roussak via 4D_Tech]

Sorry if this is a silly, or trivial, question. 

I’m using V17R4. 

I’d like to load an Excel document and pick bits out of it. I don’t need or 
want to display any of it. I don’t have any form active.

How do I create a VP area and load the document into it?

Jeremy

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro

[Jeremy Roussak via 4D_Tech]

Thanks, Miyako. Instructive.

Jeremy

> On 7 Dec 2018, at 00:45, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have posted a demo
> 
> goto 3. WA page, click JS, select a code snippet and click Execute. click 
> Method and run directly from editor to see how it works.
> 
> https://github.com/miyako/4d-tips-view-pro-javascript
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro

[Keisuke Miyako via 4D_Tech]

I have posted a demo

goto 3. WA page, click JS, select a code snippet and click Execute. click 
Method and run directly from editor to see how it works.

https://github.com/miyako/4d-tips-view-pro-javascript



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro

[Jeremy Roussak via 4D_Tech]

Thanks, Jeremy. That’s an awful lot more difficult than the old set of PV 
commands, which I think is a shame. Hey ho.

Jeremy

> On 5 Dec 2018, at 17:35, Jeremy French  wrote:
> 
> Hi Jeremy,
> 
> I believe 4D View Pro is actually a 4D web area.
> 
> The 4D View Pro spread sheet is based on SpreadJS.
> 
> SpreadJS documentation (difficult to read) is at:
> http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#welcome.html
> 
> You can use the command WA Evaluate JavaScript to do some limited things, 
> like setting and getting cell values, formatting and so on.
> 
> Here’s an example of using JSON and a single JavaScript line to place data in 
> 4D View Pro:
> http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scbindadd.html
> 
> Here’s another example using several “single” lines of JavaScript to place 
> data in 4D Pro. See commented example "or use bindColumns to bind all custom 
> columns”.
> 
> https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/sheetLevelBinding
> 
> For individual cell set/get see:
> http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scvalue.html
> http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scgetvalue.html
> 
> As for 4D documentation, see this post from Laurent Esnault at 4D:
> http://forums.4d.com/Post/FR/26665847/1/26673658#26673658
> 
> There are a few helpful 4D View Pro examples at blog.4d.com. Search for 
> “View”.
> 
> - Jeremy French
> 
> 
> 
>> On Dec 5, 2018, at 9:25 AM, Jeremy Roussak via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I’ve never used View before. Older versions than v17 seem to have a suite of 
>> PV commands for getting and setting cell values and so on. They aren’t 
>> listed in the 4D View Pro documentation. What am I missing? (something 
>> obvious, I’m sure).



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: View Pro

[Jeremy French via 4D_Tech]

Hi Jeremy,

I believe 4D View Pro is actually a 4D web area.

The 4D View Pro spread sheet is based on SpreadJS.

SpreadJS documentation (difficult to read) is at:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#welcome.html

You can use the command WA Evaluate JavaScript to do some limited things, like 
setting and getting cell values, formatting and so on.

Here’s an example of using JSON and a single JavaScript line to place data in 
4D View Pro:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scbindadd.html

Here’s another example using several “single” lines of JavaScript to place data 
in 4D Pro. See commented example "or use bindColumns to bind all custom 
columns”.

https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/sheetLevelBinding

For individual cell set/get see:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scvalue.html
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scgetvalue.html

As for 4D documentation, see this post from Laurent Esnault at 4D:
http://forums.4d.com/Post/FR/26665847/1/26673658#26673658

There are a few helpful 4D View Pro examples at blog.4d.com. Search for “View”.

- Jeremy French



> On Dec 5, 2018, at 9:25 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve never used View before. Older versions than v17 seem to have a suite of 
> PV commands for getting and setting cell values and so on. They aren’t listed 
> in the 4D View Pro documentation. What am I missing? (something obvious, I’m 
> sure).
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

View Pro

[Jeremy Roussak via 4D_Tech]

I’ve never used View before. Older versions than v17 seem to have a suite of PV 
commands for getting and setting cell values and so on. They aren’t listed in 
the 4D View Pro documentation. What am I missing? (something obvious, I’m sure).

Jeremy

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: What constitutes use of 4D View Pro?

[Timothy Penner via 4D_Tech]

> I would think a good solution would be to add some indicator to the Property 
> window in Design so that every feature that requires a 4D View Pro license is 
> obvious. Maybe you make those properties a different color like blue or 
> purple. At least then when you were building the listbox with the Form Editor 
> you’d know what you were getting into.

There is a somewhat related feature request:
http://forums.4d.com/Post/EN/21929354/1/21929847#21929355

It doesn't look like anyone has voted on it yet...

-Tim



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: What constitutes use of 4D View Pro?

[Tim Nevels via 4D_Tech]

On Sep 10, 2018, at 1:02 PM, Chris Belanger wrote:

> I am a little confused about what constitutes use of 4D View Pro and, hence, 
> requires a license.
> 
> There are a number of features of listBoxes that are described as being 
> features of 4D View Pro.
> 
> https://blog.4d.com/automatic-row-height-in-listboxes-a-new-4d-view-pro-feature/
> 
> In this case, it is the “automatic row height” feature of a listbox, where it 
> can automatically adjust the height of a specific row according to its data.
> 
> If one uses this command, does that constitute use of 4D View Pro and hence 
> require a license? Since I develop on a test server (partner) I would not 
> know if a 4DView license is being ‘used’ or not.
> 
> My feeling is that if you stay away from using a 4D View Pro plugin on a 
> form, that you are not using 4D View Pro, but…

It is a unique situation to be sure. It has been discussed at a 4D Road Show I 
attended and it was confirmed that some listbox features required a 4D View 
license. 

And yes, your 4D developer license has a 4D View Pro license included so you 
would not know a feature you were using would not be available to an end user 
if they did not have a 4D View Pro license. 

It’s one of those things you just have to be aware of and deal with. 

I would think a good solution would be to add some indicator to the Property 
window in Design so that every feature that requires a 4D View Pro license is 
obvious. Maybe you make those properties a different color like blue or purple. 
At least then when you were building the listbox with the Form Editor you’d 
know what you were getting into. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com
*

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

What constitutes use of 4D View Pro?

[Chris Belanger via 4D_Tech]

Hi,

I am a little confused about what constitutes use of 4D View Pro and, hence, 
requires a license.

There are a number of features of listBoxes that are described as being 
features of 4D View Pro.

https://blog.4d.com/automatic-row-height-in-listboxes-a-new-4d-view-pro-feature/

In this case, it is the “automatic row height” feature of a listbox, where it 
can automatically adjust the height of a specific row according to its data.

If one uses this command, does that constitute use of 4D View Pro and hence 
require a license? Since I develop on a test server (partner) I would not know 
if a 4DView license is being ‘used’ or not.

My feeling is that if you stay away from using a 4D View Pro plugin on a form, 
that you are not using 4D View Pro, but…


Thanks,

Chris
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View to 4D View Pro upgrade path

[Uist Macdonald via 4D_Tech]

I see that 4D View is not supported on V16 64 bit client.  I use many 
programmatically created dynamic V13 4D View Areas.  Is there an upgrade path 
from 4D View to 4D View Pro?  I never use saved 4D View docs.

Uist Macdonald

-- 

Ceres Computer Consultants Ltd

Registered Office:
South Scotstarvit
Chance Inn
Cupar
Fife KY15 5QJ

+44 (0) 1334 828002

Registered in Scotland : SC107838

An ISO 9001 registered company.

This message including any attachments, is intended and authorized for
the addressee only, and may contain privileged and/or confidential
information.  If you are not the authorized addressee, you are not
authorized to either review or disseminate this message.  Accordingly,
if you are not the intended and authorized recipient, please disregard
this message and notify the sender.  If you are the authorized
addressee, you may use this for the purpose for which it was intended; a
direct, personal communication to you and your legal agents.  You may
not distribute it to or publish it in any public forum without prior,
specific, written permission from the sender.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Jody Bevan via 4D_Tech]

I am of similar mind as Jeff in regard to charging if one just uses for the 
extra Listbox features. There are times where the features of being able to 
show pictures, numbers, Strings, etc in the same column of the Listbox has 
proved very useful. Having done this in our shell, it means we really would 
have to not use that great feature in the 2 places we use it, and redesign 
those areas so that just for those 2 places they can have that nice interface.

To me they are ListBox specific enhancements.

The spreadsheet is great, and I probably have already got a sale of that 
feature set for the extra cost. They would balk at it though for the other 2 
listboxes.

Just a point of view (similar to Jeff’s) on 4D View / Listbox features.

Thanks

Jody


> On May 17, 2018, at 4:43 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> For what it's worth, I don't see why the handful of listbox improvements 
> aren't just rolled into the v17 upgrade. For those who need 4D View 
> spreadsheet type stuff, it's available to buy (in a primitive form to be 
> sure), but the new listbox features would be universally appreciated.
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
> 
>> On May 17, 2018, at 6:32 PM, Two Way Communications via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> With all due respect, I will stay with the listbox for the time being. 
>> Clearly, 4D View Pro is not ready yet to be used.
>> 
>> I can’t see any benefit at all by trying to figure out the json schema.
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Jeffrey Kain via 4D_Tech]

For what it's worth, I don't see why the handful of listbox improvements aren't 
just rolled into the v17 upgrade. For those who need 4D View spreadsheet type 
stuff, it's available to buy (in a primitive form to be sure), but the new 
listbox features would be universally appreciated.

--
Jeffrey Kain
jeffrey.k...@gmail.com

> On May 17, 2018, at 6:32 PM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> With all due respect, I will stay with the listbox for the time being. 
> Clearly, 4D View Pro is not ready yet to be used.
> 
> I can’t see any benefit at all by trying to figure out the json schema.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Keisuke,

With all due respect, I will stay with the listbox for the time being. Clearly, 
4D View Pro is not ready yet to be used.

I can’t see any benefit at all by trying to figure out the json schema.

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 May 2018, at 22:44, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> a 4D View Pro document is stored in an object.
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/Handling-4D-View-Pro-areas.300-3631583.en.html
> 
> schema: /Applications/4D/4D v17/4D.app/Contents/Components/4D 
> ViewPro.4dbase/Resources/4DViewSchema.json
> 
> you can use regular OB commands or object notation to programatically create 
> the document
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/VP-IMPORT-FROM-OBJECT.301-3631582.en.html
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Keisuke Miyako via 4D_Tech]

a 4D View Pro document is stored in an object.

http://doc.4d.com/4Dv16R6/4D/16-R6/Handling-4D-View-Pro-areas.300-3631583.en.html

schema: /Applications/4D/4D v17/4D.app/Contents/Components/4D 
ViewPro.4dbase/Resources/4DViewSchema.json

you can use regular OB commands or object notation to programatically create 
the document

http://doc.4d.com/4Dv16R6/4D/16-R6/VP-IMPORT-FROM-OBJECT.301-3631582.en.html



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Hi Keisuke,

Thanks for elaborating on this.

However, I can’t imagine that the only purpose is to open 4D View files, and I 
am sure that additional functionality will be added in future versions. (at 
least, that’s what we’ve been told at the summit)

It’s just that, at this point, the 4D View Pro spreadsheet is kind of useless 
if one can’t master the Javascript code to add rows or columns, or import or 
export to excel, .csv etc.
I have looked at the Spread.js documentation, and couldn’t find any examples on 
how to import or export. I don’t have that much experience with Javascript, 
like most of the 4D developers.

It would be useful to be able to manipulate the rows, columns and cells and 
fill them with data from 4D arrays or tables, no?

Maybe I am just to impatient to use this great new feature…

Regards,

Rudy Mortier
Two Way Communications bvba 



> On 17 May 2018, at 16:19, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 4D has studied how the classic 4D View plugin has beeb used in various 
> applications,
> and found that there were essentially two distinct usages; "as a list" and 
> "as a spreadsheet".
> 
> based on that understanding,
> two different paths have been defined to carry on the 4D View legacy:
> 
> 1. a set of privileged features for the listbox object (variable line height, 
> embedded controls, etc) and
> 2. a modern spreadsheet application with the capability to open existing 4D 
> View documents.
> 
> the 2 are completely unrelated features,
> except for the fact that they both require 4D View licenses to unlock.
> you could say that 4D View has been split into 2 products.
> 
> to use the new 4D View area which is a spreadsheet,
> you would typically import existing 4D View documents, or
> create new document via the UI and store them as a object or export in Excel 
> format.
> 
> it does not replace the list type 4D View Pro features,
> rather, the 2 features compliments each other.
> 
>> 2018/05/17 18:10、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> 
>> のメール：
>> Has anyone played around with 4D View Pro already?
>> I tried to put object arrays into the 4D View Pro area, like it was a 
>> listbox.
>> And although it does work with a listbox (4D v16R6), the 4D View Pro area 
>> stays empty.
>> Any idea how to even add columns and rows in 4D View Pro?
>> I guess one could use javascript, but how do you get javascript to access 
>> the object arrays and put the contents into 4D View Pro?
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: First experiments with 4D View PRO

[Keisuke Miyako via 4D_Tech]

4D has studied how the classic 4D View plugin has beeb used in various 
applications,
and found that there were essentially two distinct usages; "as a list" and "as 
a spreadsheet".

based on that understanding,
two different paths have been defined to carry on the 4D View legacy:

1. a set of privileged features for the listbox object (variable line height, 
embedded controls, etc) and
2. a modern spreadsheet application with the capability to open existing 4D 
View documents.

the 2 are completely unrelated features,
except for the fact that they both require 4D View licenses to unlock.
you could say that 4D View has been split into 2 products.

to use the new 4D View area which is a spreadsheet,
you would typically import existing 4D View documents, or
create new document via the UI and store them as a object or export in Excel 
format.

it does not replace the list type 4D View Pro features,
rather, the 2 features compliments each other.

> 2018/05/17 18:10、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> 
> のメール：
> Has anyone played around with 4D View Pro already?
> I tried to put object arrays into the 4D View Pro area, like it was a listbox.
> And although it does work with a listbox (4D v16R6), the 4D View Pro area 
> stays empty.
> Any idea how to even add columns and rows in 4D View Pro?
> I guess one could use javascript, but how do you get javascript to access the 
> object arrays and put the contents into 4D View Pro?




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

First experiments with 4D View PRO

[Two Way Communications via 4D_Tech]

Has anyone played around with 4D View Pro already?

I tried to put object arrays into the 4D View Pro area, like it was a listbox.

And although it does work with a listbox (4D v16R6), the 4D View Pro area stays 
empty.

Any idea how to even add columns and rows in 4D View Pro?

I guess one could use javascript, but how do you get javascript to access the 
object arrays and put the contents into 4D View Pro?


Regards,

Rudy Mortier
Two Way Communications bvba 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D View Pro license required in list box

[John Baughman via 4D_Tech]

Never mind. I just had to reapply my developer license. Fixed the problem.

Thanks,

John 

> On Dec 3, 2017, at 8:50 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am working on a new database in v16 R5. I develop on the Mac and this app 
> will deploy on windows. I am testing it on windows for the first time and I 
> have a form with 2 array based list boxes on it. The first populates the 
> second depending on it’s selection.
> 
> When the form opens up the second list box displays normally with an empty 
> grid. As soon as the first attempts to populate the arrays in the second list 
> box the second list box arrays are replaced with a grey box and “4D View Pro 
> license required.” in red letters appears in the box. This has worked fine 
> without any problems on the Mac.
> 
> Will be calling TS in the morning, Hoping someone knows why this might be 
> happening.
> 
> John
> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com
> 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D View Pro license required in list box

[John Baughman via 4D_Tech]

I am working on a new database in v16 R5. I develop on the Mac and this app 
will deploy on windows. I am testing it on windows for the first time and I 
have a form with 2 array based list boxes on it. The first populates the second 
depending on it’s selection.

When the form opens up the second list box displays normally with an empty 
grid. As soon as the first attempts to populate the arrays in the second list 
box the second list box arrays are replaced with a grey box and “4D View Pro 
license required.” in red letters appears in the box. This has worked fine 
without any problems on the Mac.

Will be calling TS in the morning, Hoping someone knows why this might be 
happening.

John


John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**