Forums

Forum Post: Re: HTML content as a document part

ehomeneeds — Mon, 20 May 2013 18:23:00 GMT

Hi,

I have the same problem and I have not done! Please help me! Thanks!

home improvement services

Forum Post: Re: Where to Install the SDK

margaux1213 — Mon, 20 May 2013 16:17:00 GMT

Thanks for your answers :) http://linkapp.me/gpDIJ

Forum Post: Re: XML parsing for Docx file

Aamir — Mon, 20 May 2013 07:49:00 GMT

Thanks.....

Forum Post: Require Help

pankajbaviskar — Sat, 18 May 2013 07:14:00 GMT

Hi,

I am new to OpenXml , my requirement is i want to develop a word document which having text, tables and chart in that. i had written code for that , when i open word it gives unspecified Error.

Forum Post: Re: How do I know the size of a specific piece of text in a work document?

jcordeiro — Fri, 17 May 2013 23:00:00 GMT

Dear Jim,

Let me add some additional information.

Regarding point 1: you're completely right about the text from the standard: it clear states that the default praragraph style should be applied if there is no paragraph style applied. On the other hand the information regarding the pstyle element states:

"If this element is omitted, or it references a style which does not exist, then no paragraph style shall be applied

to the current paragraph. As well, this property is ignored if the paragraph properties are part of a paragraph

style." (ISO/IEC 29500-1:2012(E - 17.3.1.27)

This is against the first statement!!!

For the character style (also point 2) the behaviour of word is like this:

I change the default character style within Visual Studio (VS), (in my tests I added run properties with just the bold property inside) and when I open word, it completes ignore my changes. Then I change something inside the run with that style and after saving the document, word replaces the default character style with the following style (the original character default style) removing all run properties from the style:

<w:style w:type="character" w:default="1" w:styleId="DefaultParagraphFont">

<w:name w:val="Default Paragraph Font"/>

<w:uiPriority w:val="1"/>

<w:semiHidden/>

<w:unhideWhenUsed/>

</w:style>

Also, as I said before, Word keeps all run properties information for a character style in that specific style. In this case is not necessary to roll up styles. A simple test I made is to define within VS the size of a font in the run properties of character style "styleA" and no size information for character style "styleBinheritingFromA". When I open word everything is correct within runs of both styles, but if I change something in the run with "styleBinheritingFromA" word changes this style with all information inherited from styleB that is missing. In this case my size property is added to style "styleBinheritingFromA".

José

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: DocumentBuilder dont find file create in runtime

ClaudiaJS — Tue, 14 May 2013 20:16:00 GMT

Thanks for answer, I want to say. With three procedures, i do, three differents files, after, i combine these files just created with other files already existing in the server, but when I do this, the procedure "DocumentBuilder.BuildDocument", combine the files already existing in the server, but the three files, created before the execution of the procedure seems dont exist, and comes this error: "empty list error ". I see the files in the server, i can open the file and modify without problem.

I hope to be clear, I post the code for the generation of one file

Public Function GeneraFileArticoli(ByVal IdOffer As String, ByVal nomeCartella As String) As String

Dim IndFileArticoli As String = ""

Try

Dim nomeDir As String = ConfigurationManager.AppSettings("DirServer")

Dim TemplatePath As String = nomeDir + "\OpenXmlContent\ModelloGrid.docx"

Dim OutputPath As String = nomeDir + "\" + nomeCartella + "\" + IdOffer + "-Articoli.docx"

File.Copy(TemplatePath, OutputPath)

Dim db As New DBOfferteDataContext

Dim varOfferta = From prod In db.spDoc(IdOffer)

Using theDoc As WordprocessingDocument = WordprocessingDocument.Open(OutputPath, True)

Dim body As Body = theDoc.MainDocumentPart.Document.Body

'***************************************** TABELLA CON DATI **************************************

Dim mainPart As MainDocumentPart = theDoc.MainDocumentPart

Dim ccWithTable As SdtBlock = mainPart.Document.Body.Descendants(Of SdtBlock)().Where(Function(e) e.SdtProperties.GetFirstChild(Of Tag)().Val = "ElencoProdotti").[Single]()

Dim theTable = ccWithTable.Descendants(Of Table)().Single()

Dim theRow = theTable.Elements(Of TableRow)().Last()

For Each articolo In varOfferta

Dim rowCopy As TableRow = DirectCast(theRow.CloneNode(True), TableRow)

rowCopy.Descendants(Of TableCell)().ElementAt(0).Append(New Paragraph(New Run(New Text(articolo.Kit.ToString()))))

rowCopy.Descendants(Of TableCell)().ElementAt(1).Append(New Paragraph(New Run(New Text(articolo.Codice.ToString()))))

rowCopy.Descendants(Of TableCell)().ElementAt(2).Append(New Paragraph(New Run(New Text(articolo.Prodotto.ToString()))))

rowCopy.Descendants(Of TableCell)().ElementAt(3).Append(New Paragraph(New Run(New Text(articolo.Incluso.ToString()))))

rowCopy.Descendants(Of TableCell)().ElementAt(4).Append(New Paragraph(New Run(New Text(articolo.Prezzo.ToString()))))

theTable.AppendChild(rowCopy)

theTable.RemoveChild(theRow)

mainPart.Document.Save()

IndFileArticoli = docOutputPath

End Using

Catch ex As Exception

Dim Problema As String = ex.Message

End Try

Return IndFileArticoli

End Function

Thank's in advance

Claudia

