Archive

Archive for the ‘office-software’ Category

Inserting Word Building Blocks from Template using Ribbon or QAT

2016/06/22 Leave a comment

Either insert from Ribbon / Insert / Quickparts: image

Or for extra speed and convenience, you can have your template store access to your building from the Quick Access Toolbar: image

Demo video is here.

Categories: office-software, training Tags: , , ,

How to prevent OneNote from crashing when hovering over search results

2015/10/28 Leave a comment
  1. Problem: In a strange new development, my OneNote crashes (multiple times, until things eventually become stable again) when I search my notebooks  from the upper right search box. Specifically, as soon as I hover my mouse over the search results display.
  2. My environment: OneNote 2013 32-bit on Windows 7 64-bit. These are notebooks on a network share, and they are updated from multiple machines. Not aware of any recent changes to my mouse settings or drivers.
  3. My Workaround: Navigate the search results using the keyboard. This seems to prevent those crashes.
Categories: office-software, service-is-testing-troubleshooting-debugging Tags: ,

Yet another couple of glitches solved in setting up Outlook 2013 with Gmail IMAP for GoogleApps

2014/12/19 Leave a comment
  1. I googled and followed this useful guide. However, a couple of glitches remained:
  2. Connection to Incoming mail server fails if you really just put your username:
    1. put instead of  username@companygoogledomain.com:
    2. image
  3. Test send of email message through outgoing server fails if you just followed instructions:
    1. image
    2. Click on button: “More” / tab: “Outgoing Server” / do check box “My outgoing server requires authentication ”  and log on (I now prefer to be explicit, after the initial mixup of usernames for incoming and outgoing), enter your full user@compgoogledomain.com and password. No need to enable SPA, though.
    3. image
  4. Viola  image Smile(and quousque tandem…, sigh Sad smile).
Categories: e-infrastructure, office-software Tags: , , ,

A little addendum about data types to the +N(“comment”) in-cell formula comment trick in Excel

2014/12/18 Leave a comment
    1. You are relying with this well-documented trick on the fact that addition of 0 will altering a numeric value.
    2. However, what is not mentioned: not all work in Excel involves the number data type.
      1. Try adding your comment or zero to a string data type, and you will get a #VALUE error.
      2. Boolean, however, works also, since – as you can see when you have Excel evaluate your formula – if  you try adding 0 to a Boolean data type, Excel casts the prior Boolean FALSE to 0 or TRUE to 1, and casts the result of your addition (of 0 = nothing) back to the same initial Boolean for further evaluation. excel-evaluate-fromula-w-n-comment boolean
      3. So just put your +N()-comments in those part of your formula that involve either number or Boolean data type, and avoid adding to strings, for example:

=IF(
    OR(
        ISBLANK(
            [Related issues]
        ),
        (            ISERR(
                FIND(
                    “#“,
                    [Related issues]
                )
            ) )
    ) +
    N(
        “do nothing if no related task in col:related issues“
    ),
    ““,
    IF(
        NOT(
            ISERR(
                FIND(
                    “,“,
                    [Related issues]
                )
            )
        ) +
        N(
            “do nothing if no 2nd value in col:related issues“
        ),
        CONCATENATE(
            MID(
                MID(
                    [Related issues],
                    FIND(
                        “,“,
                        [Related issues]
                    ) + 2,
                    LEN(
                        [Related issues]
                    ) –
                    FIND(
                        “,“,
                        [Related issues]
                    ) + 1 +
                    N(
                        “extracted the 2nd value from col:related issues“
                    )
                ),
                FIND(
                    “#“,
                    MID(
                        [Related issues],
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) –
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                4
            ) +
            N(
                “extracted the 4# of id of related issue“
            ),
            MID(
                MID(
                    [Relatedissues],
                    FIND(
                        “,“,
                        [Relatedissues]
                    ) + 2,
                    LEN(
                        [Relatedissues]
                    ) –
                    FIND(
                        “,“,
                        [Relatedissues]
                    ) + 1
                ),
                FIND(
                    “ “,
                    MID(
                        [Related issues],
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) –
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                2 +
                N(
                    “appended to or from to the 4# of id of related issue“
                )
            )
        ),
        ““
    )
)

    1. This splits, extracts and copies values from a none to multi-value column for better sortability: image
Categories: e-infrastructure, office-software Tags: , ,

Customized Quick Access Toolbar

2014/11/18 Leave a comment

word-Customized-Quick-Access-Toolbar

Easing access to some important tools for serious  writing – and configuration that can not be done in a template,but is per machine…

Categories: animated-GIFs, office-software, training Tags: ,

Fun with MS-Word inserting boilerplate text from the Quick part gallery

2014/11/17 Leave a comment

word-quickparts

Consistency through reuse.

Categories: animated-GIFs, office-software, training Tags: , ,

Fun with MS-Word’s multilevel lists from the QAT style dropdown

2014/11/12 Leave a comment

fun-with-word-multilevel-lists-from-the-QAT-style-dropdown

Categories: animated-GIFs, office-software, training Tags: , , , , ,

How to fix MS-Word not creating PDF Bookmarks for your Headings

2014/10/29 Leave a comment
  1. Problem: No navigation bar in Acrobat Reader when viewing your PDF created from MS-Word.
  2. Solution: Check this setting first in the Save as PDF Options: image
  3. But: Word 2013’s  “Save as PDF” with “Create Bookmarks”  may remains greyed out since it won’t even see your own heading styles, even if you based these styles on the built-in heading styles (which are known to contain  “hidden magic” not easily replicated) , including their outline level, if
    1. Heading appears in Content control.
    2. Heading appears in Table.
  4. Workaround:
    1. Move headings out of Content Controls (you can still “lock”the text with Grouping, which will be enabled on the Developer Tab once you select at least a conten control and text (meant for form field labels).
    2. Move headings outside of tables.
Categories: Glitches&Errors, office-software, service-is-documenting Tags: , , , , , , , ,