Subscribe to this thread
Home - General / All posts - mix of manifold 8 doc and doc using VBA excel ?

561 post(s)
#20-Nov-18 22:56


1) I already ask myself there is 5 years ago or more why manifold8 doc when go to chapter constant don't show us the value use by constant value that appear like a name ?

here the value of differents Geomtype Value in manifold8 compare to excel !

In excel we can see the raw value like GeomLine=1

2) Why pop up documentation don't appear in excel ? I already see that in editor and seem to be call code completion that show argument and parameter .

3) we have also the location of the dll wihtout read the manifold 8 doc !!

4) the question could be what mean global in manifold and ASP server side context ?

5) could we have acces to manifold 9 API using Excel ( 32 or 634 bit ) ?



join image

"Because my dad promised me" ( interstellar ) but blackhole don't exist

best hardware with no ads focus on quality features price like manifold see xiaomi


8,479 post(s)
#21-Nov-18 08:08

1 - It is usually the intent of having a named numeric constant to free you from knowing what the specific value is, but we agree that there are some scenarios where you'd like to know that value. We'll keep that in mind when writing documentation.

2 - The documentation for 8 objects is invisible to Excel because in order to be visible to Excel, it has to be compiled into the DLL (simplifying things). We didn't put the documentation into the DLL for 8 because this would only work for COM objects, .NET clients wouldn't get it (.NET clients interoperate with 8 through COM and automatic conversion loses non-vital things like documentation). With 9, we have a similar problem with the reverse direction: we can put the documentation for .NET objects into the DLL, but it won't be available for COM clients. We have a couple of ideas as to how we can provide documentation in this format (suitable for use by third-party tools) for both COM and .NET, for now let's just use the website.

4 - Your screen seems to show methods and properties of the Application object. We do expose an instance of an Application object as an unnamed global for scripts, but I am not sure how Excel could find out about that, maybe 'globals' refers to something Excel-specific which happens to coincide with what we are doing for our scripts.

5 - Yes, you can script 9 through Excel. In Visual Studio, you would add a reference to EXT.DLL - that DLL contains the .NET API, but the system will convert to COM automatically (.NET can call COM and vice versa). There should be something similar in Excel.

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.