Geek Rant dot org

 

Wed 2006-06-07

Quick look at Google Spreadsheets

Filed under: — daniel @ 20:54

Here’s what it looks like. Click it to see it bigger.

Google spreadsheet

Not bad, but looks very simple compared to Excel. This could be a good or a bad thing. Does a lot of Excel-like things. This kind of comparison is inevitable, as most users are familiar with it.

Doesn’t feel as refined as Writely. Right-click not harnessed.

Linked to your Gmail/Google logon, of course.

Exports a reasonably clean HTML table. (Certainly better than any released versions of Excel/Office.)

Watch out if you lose your connection:

Google spreadsheet lost connection

My immediate reaction is this could be useful for some things — like Writely, if you want to be able to edit from anywhere connected, and/or share the document realtime with others.

But like Scoble, I can’t see it replacing “offline” apps for individual users just yet. Hosted apps within a corporation however, that could (eventually) be another matter, especially as the technology matures.

See also: Josh and I look at Writely.

Digg this

Tue 2006-06-06

Google spreadsheet soon

Filed under: — daniel @ 12:59

It’s widely reported that Google will be releasing an online spreadsheet on the 6/6/2006 (presumably US time).

Probably limited signup initially, but keep an eye on spreadsheet.google.com, which is currently showing a 404 (rather than a “Host not found”).

Update 20:15. Sneak peak and sign-up (they’ll email you when it’s available).

Update 22:00. Now at spreadsheet.google.com I get “Server Error. The server encountered a temporary error and could not complete your request. Please try again in 30 seconds.”

Digg this

Wed 2006-05-10

Outlook Attachments Unattached

Filed under: — tony @ 14:24

If you’re looking for an easy way around “Outlook’s dumbarse ‘protecting you from shadows’ attachment filter” download and install this handy attachment options extension for Outlook. It allows you to specify which level 1 attachments to let through; very handy if you have someone mailing you Access databases.

Digg this

Mon 2006-05-01

Search Upgrade

Filed under: — tony @ 10:39

I’ve been a huge fan of Microsoft’s Desktop Search since it was released, it has changed the way I use my PC and is amongst the first things I install on new PCs. I dream of the day they integrate it with their recently purchase, Foldershare (A magnificent free product that allows you to sync your files seamlessly over the net using P2P technology. It also allows you to search and download from any of your computers from any net connected PC as long as your PCs are turned on. Try it now if you have more than one PC and you want to keep files in sync across them.).

To get an improved version of Desktop Search download the beta of the Windows Live Toolbar. The toolbar doesn’t work in Firefox but it does allow you to update Desktop Search and gain a couple of great features. It installs a new toolbar in Outlook that allows you to save Desktop searches as virtual folders within Outlook - so now Outlook can display search results that include files as well as emails/tasks/appointments. It also changes the Windows default search function (found on the Start menu) to use Desktop Search which means the end of searches that won’t ever find what you’re looking for.

Digg this

Tue 2006-04-04

Word’s insistence on US English

Filed under: — daniel @ 07:15

Word: Formatted - US EnglishAnybody who lives outside the US will know that Microsoft Word does evil things, with little bits of text changing unaccountably into US English at seemingly random times. Suddenly a perfectly spelt word like… well, spelt could be a contender actually, will get that curly red line underneath it.

And I’ve seen proof. Yesterday I was working on a document with revision marking turned on, and low-and-behold, in the middle of editing, it claimed I’d reformatted a table cell to be US English. But I hadn’t. Tried to undo it, and couldn’t.

Evil, that’s what it is. Evil. Particularly since my Word default is EN-AU, which also matches my Windows regional settings.

Next thing you know, it’ll be switching my A4 paper to Letter, as well.

Digg this

Fri 2006-02-17

Office 2007 announced - Frontpage dumped

Filed under: — daniel @ 10:21

Microsoft has announced the naming of the next version of Office (2007, big surprise), along with initial US pricing and suite variants.

Frontpage is being dumped, in favour of the new Expression web editor (for web design), and Sharepoint Server and Designer (for sharing data in Office documents).

Digg this

Fri 2005-12-23

MS Word footers are buggy

Filed under: — daniel @ 14:12

I thought I was going crazy the other week. I had a Word document, overdue for sending to a professional printers, with an incorrect footer on pages 7 and 8.

So I tried to fix it. Double-click on the footer. Amend “September” to “December”, like this:

Editing the page footer in Word

Click the Close button on the header/footer toolbar… and it changed back to “September”.

Page footer in Word

I swear, I must have messed with the thing for about half an hour, trying it over and over, even trying to blank out the footer completely. The change just would not stick. Turning on and off the “Same as previous section” didn’t seem to help either. I tried it on my main machine (Office 2003) and the other one (Office XP). Same result. Somehow, somewhere, it was remembering September.

Possibly it’s something to do with all the sections I have in this document. It’s a newsletter, and has a mix of 3 column (article) and 1 column (heading) sections. Not that it’s any excuse. But perhaps it’s a fairly obscure problem; there’s certainly nothing about it that I could find in the KB.