Forum Post: Re: Can the Presentation Builder be used without the USING() { } Statement?

YasiduY3K — Tue, 14 May 2013 17:16:00 GMT

Hi,

I did a small modification to the presentation builder.

Instead of creating an output file from scratch (OpenXmlMemoryStreamDocument), i'm using PresentationDocument.Open() to create an existing file and clone files from another presentation to it.

The approach I took was, (PresentationBuilder modification),

(Base presentation denoted as B, to be cloned presentation is denoted as C)

Modify BuildPresentation() method to use B as the output file.

Use C as the SlideSource.

Comment out CopyPresentationParts() method as the output is not getting built from scratch.

The resultant output throws an error!

Base presentation:

ToBeCloned:

Error:

Output:

After some checking i found out that the two master slides has contains two separate layout slides with the same ID!

Issue:

After browsing through, for similar situations, I was able to apply the following as a fix.

In CopyMasterSlides(), at the end, use FixSlideLayoutIds() method to re arrange the layout slide id's.

A sample code with fix is attached as Post3.zip

Hope this will help any future enhancement of the PresentationBuilder code as well as anyone with a similar problem, while trying to experiment with its code.

Cheers,

YasiduY3K

Forum Post: Re: Open a docx file that is located in a folder on the server

Eric White — Tue, 14 May 2013 15:04:00 GMT

This certainly is possible. If you can open the file using Word then you could also open the file using the open XML sdk.

Then you can start word to enable e end user to edit it.

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: merging word-documents with DocumentFormat.OpenXml(c#)

Tennyson — Thu, 09 May 2013 09:18:00 GMT

Hi, i happened to used this word document merging sdk in c# to help my image programming work which includes the merge of two or more word documents, it works well, have a try. And, what's more, it also can merge pdf documents, which i thinks you maybe also need this source.

Forum Post: Re: getting error "File contains corrupted data" when trying to open excel file using OpenXML

yogesh — Thu, 09 May 2013 09:09:00 GMT

Hi Eric,

Thanks for reply.

I got the examples from site. Now I images are working fine.

I have one DOCX file. It has some contents in the "Trebuchet MS" font. It not converting correctly.

I can attach DOCX file and HTML file in this post. But not able to find any attach option. If you can provide your email ID, I can send you those files.

Thanks,

Yogesh

Forum Post: Using Custom UI Editor if statement when file name is .pptx

y0gster — Thu, 09 May 2013 08:47:00 GMT

i just found this Custom UI Editor while searching for a way to have an onload event on Powerpoint. Now I need is an if statement in the UI editor that would prevent it from running when the file extension is pptx. Here is the line of code im using in customui:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"   onLoad="onLoadCode" >  </customUI>

I can write the code in vba but here in xml im totally lost. What I was thinking was something like this which I wrote in vba:

if right(filename,4) = "pptm" then  onLoad  ="onLoadCode"   end if

Forum Post: Re: Lock Cell of Worksheet

kaushal.jani@valuechain.co.in — Thu, 09 May 2013 08:20:00 GMT

Hi Eric,

Just I got the video running.

Thanks for your efforts,

Appreciated.

Regards,

Kaushal Jani

Forum Post: Re: How to copy slide that contains A hyperlink using PresentationBuilder ?

Eric White — Thu, 09 May 2013 04:45:00 GMT

Hi cYounes,

I've tried just about every combination I can with this, and it works for me. Can you share the presentation that contains the hyperlink?

Forum Post: Re: Applying a Slide Master to a Presentation

YasiduY3K — Thu, 09 May 2013 04:35:00 GMT

Hi,

Aspose is faster. but they sucks!

I tried using Aspose for my projects, but they always throws out errors. I got errors with cloning, slidenumbering, powerpoint object formatting etc.

May be it's because of the earliest version of their PPTX version, but I was ultimately fed up providing them sample codes to clarify the issues and waiting for long ETA's till they come up with fixes.

But there powerpoint 03 version is really good.

My advice is stick with openxml, even u encounter an issue, you will have a code base to work it out.

Forum Post: Re: Removing images from a PPTX (and not breaking any relations)

Eric White — Wed, 08 May 2013 17:50:00 GMT

You will be amazed at how fast it is, though. Once you write the correct code, it still will operate nearly instantaneously.

Forum Post: Re: Copy SlideMasterlayout element into the Slide

Eric White — Wed, 08 May 2013 17:46:00 GMT

Hi,

I've put together a PresentationBuilder resource center (openxmldeveloper.org/.../presentationbuilder.aspx) that contains a link to download the code, as well as links to the various screen-casts that you will want to watch. You can learn a lot about PresentationML if you watch those screen-casts.

Best, Eric

Forum Post: Re: Automatically open/close embedded OLE object

Russell Pierce — Wed, 08 May 2013 14:49:00 GMT

Eric,

Thanks for the link. Though I have watched a lot of videos on openxmldeveloper.org, I had not yet come across that one. This blog post and the accompanying video demonstrate how to programmatically embed a spreadsheet into a Word document using Open XML. It also shows how you can specify an arbitrary "place holder" image like what you describe in your video.

(blogs.msdn.com/.../embedding-an-open-xml-file-in-another-open-xml-file.aspx)

So, the takeaway here for anyone else who's in my boat is this:

You can't embed a spreadsheet into a presentation and have it come out looking "right." In the case of embedding a new sheet, there will be a default placeholder image: "This image cannot currently be displayed." In the case of updating, the out-of-date image will display.