Open XML Scenarios

Forum Post: How to exact value of Cell in Excel document with OpenXML ?

Javidan — Fri, 17 May 2013 08:55:00 GMT

As with using Microsoft.Interopt I can get cell value like this : Cell.Value . But with OpenXML I got confused. Sometimes it returns id of item in SharedStringTable sometimes it return string and etc. Is there some method like to get exact cell value in excel document?

Forum Post: Accessing/Manipulating all parts of an OpenXML document when open within Word 2013

sef — Tue, 14 May 2013 21:18:00 GMT

Similar as Eric describes in his Open XML Markup Explorer App for Word 2013 I would like to manipulate not only the document.xml part in the open OpenXML Document in Word but all parts like adding a picture to the media folder. Is such a thing possible with an open document in Word 2013 without closing it (like in Eric’s Sample: Open XML Markup Explorer App for Word 2013)?

Forum Post: Re: There is problem when saving XmlDocument into OpenXmlPart

Lcd — Mon, 13 May 2013 13:18:00 GMT

Thank you very much, this solution worked with some modification of my code

Forum Post: Re: How to add rows to ready table in Word document?

Javidan — Mon, 06 May 2013 17:10:00 GMT

Thanks for quick reply. There are interesting facts about saving. I asked about save problem "search and replace" and solution was Package.Close() event. But now, I only needed to call Document.Save() method, and do "search and replace" then call Package.Close() event. I came to that, Document.Save() method cancels replaced texts in document

Forum Post: Re: Doing manipulation in an Open Office document?

Eric White — Fri, 26 Apr 2013 19:09:00 GMT

If you are going to extract text while the user types it in, you will need to build an add-in (either a document-level addin or an application-level addin).

The following blog post contains a number of links to other content that will help you get going when creating an add-in:

blogs.msdn.com/.../microsoft-word-2010-developer-building-blocks.aspx

-Eric

Forum Post: Re: parse and publish aspx url

millakinross — Mon, 22 Apr 2013 03:33:00 GMT

*** shows | x rated shows | show girls | strippers sydney | nude shows

Forum Post: Re: Open XML Package Editor Power Tool for Visual Studio

japa62 — Tue, 16 Apr 2013 09:46:00 GMT

Thanx's Todd, response left under jamarpa. Really makes me think that there are plan's that make OpenXML redundant in MS's future. Destroying one of the best decisions that MS has ever made in my view.

Forum Post: Re: Compare Word 2007 WordOpenXML chunks

mema864 — Fri, 08 Mar 2013 16:58:00 GMT

i wish i can help u ,,i hate the version of 2007

_______________________

Rupture Of Tendon Achilles

"Integrative_Manual_Therapy for the upper and lower extremities" Download free ebook

Forum Post: Re: Document assembly project

tinyborn — Tue, 26 Feb 2013 09:12:00 GMT

Thanks for this post and showing a great concern. I would love to ask my queries and get it sorted.

___________________

document assembly software

Forum Post: Re: Using Australia post barcode in SQL Server Reporting Services

Edwards001 — Fri, 22 Feb 2013 08:02:00 GMT

Another barcode generator for reporting services which support postal barcode standards.

Forum Post: Re: How to create office shape in clipboard

tutalib — Tue, 19 Feb 2013 01:43:00 GMT

waiting for the answer

________

tutalib

Forum Post: Re: data validation list for excel cell using openXML work with cell range(ie;A1 to A3) not with text(i.e;1,2,3,4)

madiken — Mon, 11 Feb 2013 11:34:00 GMT

You have to use the following syntax :

formula12.Text = "\"1,2,3,4\""; // with escaped double quotes...

Forum Post: Re: How to add comma separated text to excel in open XML

pavan — Mon, 11 Feb 2013 10:01:00 GMT

Hi,

There is no problem with comma separated text in specific cell.

Thank u for replay

Forum Post: Re: Mergin Powerpoint Presentations

Eric White — Mon, 28 Jan 2013 09:24:00 GMT

Hi all,

PresentationBuilder has now been released.

Quick Introduction to PresentationBuilder

All About PresentationBuilder, Part 1

All About PresentationBuilder, Part 2

