nie robim pre powerpoint addins.
resp. moj addins co je vytvoreny v powerpointe prepisujem do visual studia. Robota asi na 1-2mesiace.
Takze tu budem casto prispevkovat :) .
Dakujem DAAL este vcera vnoci som sa dopatral k niecomu podobnemu. Ale aj tak dik ze je tu niekto kto ma skusenosti s visual studiom
tu je link:
https://msdn.microsoft.com/en-us/library/dd935909.aspx
Ahojte vie niekto zadefinovat ActivePresentation v visual studio addinse?
skusal som to podla tohoto navvodu ale nejak to nejde resp. netusim kde mam napisat 'Declaration.
https://msdn.microsoft.com/en-us/library/microsoft.office.interop.powerpoint._application.activepresentation.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1
trosku mimo temu ale len na dopnenie. Ked zu robime databazu znakov tak nie kazdy znak tam ide doplnit ale daju sa tam dolnit s funkciou zistime jeho ID:
Debug.Print AscW(Selection)
a potom mozme zapisat:
Selection.Replace ChrW(317), "L", MatchCase:=True
nie kazde Ľ je Ľ
DAAL tak uz som to rozchil dik DAAL tvoja navigacia pomohla :)
na obrazku je vidiet ako som nastavil signing a ze MMC kozolu som certifikatu priradil vsetko co sa len dalo :)
ale aj tak to pise to iste:
The solution cannot be installed because it is signed by a publisher whom you have not yet chosen to trust. If you trust the publisher, add the certificate to the Trusted Publisher list.
************** Exception Text **************
System.Security.SecurityException: The solution cannot be installed because it is signed by a publisher whom you have not yet chosen to trust. If you trust the publisher, add the certificate to the Trusted Publisher list.
at Microsoft.VisualStudio.Tools.Office.Runtime.OfficeAddInDeploymentManager.VerifyAddInTrust(ClickOnceAddInTrustEvidence evidence)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.VerifySecurity(ActivationContext context, Uri manifest, AddInInstallationStatus installState)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
The Zone of the assembly that failed was:
MyComputer
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Office.Runtime
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50903.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Hosting
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50903.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.ServerDocument
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50903.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.dll
----------------------------------------
Microsoft.Office.Tools
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50903.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Runtime
Assembly Version: 10.0.0.0
Win32 Version: 10.0.50903.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Deployment
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Security
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
System.Xml.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1055.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
pouzivam:
Visual Studio Professional 2015
Version: 14.0.24720.00 Update 1
Microsoft .NET Framework
Version 4.6.01055
tvorba addinsu:
1. pustim File/New/Project/
2. tam vyberem Template/Visual Basic/ Office/SharePoint / Excel 2010 VSTO Add-in
3. potom do eventu Startup napisem MsgBox("Test")
4. pustim debug
a tam vypise tu hlasku
dnes som skusal po vasej rade vytvorit signature ale nejak sa to nepodarilo
mozte prosim napisat presny postup?
uz nieto skusal vytvorit addins v visual studio
ja som to skual a ked chcem spustit debugger tak to vzdy vypise:
Name: test3 - test3
From: file:///c:/xx/visual studio 2015/Projects/test3/test3/bin/Debug/test3.vsto
************** Exception Text **************
System.Security.SecurityException: The solution cannot be installed because it is signed by a publisher whom you have not yet chosen to trust. If you trust the publisher, add the certificate to the Trusted Publisher list.
at Microsoft.VisualStudio.Tools.Office.Runtime.OfficeAddInDeploymentManager.VerifyAddInTrust(ClickOnceAddInTrustEvidence evidence)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.VerifySecurity(ActivationContext context, Uri manifest, AddInInstallationStatus installState)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
The Zone of the assembly that failed was:
MyComputer
neviete preco to nejde spustit?
tak isto sa da tento test urobit na kalkulacke skuste tam dat
5/5/5/5/5/5/5/5/5/5
a potom vysledok
* 5 * 5 * 5 * 5 * 5 * 5 * 5 * 5 * 5
a ci vam vide 5
resp. cim viac sme to delili a potom spatne s nasobenim sme dostaval vysledok = 5 tak tym Bola kalkulacka presnejsia
O tejto chybe zu som niekde cital ... nieje to vobec ziadne tajhomstvo
V skratke ide o to ze Excel je upraveny nato aby pracoval s velkymi datami a aby mohol s nimi pracovat co najefektivnejsie je tam nastavena urcita nepresnost .... myslim ze to je na 8 desatinnych miest .... niesom si uplne isty
Preto by sa pani uctovnicka nemala s touto chybou nejak obavat kedze potrebuje zaokruhlovat len na 2desatinne miesta.
eLCHa: s funkciou KDYZ/IF su vzdy problemi a to nie len v exceli ... ked sa napriklad porovnava "Hello world " = "HelLo world" ... tieto preklepy su vsade ... aj ked pouzijete trim, lcase, like vzdy sa najde nieco co to nesplni.
chcel som tym povedat ze toto nieje Problem excelu ale uzivatela co to tam zadal.
nechce sa mi verit ze pani uctovnicka potrebuje vysledok presnejsi ako 2 desatinne miesta :). Resp. nato jej Excel musel bohate stacit.
len hadam .... nebude to nieco s menenim fontu na taky ktory neobsahuje diakritiku? a potom spat?
nedosiel som nato
dufam ze: záhlaví = Header :)
a co som skusal tav v worde die dat do hlavicky TextBox. V exceli to nejde :) ale to som neskusal cez VBA
dva texty na sebe? :)
Oblíbený formulář Faktura byl vylepšen a rozšířen.
Více se dočtete zde.
Používáte podnikový systém Helios iNuvio? Potřebujete pomoci se správou nebo vyvinout SQL proceduru? Více informací naleznete na stránce Helios iNuvio.