Posted by jpluimers on 2013/04/16
So I won’t forget to research this:
Somehow this occurs with Excel and the .NET app only having a few dozen megabytes of memory in use, so the cause must be something a lot more simple than “out of memory”.
It is a complex export, but I might just be able to get this going using ADO.NET, and make sure it is not a 60+k rows or 60+k characters issue.
–jeroen
Posted in .NET, .NET 4.0, C#, C# 4.0, Development, Excel, Office, Power User, Software Development, Visual Studio 2010, WinForms | Leave a Comment »
Posted by jpluimers on 2013/03/04
Question: How do you make Excel print those cell lines?
Thanks seb32:
I’m assuming you want to print the grid…
- File menu,
- Page Setup,
- go to the Sheet tab,
- On that page, under Print, there’s a checkbox called “Gridlines”.
Note: the above is for Excel 2003; Print Gridlines in Excel shows that Excel 2007 and 2010 have slightly different settings.
–jeroen
via:
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2013/02/15
A while ago, I salvaged the Windows Mail *.eml files from a broken Vista machine of a friend to a new machine running Outlook. The Vista machine was so broken that it wouldn’t boot any more (now he knows that porn comes with truckloads of viruses).
Naively I assumed this was a straightforward process (hey, it’s all Microsoft, and they have great interoperability, right?).
Well no (:
So as soon as you have all mail in Windows Mail, then you can export it to Outlook.
You can do the same with *.dbx files from Outlook Express: use Windows Mail as an intermediate store as described here: Importing DBX files into Outlook 2007 – Windows Software.
But first things first.
Posted in Office, Office 2003, Office 2007, Office 2010, Office 2013, Outlook, Power User | Leave a Comment »
Posted by jpluimers on 2013/01/28
A quick and easy way of getting the CurrentCulture and CurrentUICulture is to use the get-host cmdlet from PowerShell.
This is what PowerShell 2.0 shows on my system:
C:\Users\jeroenp>powershell get-host Name : ConsoleHost Version : 2.0 InstanceId : 1ce173fb-70a7-403b-a2bd-3800fe740f7c UI : System.Management.Automation.Internal.Host.InternalHostUserInterface CurrentCulture : en-IE CurrentUICulture : en-US PrivateData : Microsoft.PowerShell.ConsoleHost+ConsoleColorProxy IsRunspacePushed : False Runspace : System.Management.Automation.Runspaces.LocalRunspace
The SeaTools from Seagate can’t cope with that because they don’t manage the Resource Fallback Process properly.
My machine is on en-IE, as it is English, and USA as location.
The main advantage for me is to use the that it is a good mix between English and Dutch settings:
–jeroen
via: Get-Host.
Posted in .NET, CSV, Development, Excel, ISO 8601, Office, Power User, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2013/01/17
Last year, I missed this tiny sentence:
So in plain English, any VM that was generated on VMware ESX Server 3.5 or later can run atop ESXi 5.1 unchanged.
Which means it is a snap to move your VMs from older ESX / ESXi / vSphere versions as long as they are ESX 3.x or later.
In fact hardware version 7 has the widest compatibility amongst ESX/ESXi/vSphere/Fusion/Workstation/Player versions (see the table at the bottom).
The free version still has a 32 gigabyte physical RAM limit (people are still confused by the vRAM / Physical RAM distinction, especially since vRAM is not limited any more). Read the rest of this entry »
Posted in ESXi4, ESXi5, ESXi5.1, Excel, Fusion, Power User, VMware, VMware ESXi, VMware Workstation, Word | Tagged: computer, hardware version, hardware versions, machine hardware, physical ram, software, technology, version compatibility, virtual hardware, virtual machine, virtual machines, vm, vms | Leave a Comment »
Posted by jpluimers on 2013/01/17
Every once in a while, Office Communicator indicates a contact is not off-line and allows me to send messages to him/her, but then gives an error 504.
The reason is that the off-line status replicates slowly, so you were not aware your contact went off-line while typing the message.
The Error ID 504 is just an unfrienly way of saying “your contact went off-line, but you didn’t know that when sending the message, and I don’t have a friendly way of telling you this”.
–jeroen
via: Communicator 2007 R2 Help on Error ID 504.
Posted in Communicator, Office, Power User, Windows, Windows 7, Windows XP | Leave a Comment »
Posted by jpluimers on 2012/12/28
One thing I always forget (especially since the UI in Office 2007 changed quite a bit, but the idea below gets me going).
I’m assuming you want to print the grid…
- File > Page Setup,
- then go to the Sheet tab.
- On that page, under Print, there’s a checkbox called “Gridlines”.
–jeroen
via How do you make Excel print those cell lines? – AfterDawn: Forums.
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
Not!
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
–jeroen
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/09/17
Learned a few Excel keyboard shortcut pairs today:
| Shortcut | Action |
|---|---|
| Ctrl+Spacebar | Select columns |
| Shift+Spacebar | Select rows |
| Ctrl+; | Current date |
| Ctrl+Shift+: | Current time |
| Ctrl+Shift+2 | Format current cell as default date |
| Ctrl+Shift+3 | Format current cell as default time |
–jeroen
via:
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/09/06
The problem with localized error messages often is that it is virtually impossible to find information about them.
For instance the below error got reported by a client for me to fix (click on the picture to get a larger version) has a few big problems:
Posted in Excel, Office, Power User, Windows | Tagged: ctrl c, english versions, error messages, file formats, google, message box, microsoft com downloads, microsoft office online, office excel, office microsoft, pleonasm, software, technology, zero results | 2 Comments »
The Wiert Corner - irregular stream of stuff 