Eventually I somehow managed to get it fixed on page 7. Page 8 wouldn’t stick though. Given it was past the deadline, I gave up and sent it off to the printers as it was. Hopefully nobody would notice.

A couple of it got shot through to Tony. He found the same thing. He got Rae to try, and… she fixed it. And couldn’t understand what the fuss was about.

Later on I figured it out. If you double-click on the footer, things can go wrong. But if you go via the menus: View / Header and Footer, you’ll be okay. Bizarre.

Mind you, when you change it this way, it temporarily throws the page count and repagination right out. In this case, it suddenly thought it was on page 10 (when actually there were only 8 pages).

Editing the page footer in Word

Still, the document was finally fixed, and the superb people at Flash Print in Collingwood (Melbourne), used the fixed version on the job, even though the file was 24 hours late.

But my conclusion? Page headers and footers are buggy when using lots of sections. Another item for the MS Word bug bucket.

Digg this

Thu 2005-11-17

How to stop Outlook hiding line breaks

Filed under: — daniel @ 19:38

One of my most hated things from recent versions of Outlook is the way it edits plain text messages by chopping out supposedly extra line breaks. Inevitably, they’re not extra — they’re there because the sender doesn’t like hitting enter twice between paragraphs — particularly when writing short lists of things.

Outlook does give you the option of restoring the linebreaks it’s taken away by clicking an option near the top of the message. It’s a right pain to have to keep doing it on every message though.

Outlook hides linebreaks

In Outlook XP, I never found a way to turn this off. Maybe it was there, but very well hidden.

Fortunately in Outlook 2003 it’s possible to turn it off for good, though the online help is no help at all at finding it.

Here’s how you do it: Tools / Options / Preferences tab / E-Mail section / click E-mail options. Then find and turn off the checkbox “Remove extra line breaks in plain text messages”.

(Note that after turning it permanently off, it still happens if you’ve been mucking about in a message beforehand, shown the “extra” linebreaks, then hidden them again and saved the message.)

Digg this

Fri 2005-11-11

Irritating things in Word templates

Filed under: — daniel @ 17:13

I’ve been working with somebody else’s template. Irritating things have included:

  • Use of mirror margins — these have a marginal (ha!) effect on the presentation when printed double-sided on paper, but are really annoying when editing on screen. As your eye passes down the page, at each page-break everything moves over a little way, left-to-right, right-to-left. Particularly jarring when looking at columns or tables that go over two or more pages. To turn it off: File / Page Setup / Set Multiple Pages to Normal.
  • Default font size 12 point — is anybody that blind or in that much need to use up trees that they use 12 point for a default? Fortunately one can change the Normal style to another size, and provided the other styles are based on it, everything follows.
  • Trying to decypher and fill-in confusing bits in the template. But that’s not a Word problem, per se.
Digg this

Fri 2005-10-28

How to hide or move the followup flag column in Outlook 2003

Filed under: — daniel @ 17:42

Outlook flagsI’m sure in older versions of Outlook, the Followup Flag was somewhere on the left hand side, and that’s still where I’m used to seeing it. But in Outlook 2003, it’s on the right, and apparently can’t be moved. Unlike the other columns, it’s not draggable, and if you go into the dialog box that sorts the columns, no matter where you think you’ve moved it, it stays put on the right hand side.

It turns out you have to employ some special trickery to move it. In the Other Settings, there is an option called Quick Flags. This needs to be turned off to hide or move the column.

The down side is, Quick Flags does nifty things, with a left-click alternating between setting a red flag, and ticking off (to show a task is completed). It also provides a special right-click menu that allows quick access to the flags (hence the name), instead of via the main right-click menu via the Followup option. MS, in their wisdom, made all this only work when the Flags are in the rightmost column. Weird.

Digg this

Mon 2005-10-17

Hiding Excel warnings during automation

Filed under: — daniel @ 18:26

Well, I sorted out my problem of confusing warnings appearing whilst controlling Excel with VBA. Turns out there is an Application.DisplayAlerts property which, when set to false, hides warnings such as the one I was getting. It took a little Googling to find the solution, which wasn’t readily apparently in any of the MS help for the methods I’d got the warnings from.

The other Office applications also have a DisplayAlerts property.

Digg this

Sat 2005-10-15

Needless Excel automation warnings

Filed under: — daniel @ 07:48

Okay, this is annoying. I’m working on a VB program that uses the Excel object library to automate a fairly complex update into Excel. The general idea when you’re automating Excel is to smoothly do your operation behind-the-scenes, to hide the complexity from the user.

Excel warning

So the last thing you need is complicated dialog boxes popping up to ask the user questions. I’m the programmer: I’m meant to make the decisions. Tell me, the programmer, that if I save this Shared Workbook with a password that certain parts of the file won’t be encrypted. Don’t tell my user, and ask them to decide if it should happen or not.

Digg this

31 queries. 0.472 seconds. Powered by WordPress