All About PresentationBuilder, Part 3

-Eric

Forum Post: Re: I don't find any end list mark

rebustiano — Tue, 22 Jan 2013 07:55:00 GMT

Wow!

Your articles in msdn are incredible!

I made an algorithm to read and render a docx document using libopc, My app show bullets, decimal, letter and another fine for numberings, but my current goal is find how can restart the first level number for a new list in the document, the next levels are not a problem.

Many thanks for your answer!!!!

Forum Post: Re: How do I know the font size (for example) of a specific piece of text in a word document?

Eric White — Sat, 12 Jan 2013 22:23:00 GMT

You are right all except for the party of checking the previous paragraph. That is just a default for the next paragraph and is used in the user interface only.

Currently there is nothing in the open xml sdk or power tools to help you.

I wish I had a better answer for you but I don't at this time.

Eric

Forum Post: Re: Create fillable form in microsoft word

Eric White — Sat, 05 Jan 2013 20:17:00 GMT

(This question is answered in another form. Posting the same answer here for reference.)

This is very doable. My recommended approach is to fabricate an Open XML document that contains content controls for each field. The user enters their data in those content controls. You can also protect the remainder of the document against modification. Users can then download the document, fill out the form, and upload it. It is then straightforward to use Open XML to read the contents of the fields and populate a database.

I've added this to my list of content to write. Unfortunately, I have a backlog currently, but I'll get to this as soon as I am able.

-Eric

Forum Post: Re: How to write text in cells of creating excel sheet using openxml?

Eric White — Sat, 05 Jan 2013 15:29:00 GMT

Hi,

First thing is to watch Bob McClellan's screen-casts on SpreadsheetML:

openxmldeveloper.org/.../screen-cast-introduction-to-open-xml-spreadsheetml-part-1.aspx

Also, if you go to the front page of OpenXMLDeveloper.org, click on SpreadsheetML, and you will find more than 80 blog posts, articles, and screen-casts. You will find a lot of stuff to help you get started.

-Eric

Forum Post: Re: Is it possible to sign only macro in Office 2010 document using packagedigitalsignaturemanager.Sign() in c#?

Todd Main — Tue, 01 Jan 2013 02:51:00 GMT

There's no documentation on having a macro signable via Open XML programming. The best you can do, I believe, is have pre-existing VBA code that is signed and then add that to the package. The area Working with Open XML Packages on MSDN should give you a start on this.

Forum Post: Re: Looking for a high level review of my OpenXML project to see if I am on a path that can get me there, and if so, how?

sblalock — Thu, 04 Oct 2012 12:44:00 GMT

Bobm - First thank for reading all the way thru and giving your opinion. I appreciate you considerate contribution. You have confirmed exactly what I have found so far. I looked at hand rolling the copy / paste functionality and then realize the complexity. I was hoping the heavy lifting had already been done by someone. I know there are some work in this space by people like Eric White, but I think he has only been playing in the WordprocessingML area and not SpreadsheetML or DrawingML. I plan on continuing the search for other contibutions by Eric or others.

I had a discussion with the Microsoft guy in charge of my MSDN ticket and he clued me in on the fact that MS seems not to be manipulating Open XML internally. I thought that they had changed the internals of Excel and would be able to share a snippet (or non propreitary code based on the algorythm) of Excel code that does the cut and paste. It appears that MS reads the file in, places it in their internal format for editing, and then saves it back as OpenXML. This of course makes total sense, but I was hoping they had went to using the XML internally <I know, rainbows and unicorns right?>

Concerning the JPG vs the DrawingML, again I have been softly selling this idea of flattening the drawing objects to pictures and editing them in a drawing application to my client. It does significantly reduce the complexity. There are code samples to read an image and place it on a spreadsheet. I could get away from the manipulation of all those many drawing objects represented in DrawingML and just manipulate one image instead. It does not meet my client's requirements however, if the alternative is to write the copy paste function of a OpenXML Editor, I am pretty sure that they may ease this requirement.

Thanks again for the assistance. I really wanted confirmation that I was not being an idiot. I know there are a lot of smarter people out there than I, and I wanted to make sure I was not missing something obvious.