Hey I got the requirement to output some reports as Excel 2002 spreadsheets. Normally a job for reporting services - however - that's (edit) "not great IMO" and I hate it so for this project I used ExtJs - which doesn't do any excel output - not really - but does do the UI really, really well. The reports will need to have outlining, ...
Looking for Migration from Office 2002 - VBA Word Doc Application to Office 2007. Issues :- Though Office 2007 Supports VBA Application - VB Macro Code, Menu Bars are not appearing. Indeed, VBA Macro Menus display under "Add-ins". On a study, I realized Office 2007 Supports XML - Ribbon. Is there any ideal approach to migrate VBA Macro...
How to detect that for current locale if MUI pack of Office is installed or not from C# ...
Hi I've asked on the OpenXml Sdk forum but that place seems about as active... not very active. I'm doing some server side excel output using the OpenXML Sdk v2 ctp. Has anyone here had any experience using this - mpre specifically: Is there a way to add subtotals to data in a spreadsheet using the SDK? or do i need to manually iterate...
I am working on a project(in python) that needs formatted, editable output. Since the end-user isn't going to be technically proficient, the output needs to be in a word processor editable format. The formatting is complex(bullet points, paragraphs, bold face, etc), I'm wondering if there is a way to generate such a report using python. ...
Hi All, I'm a developer writing an add-in for Outlook2003/2007 using C#, Visual Studio 2005. I'm also using the COM add-in wizard (not using VSTO, I have a Connect.cs). The program successfully runs with visual studio installed on my machine but when I try to deploy the software I am getting weird behavior. I have a logging system set ...
My employer has purchased a third-party tool, OfficeConverter from Conveter Technology that automates the conversion / repair of Office 2003-formatted files to Office 2007 format. This tool also highly automates the translation / change in macro / VBA code requirements between Office 2003 and 2007 formats. My problem is that during thi...
Does anyone know, how to replace tags in a google doc with .net code. Hello << name >> This is << my_name >>. and replace << name >> and << my_name >> with C#. Is there any other way to this. I know that I can use interops and office dlls for this, but then I need to have office installed on my server which is not a possibility Tha...
The company I work for has just purchased 4 32" LCD screens to be mounted at the front of the office for demonstration purposes. Whilst we are not demonstrating (most of the time), the screens are to be used as development information screens for the whole team. What information would people recommend displaying to be most useful to the...
How to attach an event handler for SendAndReceive event of Contact folders/Contact Items in outlook 2007 using VSTO AddIn. I tried using Application.ActiveExplorer().SyncObjects.ForEach { SyncObject.SyncEnd += \Do something } It is not working ...
Hi, Someone at my office has an access database which includes macros in the toolbar. To access it currently they have to log out of the domain and into a local user account. They would like others in the office to be able to access the database, which they can, but they cannot use the macros on the toolbars. The office version that is...
At the moment we're using office interop to generate documents from templates in office 2003 (word, excel & powerpoint). This seems to be rather frowned upon (see office-interop-with-64bit-windows-in-asp-net) and whilst it works fine I would be happier with a supported solution. What non hacky method is there to do this? Requirements ar...
I have an ASP.NET web application the entire site is browsed over HTTPS using a valid commercial certificate. In one part of the application it is possible to download an Excel spreadsheet. The download is initiated from a POST (PostBack from a LinkButton) The Response is cleared (Response.Clear(), Response.BinaryWrite(bytes[])) blah et...
I have my own (patched)implementation of IDataObject::GetData say MyGetData. When I copy the data with Office Clipboard on, I get a call in MyGetData by Office Clipboard which tries to get the data to be pasted in its own clipboard viewer window the application which is pasting the copied data. I want to differentiate between these t...
How do you find the range of page n in Microsoft Word using office automation? There appears to be no getPageRange(n) function and it is unclear how they are divided. ...
I try to write down the result of the POI unit test at: code here, by adding the line daDoc.write(new FileOutputStream("C:\\wordtest.doc")); to the end of the method testRangeReplacementAll. The new document is corrupt when I try to open it with word 2003. Any suggestions to fix this? ...
BACKGROUND I am automating an PowerPoint 2007 via C# I am writing unittests using the built-in unit testing of Visual Studio (Microsoft.VisualStudio.TestTools.UnitTesting) for my code I am well relatively experienced in automating the Office 2007 apps MY PROBLEM When I run my unit tests, the first unit test method runs fine, all af...
From what I understand PDF is an open format and you can digitally sign the PDF document as proof using a certificate issued by a CA which follows open standards.What about Microsoft word can I sign using an open standards certificate? Can someone clarify if I can do a signature on word using a standard certificate or only from Microsoft...
I'm writing a COM add-in for Word, Excel and PowerPoint. This add-in has some user-configurable settings (about a page full of them actually... or perhaps even more than a single page). What is the standard way of presenting these to the user? Through a custom page under Tools->Options? (how?) Under a custom button on a custom toolbar? A...
Hi, we have a rather old MOSS installation with SP2 installed, which quite recently ceased to include the MicrosoftSharePointTeamServices header in replies to Protocol Discovery OPTIONS HTTP requests. This causes problems like Excel 2003 complaining of being unable to connect to SharePoint site to synchronize lists, etc. The Excel proble...