欢迎来到人人文库网! | 帮助中心 人人文库renrendoc.com美如初恋!
人人文库网
首页 人人文库网 > 资源分类 > DOCX文档下载

Spread for WinForms 表格控件客户问题实战

  • 资源大小:1.87MB        全文页数:88页
  • 资源格式: DOCX        下载权限:游客/注册会员/VIP会员    下载费用:1
游客快捷下载 游客一键下载
会员登录下载
下载资源需要1

邮箱/手机号:
您支付成功后,系统会自动为您创建此邮箱/手机号的账号,密码跟您输入的邮箱/手机号一致,以方便您下次登录下载和查看订单。注:支付完成后需要自己下载文件,并不会自动发送文件哦!

支付方式: 微信支付    支付宝   
验证码:   换一换

友情提示
2、本站资源不支持迅雷下载,请使用浏览器直接下载(不支持QQ浏览器)
3、本站资源下载后的文档和图纸-无水印,预览文档经过压缩,下载后原文更清晰   

Spread for WinForms 表格控件客户问题实战

P产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP1OF88NBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPSPREADFORWINFORMS表格控件客户问题实战NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP2OF88目录NBSP1安装SPREADFORWINFORMS42添加SPREAD控件到MICROSOFTVISUALSTUDIO工具箱NBSP43激活SPREADFORWINFORMS表格控件NBSP44部署NBSP65升级产品NBSP86单元格类型NBSP87单元格交互NBSP248边框及网格线设置NBSP309行列交互NBSP3610表单交互NBSP3911排序NBSP4212过滤NBSP4413数据搜索NBSP4614数据绑定NBSP4715数据可视化NBSP50图表NBSP50SHAPE57波形图NBSP61条件格式化NBSP6216大纲分组NBSP6317OUTLOOK分组NBSP6418级联显示NBSP6619公式NBSP6820打印NBSP7221键盘动作映射NBSP74NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP3OF8822剪切板操作NBSP7623鼠标交互NBSP7724文件交互NBSP80EXCEL导出NBSP80EXCEL导入NBSP8325皮肤NBSP8426如何调用设计器NBSP8627汉化NBSP8728本文档所有示例下载地址NBSP88NBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP4OF881安装SPREADFORWINFORMS安装NBSPSPREADFORWINFORMS产品步骤如下NBSP1保存下载的ZIP文件到临时目录,解压该文件到临时目录。NBSP2如已经安装试用版或旧版本,运行该版本控件的安装文件并按照提示进行卸载(卸载前请通过NBSPLICENSEMANAGER反激活),否则进行第4步。NBSP3重新打开安装文件夹。NBSP4运行SPREADWINBITS控件安装包或NBSPSPREADWINDOCS文档安装包。NBSP5点击欢迎界面的下一步。NBSP6在许可协议界面上,选择是否同意协议,若同意,点击下一步。NBSP7选择需要安装的控件,点击下一步NBSP8继续执行安装步骤,直至点击“完成”按钮确认安装完成。NBSP注意NBSP如果安装系统为MICROSOFTWINDOWSVISTA或更高版本,你需要使用管理员权限安装。如果仍然无法安装,请尝试请禁用使用者帐户控制UAC后再次安装。NBSPSPREADFORWINFORMSNBSPMICROSOFT已经告知MSNMESSENGER会锁定GAC,这样就会阻止安装程序移除GAC中的旧版本程序集。NBSP2添加SPREAD控件到MICROSOFTVISUALSTUDIO工具箱NBSP在MICROSOFTVISUALSTUDIO使用SPREAD表格控件,你需要添加控件到工具箱,操作步骤如下NBSP1如果工具箱没有显示,在VISUALSTUDIO视图菜单中选择“工具箱”。NBSP2右键点击工具箱,在弹出的菜单项中点击NBSP“选择项”NBSP选项。NBSP3在选择工具箱对话框中,选择“NETFRAMEWORK组件”选项卡。NBSP4在“NETFRAMEWORK组件”选项卡中,NBSPSPREAD控件(FARPOINTWINSPREAD命名空间)应该已经在列表中。NBSP5勾选FPSPREAD控件点击“确认”按钮。NBSP6如果SPREAD表格控件没有显示在列表中,点击“浏览”按钮,在安装文件夹下选择FARPOINTWINSPREADDLL后点击打开。这时SPREAD表格控件被添加到列表中,勾选后点击“确认”按钮。NBSP3激活SPREADFORWINFORMS表格控件NBSP可以通过以下步骤激活SPREAD表格控件NBSP1运行葡萄城许可证管理工具(开始菜单GT所有程序GTCOMPONENTONEGTLICENSEMANAGER)。NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP5OF88NBSP2在弹出的界面上点击“激活”链接。NBSP3激活产品建的界面上点击“下一步”。NBSP4在输入产品键界面输入产品键等使用信息点击“下一步”按钮。NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP6OF88NBSP5激活成功界面点击“完成”按钮确认激活完毕。NBSP4部署NBSP系统要求NBSP您的系统必须满足以下配置要求NBSPMICROSOFTWINDOWS98NBSPMICROSOFTWINDOWS98SENBSPMICROSOFTWINDOWSMENBSPMICROSOFTWINDOWS2000SP3NBSPMICROSOFTWINDOWSSERVER2003NBSPMICROSOFTWINDOWSSERVER2008NBSPMICROSOFTWINDOWSXPSP2NBSPMICROSOFTWINDOWSVISTANBSPMICROSOFTWINDOWS7NBSPMICROSOFTWINDOWS8NBSP软件要求NBSP必须安装MICROSOFTNET平台。NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP7OF88NBSP部署文件NBSP您必须在用户系统中部署下列文件NBSP下列程序集是与NBSPSPREADFORWINDOWSFORMS一起提供的NBSPFARPOINTCALCENGINEDLLNBSPFARPOINTEXCELDLLNBSPFARPOINTPLUGINCALENDARWINFORMSDLLNBSPFARPOINTWINDLLNBSPFARPOINTWINSPREADDLLNBSPFARPOINTLOCALIZATIONDLLNBSP安装应用程序必须从NBSPSPREADFORWINDOWSFORMS目录复制这些程序集到应用程序的可执行文件目录下或者把他们安装到全局程序集缓存中NBSPGAC。了解GAC信息,请参照MICROSOFTVISUALSTUDIONET和NBSPNET平台文档。NBSPNET平台可在发行组件包,如果用户系统上没有NET平台,关于软件包的更多信息,参照NET平台文档。NBSP如果您要使用高级NBSPINK您需要同时部署NBSPFARPOINTWININKDLL。这些程序集到应用程序的可执行文件目录下或者把他们安装到全局程序集缓存中NBSPGAC。这也需要MICROSOFTTABLETPCSDK运行是组件。NBSPFARPOINTWININK程序集是基于NBSPMICROSOFTTABLETPCSDK17版本编译的。NBSP如果在您的工程中应用了文本编辑器功能那么您需要部署FARPOINTWINTEXTRENDERERDLL。这个NBSPDLL需要和应用程序的可执行文件安装在统一文件夹下。这个特性只在NET20平台下使用。NBSP如果在您的工程中应用了导出PDF格式的功能那么您同样需要部署FARPOINTPDFDLL。NBSP如果在您的工程中应用了导出HTML格式的功能那么您需要同时部署FARPOINTWINSPREADHTMLDLL和NBSPSYSTEMWEBDLL。NBSP如果在运行时使用了SPREAD设计器那么您需要部署FARPOINTWINSPREADDESIGNDLL。NBSP如果在您的工程中应用了图表控件您需要部署FARPOINTWINCHARTDLL。NBSP如果在您的工程中应用了GCTEXTBOX或GCDATETIME您需要部署GRAPECITYWINPLUGININPUTMANDLL。NBSP托管网页上的控制NBSP如果您将NBSPSPREADFORWINDOWSFORMS控件作为用户控件托管在MICROSOFTINTERNETEXPLORERIE一个网页上,调整下列安全权限NBSP在IE中,选择工具GTINTERNET选项GT安全并选择可信任站点。点击网站按钮并添加网站例如NBSPHTTP//LOCALHOST。NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP8OF88在WINDOWS中,选择开始GT设置GT控制面板并选择管理工具。选择NBSPMICROSOFTNET框架配置。在NBSPNET平台配置窗体,选择运行库安全策略并点击调整区域安全。NBSP5升级产品NBSP升级VISUALSTUDIONET工具箱NBSP对于新的工程,您需要移除工具箱中的现有SPREAD控件,再添加新的SPREAD控件。NBSP1如果工具箱没有显示,在VISUALSTUDIO视图菜单中选择“工具箱”。NBSP2右键点击工具箱,在弹出的菜单项中点击“选择项”选项。NBSP3在选择工具箱对话框中,选择“NETFRAMEWORK组件”选项卡。NBSP4在“NETFRAMEWORK组件”选项卡中,NBSPSPREAD控件(FARPOINTWINSPREAD命名空间)应该已经在列表中。NBSP5勾选FPSPREAD控件点击“确认”按钮。NBSP6如果SPREAD’表格控件没有显示在列表中,点击“浏览”按钮,在安装文件夹下选择FARPOINTWINSPREADDLL后点击打开。这时SPREAD表格控件被添加到列表中,勾选后点击“确认按钮”。NBSP升级现有VISUALSTUDIONET工程NBSP1对于现有的工程,升级步骤如下NBSP2删除使用了NBSPSPREAD工程中NBSPSPREAD相关的DLL引用NBSP3删除使用了NBSPSPREAD的工程中NBSPLICENSESLICX文件NBSP4在工程中添加一个新的窗体(为了自动生成LICENSESLICX,并自动添加NBSPSPREAD相关的DLL引用)NBSP5在VS工具箱中将NBSPSPREAD控件添加到窗体中,此时会自动添加NBSPSPREAD相关的DLL引用,并自动NBSP生成LICENSESLICX文件(需要确认DLL和LICENSE中SPREAD的版本号是否正确)NBSP6对解决方案中所有工程进行14步操作。(一般客户会在该步骤出现问题,一定要针对项目的所有工程进行操作)NBSP7REBUILD整个解决方案。NBSP8重新发布。NBSP6单元格类型NBSP本章节中将列举了SPREAD用户在实际项目中遇到的典型单元格类型问题,包括了常用单元格类型的设置方法、事件捕获及扩展现有单元格类型实现自定义单元格类型等。NBSPSPREAD支持多达24种单元格类型。设置单元格类型时,对每一种单元格类型,您需要创建一个单元格类型对象,设置其属性,然后将其设为一个或多个单元格的CELLTYPE属性。NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP9OF88单元格类型指定了用户与单元格交互的形式,通过指定的单元格类型对数据进行访问,显示,校验。单元格类型为单元格定义了一个EDITOR用以处理输入数据,一个FORMATTER用以分析数据,还有一个RENDER用以控制单元格的数据如何显示。NBSPCOMBOXCELLTYPE不同选项定制不同的背景色NBSP问题描述如何获取COMOBOCELLTYPE的选择事件,改变单元格的背景色。NBSP问题解答COMOBOCELLTYPE提供了EDITORVALUECHANGED事件用于捕获选择事件。NBSP关键代码NBSP添加COMBOCELLTYPE单元格类型NBSP通过事件判断选择文本更改背景色NBSP效果截图NBSPNBSPNBSPNBSPNBSP////PSUMMARYNBSPNBSPNBSPNBSP///添加NBSPCOMBOBOXCELLTYPE单元格类型NBSPNBSPNBSPNBSPNBSP////SUMMARYPNBSPNBSPNBSPNBSPPRIVATEVOIDADDCELLTYPENBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPECOMBOBOXCELLTYPE1NEWFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPE;NBSPNBSPNBSPNBSPNBSPNBSPCOMBOBOXCELLTYPE1ITEMSNEWSTRING{QUOT红色QUOT,QUOT绿色QUOT,};NBSPNBSPNBSPNBSPNBSPNBSPFPSPREAD1SHEETS0CELLS0,0CELLTYPECOMBOBOXCELLTYPE1;NBSPNBSPNBSPNBSPNBSPNBSPCOMBOBOXCELLTYPE1EDITORVALUECHANGEDNEWEVENTHANDLERCOMBOBOXCELLTYPE1_EDITORVALUECHANGED;NBSPNBSPNBSPNBSP}NBSPNBSPNBSPNBSPVOIDCOMBOBOXCELLTYPE1_EDITORVALUECHANGEDOBJECTSENDER,EVENTARGSENBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPETESTSENDERASFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPE;IFTHISFPSPREAD1SHEETS0ACTIVECELLTEXTQUOT红色QUOTNBSPNBSPNBSPNBSPNBSPNBSP{THISFPSPREAD1SHEETS0ACTIVECELLBACKCOLORCOLORRED;NBSPNBSPNBSPNBSPNBSPNBSP}IFTHISFPSPREAD1SHEETS0ACTIVECELLTEXTQUOT绿色QUOTNBSPNBSPNBSPNBSPNBSPNBSP{THISFPSPREAD1SHEETS0ACTIVECELLBACKCOLORCOLORGREEN;NBSPNBSPNBSPNBSPNBSPNBSP}NBSPNBSPNBSPNBSP}NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP10OF88NBSP示例下载点击下载NBSP更多信息请参考SPREADFORWINFORMSV70API中文文档NBSP相关章节。NBSP如何禁止COMBOXCELLTYPE编辑NBSP问题描述如何设置COMBOCELLTYPE所在单元格只能通过选择项更改文本,禁止通过键盘编辑文本。NBSP问题解答COMBOCELLTYPE提供了EDITABLE属性用于获取或设置是否可以编辑文本。NBSP关键代码NBSP更多信息请参考SPREADFORWINFORMSV70API中文文档NBSP相关章节。NBSPNBSPNBSPNBSPNBSP////PSUMMARYNBSPNBSPNBSPNBSP///添加NBSPCOMBOCELLTYPE并且禁止编辑NBSPNBSPNBSPNBSPNBSP////SUMMARYPNBSPNBSPNBSPNBSPPRIVATEVOIDADDCELLTYPENBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPSTRINGCBSTR;NBSPNBSPNBSPNBSPNBSPNBSPCBSTRNEWSTRING{QUOTAAAQUOT,QUOTAABCQUOT,QUOTABBCQUOT,QUOTBBBQUOT,QUOTBBCQUOT,QUOTBCCQUOT};NBSPNBSPNBSPNBSPNBSPNBSPSTRINGSTRVAL;NBSPNBSPNBSPNBSPNBSPNBSPSTRVALNEWSTRING{QUOT1QUOT,QUOT2QUOT,QUOT3QUOT,QUOT4QUOT,QUOT5QUOT,QUOT6QUOT};NBSPNBSPNBSPNBSPNBSPNBSPNBSPFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPECOMBONEWFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPE;NBSPNBSPNBSPNBSPNBSPNBSPCOMBOITEMSCBSTR;NBSPNBSPNBSPNBSPNBSPNBSPCOMBOITEMDATASTRVAL;NBSPNBSPNBSPNBSPNBSPNBSPCOMBOEDITORVALUEFARPOINTWINSPREADCELLTYPEEDITORVALUEITEMDATA;NBSPNBSPNBSPNBSPNBSPNBSPNBSP//禁止编辑NBSPCOMBO文本NBSPNBSPNBSPNBSPNBSPNBSPNBSPCOMBOEDITABLEFALSE;NBSPNBSPNBSPNBSPNBSPNBSPFPSPREAD1SHEETS0CELLS0,0CELLTYPECOMBO;NBSPNBSPNBSPNBSP}NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP11OF88实现像GOOGLE搜索一样的自动完成功能NBSP问题描述通过输入字符在自动匹配数据库中选项,提高输入效率。NBSP问题解答COMBOBOXCELLTYPE提供了AUTOCOMPLETEMODE属性用于设置自动完成模式,AUTOCOMPLETESOURCE用于指定自动完成数据源。NBSP关键代码NBSP示例下载点击下载NBSP更多信息请参考SPREADFORWINFORMSV70API中文文档NBSP相关章节。NBSP如何在单元格中同时显示文本和图片NBSP问题描述希望在单元格中同时添加文本和图片混排的方式。NBSP问题解答SPREAD提供了单元格自定义功能,可以继承COMOBOCELLTYPE并且重载PAINTCELL方法来手动添加图片。NBSP关键代码NBSP//设置单元格类型NBSPFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPECOMBONEWFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPE;NBSPSTRINGCBSTR;CBSTRNEWSTRING{QUOTAAAQUOT,QUOTAABCQUOT,QUOTABBCQUOT,QUOTBBBQUOT,QUOTBBCQUOT,QUOTBCCQUOT};STRINGSTRVAL;STRVALNEWSTRING{QUOT1QUOT,QUOT2QUOT,QUOT3QUOT,QUOT4QUOT,QUOT5QUOT,QUOT6QUOT};NBSPCOMBOITEMSCBSTR;COMBOITEMDATASTRVAL;COMBOEDITORVALUEFARPOINTWINSPREADCELLTYPEEDITORVALUEITEMDATA;NBSP//指定自动完成的模式及数据源NBSPCOMBOAUTOCOMPLETEMODEAUTOCOMPLETEMODESUGGESTAPPEND;COMBOAUTOCOMPLETESOURCEAUTOCOMPLETESOURCELISTITEMS;NBSPFPSPREAD1SHEETS0CELLS0,0CELLTYPECOMBO;NBSP产品网站HTTP//WWWGCPOWERTOOLSCOMCNNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSP12OF88NBSPNBSPNBSP////PSUMMARYNBSPNBSP///通过继承NBSPCOMBOCELLTYPE实现NBSPNBSPNBSP////SUMMARYPNBSPNBSPNBSPNBSPPUBLICCLASSIMAGECOMBOFARPOINTWINSPREADCELLTYPECOMBOBOXCELLTYPENBSPNBSP{PUBLICOVERRIDEVOIDPAINTCELLGRAPHICSG,RECTANGLER,FARPOINTWINSPREADAPPEARANCEAPPEARANCE,OBJECTVALUE,BOOLISSELECTED,BOOLISLOCKED,FLOATZOOMFACTORNBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPIFVALUENULLNBSPNBSPNBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPINTIND0;NBSPNBSPNBSPNBSPNBSPNBSPFORINTI0;ILTBASEITEMSLENGTH;INBSPNBSPNBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPIFBASEITEMSIVALUETOSTRINGNBSPNBSPNBSPNBSPNBSPNBSP{NBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPINDI;NBSPNBSPNBSPNBSPNBSPNBSPNBSPNBSPBREAK;NBSPNBSPNBSPNBSPNBSPNBSP}NBSPNBSPNBSPNBSPNBSP}NBSPNBSPNBSPNBSPNBSPNBSPIMAGEIMGBASEIMAGELISTIMAGESIND;NBSPNBSPNBSPNBSPNBSPNBSPGDRAWIMAGEIMG,NEWRECTANGLENEWPOINTRX,RY,NEWSIZE20,20;NBSPNBSPNBSPNBSPNB

注意事项

本文(Spread for WinForms 表格控件客户问题实战)为本站会员(gcpowertools)主动上传,人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知人人文库网(发送邮件至[email protected]或直接QQ联系客服),我们立即给予删除!

温馨提示:如果因为网速或其他原因下载失败请重新下载,重复下载不扣分。

关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服客服 - 联系我们

网站客服QQ:2846424093    人人文库上传用户QQ群:460291265   

[email protected] 2016-2018  renrendoc.com 网站版权所有   南天在线技术支持

经营许可证编号:苏ICP备12009002号-5