Support

Expand all | Collapse all

How to get rid of Extra lines in Office Export documents

  • 1.  How to get rid of Extra lines in Office Export documents

    Posted 02-12-2018 14:41
    I'm using a simple template to export the items in to word document. However I'm getting a solid line before each section starts. How do I get rid of this? Please see attached template and out put.

    I need the JAMA hierarchy to be retained in the word doc.

    Thanks



    ------------------------------
    Sri

    Hill-Rom Clinical Workflow Solutions (CWS)
    ------------------------------

    Attachment(s)

    docx
    Support Template.docx   40K 1 version
    doc
    JAMA Support.doc   76K 1 version


  • 2.  RE: How to get rid of Extra lines in Office Export documents

    Posted 02-12-2018 16:15
    Try this:

     

    «TableStart:HEADING»

      «name»

    «TableEnd:HEADING»

    «TemplateStart:DEFAULTTEMPLATE»

    «name»

    «description»

    «TemplateEnd:DEFAULTTEMPLATE»


    regards
    Harald



    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 3.  RE: How to get rid of Extra lines in Office Export documents

    Posted 02-12-2018 16:37
    Herald,
    Thanks for the response. That did not help.

    ------------------------------
    Sri

    Hill-Rom Clinical Workflow Solutions (CWS)
    ------------------------------



  • 4.  RE: How to get rid of Extra lines in Office Export documents

    Posted 02-12-2018 20:00
    Hi Sri,
    Try this out, it might give you what you need.

    «TemplateStart:DEFAULTTEMPLATE»

    Name: «name»

    Description: «description»

    «TemplateEnd:DEFAULTTEMPLATE»



    ------------------------------
    Dana Medhaug
    Technical Support Engineer
    Jama Software
    ------------------------------



  • 5.  RE: How to get rid of Extra lines in Office Export documents

    Posted 03-20-2018 08:22
    Hi,

    i solved this issue with a macro:

    Sub Deleemptylines()

    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
    .Style = "Standard"
    .Text = "^p^p"
    .Replacement.Text = "^p"
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchByte = False
    .MatchAllWordForms = False
    .MatchSoundsLike = False
    .MatchWildcards = False
    .MatchFuzzy = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll

    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
    .Style = "Standard"
    .Text = "^p ^p"
    .Replacement.Text = "^p"
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchByte = False
    .MatchAllWordForms = False
    .MatchSoundsLike = False
    .MatchWildcards = False
    .MatchFuzzy = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll

    End Sub

    ------------------------------
    Christopher Nadler
    ------------------------------