Feeds

back to article Microsoft advertises Surface, Excel with maths mistake

Microsoft's Surface tablets have again embarrassed the company's bottom line, this time after failing to calculate a simple one accurately. The problem was spotted by folks at Apple Insider who noticed a San Francisco billboard advertising Redmond's latest tablet. When they peered at it closely in the image below, they noticed …

COMMENTS

This topic is closed for new posts.

Page:

Excel reall doesn't excell...

Try dealing with serial number 000085545 for one part, and serial number 85545 for a different part....

7
12
Silver badge

Even if you're careful to make sure they're entered as text entries?

17
3
Anonymous Coward

Indeed. I deal with varied part numbers like "546-239" and "5403765" - if left to its own devices, Excel will interpret "546-239" as a mathematical formula and enter the result in the cell. Simply change the entire column to Text and you'll be fine.

0
4

just put a quote in front of the text field (your serial number), like '000085545

4
1
Silver badge

Expenses?

That looks incredibly like the expenses sheet of one of our Members of Parliament.

The excuse will be, 'it was a genuine mistake and I apologise for it, thank you for bringing it to my attention'

The only thing missing is the second page.

12
0
DJO
Bronze badge

Excel does try to be helpful, I just wish it wouldn't.

Try a really long serial number or something like an SIM numbers with about 20 digits then unless you prefix it with an apostrophe or something to make sure it treated as text then Excel will be helpful and throw away the last few digits and display it in scientific notation, really helpful that. No too much of an issue if entering by hand but when you are getting lot's of data in CSV files it can be a bit of a problem - I've had to write pre-processors to modify CSV files before loading them into Excel to ensure Excel doesn't trash the content.

7
1
Silver badge

Re: Excel does try to be helpful, I just wish it wouldn't.

just change the default formatting to text for those columns. Easy (we use roll numbers padded with leading zeros - effectively text as no mathematical calulations occur on them).

1
1
Anonymous Coward

Hmmm and now try get a column containing 000846383 to load as text from a CSV.

5
3
Silver badge

"Hmmm and now try get a column containing 000846383 to load as text from a CSV."

It will in LibreOffice as long as ALL that column is to be text. You need to select the column in the import preview and change it's type from the pull-down menu to 'text'

With Excel I can't remember although I used to import VERY large CSVs once upon a time.

2
0
Bronze badge

Your problem is NOT EXCEL

Your problem is creating a numbering or identification system that uses zeros as place holders.

1
12

@Dan Paul Re: Your problem is NOT EXCEL

What if someone else has already did that for you? Anyone who deals with UPCs knows what I am talking about. Don't be so quick to judge. Excel should do what it's told, not guess.

7
1
Bronze badge

@AC 17:49

"Hmmm and now try get a column containing 000846383 to load as text from a CSV."

No problem, when opening a CSV Excel asks you what format you want each column to be, if you actually pay attention to each page of the wizard.

3
0
Bronze badge

Re: @Dan Paul Your problem is NOT EXCEL

It doesn't guess, it can only do what it's told and text is the only way to make it represent the zeros and not truncate the number because it wasn't designed to represent numbers that way but the fact remains why the fuck in gods green earth would anyone have ever devised an identification system that uses zeros as placeholders?

Excel truncates these "numbers" because zeros have no value in the front of a numeric string, only after a number!

I don't care what the reasoning is, the concept of using them as placeholders is daft. If you keep letting idiots make stupid decisions then you get what you deserve. If a character series must have placeholders then make it alpha numeric to begin with.

In most cases if you are the one creating the system, a little planning and forethought can avoid things like this. Doing the same thing repeatedly and expecting better results is the very definition of insanity. Doing things "the way it's always been done" often brings results you won't like.

AGAIN Your problem is the system you designed or inherited NOT EXCEL. How about some more downvotes for speaking the truth.

0
0

Re: @Dan Paul Your problem is NOT EXCEL

I agree with you on designing systems with zeros as placeholders. It is nuts. However, when one is forced upon you, there is little choice. But again, this does not excuse Excel guessing that my "00032653453" is a number.

Any programmer worthy of their title should know that it's a string. It seems to me that Excel is looking at the string of characters to import, finds that there's no letter in it, but only digits, and says "it's a number". Wrong.

If they had to make it so that it parses the string at import time, they should have left all fields as text and let the user decide either in the wizard or after import what the data type is.

Same for long integers being shown in exponential format. Very annoying. Excel should either import it as a string, or leave it as a number (if it fits in the 4 bytes data type or whatever Excel is using internally), but show it to me how it is in the original file, do not assume it's an exponential number.

0
0
Unhappy

Part of the problem there is data import....

Where the person opening a delimited file, or importing it into Excel:

1) Doesn't know enough to customize the import - taking the extra step to define certain columns as "Text" or something other than rather than the default "General" (there can be numerous reasons they are ignorant as to the need for this);

and/or

2) Doesn't know the data well enough to realize there are leading zeroes in it.

Re: 2) zip codes and postal codes regularly have leading zeroes, and anyone who learns Excel or who claims to be an "expert" user should know the General format will truncate these during import.

A good deal of the problem derives from failure to grasp the difference between a database and a spreadsheet, meaning Excel is too often employed in aid of tasks for which it it was not originally designed, and for which it is not the best choice, e.g., for mailing and contact lists.

However, it's nonetheless ridiculous Excel's import routine doesn't deal with leading zeroes in some intelligent way, such as ASKING the user about them during import, or giving a warning when the user clicks "Finish". Maybe a quick pop-up noting leading zeroes exist, and will be removed unless the column format is changed to Text? Giving users a "Go back" button, allowing them to fix the problem before finalizing the import? How hard would that be, really?

On a larger level, this is only a small example of how "User friendly" simply isn't. Microsoft certainly doesn't care to change that, and neither does the IT industry as a whole, given that truly user-friendly hardware and software tends to reduce profits.

Yes I'm cynical, but only because it's so often true.

0
0

Quite easy...

If you actually know how to do an import, and perform all the steps, including the one where you view the columns, and can change the format of any or all BEFORE you click Finish. Try clicking "Next" sometime, until you run out of "Next" buttons, and read what's on the screen.

That said, however: per my longer comment, it is pretty ridiculous that Excel doesn't pop up a leading-zeroes or long-number warning when one clicks "Finish."

Not everyone is going to be intimately familiar with the data being imported. More to the point, data is not always completely clean.

There's nothing stupider than software that after this many years still fails to tag common, repeated, well-known import errors.

0
0
Anonymous Coward

El Reg not a travel expert

"Such folk might also wonder why anyone would spend $9500 on a trip to Hawaii when the diving's pretty fine around the Caribbean, the surf and diving can be good in Mexico and hotels likely far cheaper in both destinations."

Because you are not a travel agent nor, apparently, have you sought the opinion of one.

Mexico, outside the tourist belt of Cancun, has been suffering from drug gang-related violence and has travel warnings issued from almost all major countries. Even the tourist area of Acapulco is no longer completely safe and Puerto Vallarta had safety concerns in 2011 caused Princess Cruises to cancel trips. Touring around the interior of Mexico has not been recommended by several major foreign governments in comparison to Hawaii, which has some of the most beautiful scenery on planet Earth.

Caribbean has some fantastic diving. But if you live an 'alternate lifestyle", or have empathy for the conditions of those who do, many places in the Caribbean are highly homophobic to the point of legislation. For diving, both the Bahamas and Turks & Caicos are friendly and have beautiful snorkeling and scuba with good flights from almost all major international cities.

8
3
jjk

Re: El Reg not a travel expert

I think that actually was a dig at the people who scoff at Apple buyers because Android HW is cheaper...

0
2
Bronze badge
Joke

Re: El Reg not a travel expert

I'm surprised TheReg doesn't promote "The English Riviera" or Blackpool. Or Stoke.

3
0
Silver badge

Re: El Reg not a travel expert

Southport has better restaurant. Ho Lee Chows is fantastic (on rotten row).

0
0
Silver badge

Recalculate ?

"rows to the value of $500 were inserted into the spreadsheet but somebody forgot to press F9 in order to recalculate the spreadsheet formulae."

Why would you have turned off auto mode ? I rarely did even when I had huge sheets. Recalculate was pretty quick.

Even on this old 1.6GHz Celeron laptop using LibreOffice I've just altered the first value in a set of 400000 sine calculations each dependent on the another and it took < 1sec

16
1
Facepalm

Re: Recalculate ?

Curiously, although the cell with the value of £500 for the Car hire is highlighted, there's nothing showing in the formula bar at the top.

Looks like an airbrushing fail to me.

6
0

Re: Recalculate ?

Or even more likely a formula fail where they forgot to include the last two entries when they made the sum... That would account for the $500.

4
0

Re: Recalculate ?

Or perhaps it started as a Google Docs spreadsheet. When they realized that's not the best advert, they downloaded it as an xlsx file and modified the resulting spreadsheet in Excel. Unfortunately when you do the download all the formulas are replaced with values.

0
3
Silver badge

Far more likely that this is an ad agency mock-up than anything to do with formulas and recalculation.

Ad agencies are cretins.

13
0
Silver badge

That was my first thought too. Unless you're working on complex formulae with millions of cells (in which case Excel is probably the wrong tool) no-one has turned auto-recalc off since 1993. Still, you wouldn't expect a 'creative' to be cluttering their minds with addition, would you?

7
1
Bronze badge

Within the last couple of years I've had test case spreadsheets (yes I know, but when the budget doesn't extend to test case repositories or investigation time of open source alternatives....) whereby the totals haven't recalculated properly, especially noticable with the wiki plugin which mapped these totals onto a pie chart. The small number of failed test cases were suddenly a big red slice.

0
0

...probably mocked up in power-point at that.....

2
0
Silver badge
Linux

The gift that keeps on giving

Don't worry microsoft, no matter how much you continually screw up your own products you've still got $2bn per year from extorting money from one you can never hope to come close to in a biilion years.

16
4
Anonymous Coward

Re: The gift that keeps on giving

If Android uses non-FRAND MS' technologies, the companies producing it have to pay.

Google could produce an alternative to FAT32/ExFAT (which seems the main issue), but they don't seem to be bothered.

3
10
Silver badge

Re: The gift that keeps on giving

"Google could produce an alternative to FAT32/ExFAT"

There are many excellent alternatives but as most gadgets and new sticks/cards use one of the FATs then it would cause all sorts of problems to switch.

9
0

Re: The gift that keeps on giving

Ah yes the good old Microsoft locked in syndrome kicks in again. If Microsoft didnt use closed standards to begin with we would all be in a better state

12
1

Re: The gift that keeps on giving

Google don't support external memory cards on the Nexus 4/5, and only support MTP via USB rather than file access. I assume that this allows them to use ext3 internally and not pay a FAT license fee.

5
0

Re: The gift that keeps on giving

Why not just split off the Office division and then sue the third party companies that include Office in their product, double dipping at its finest ...

0
0
Bronze badge

Re: The gift that keeps on giving

IIRC, the real problem is that FAT/FAT32 weren't patented when Linux (and other unixes) added support for the filesystems. It was only later, after it became the de facto standard for USB drives, that MS decided to patent it. And for some bizarre reason the patent appears to have survived several challenges.

6
0
Anonymous Coward

Re: The gift that keeps on giving

No, it's always been patented, a software company the size of MS doesn't forget to patent something as fundamental as their main filesystem.

3
0
Bronze badge

Re: The gift that keeps on giving

I bought an SD card formatted FAT32. I didn't see any restrictions in the instructions restricting its use to certain OSs. So I figure I have an implied license to read it as I wish.

1
1
Silver badge

Re: The gift that keeps on giving

ExFAT is patented so as to be impossible to implement if you don't pay the tax. FAT32 is only patented if the device understands Win 95-style long file names (and some argue read OR write LFNs but not both). Symbian 3 devices display LFNs in lower case which may also be a way around it. The solution is not to implement support for Win 95-style LFNs or if you've got good lawyers limited support for them.

3
0

Re: The gift that keeps on giving

>> If Android uses non-FRAND MS' technologies, the companies producing it have to pay.

If by M$' technologies, you mean broad, generalised, vague, and pre-mobile patents that should have been invalidated years ago, then yes.

>> Google could produce an alternative to FAT32/ExFAT (which seems the main issue), but they don't seem to be bothered.

They don't need to. EXT-4 is already far superior to FAT. The only reason it's included in some android OEM builds is for Windows platform (PC) support. It's unlikely Micro$haft will support any other file system except their own patent encumbered ones, ensuring a stream of revenue from pay up or else patent extortion schemes.

The good news is that the Nexus line of devices eschews sd ports, so that pretty much eliminates the need for FAT support. Of course that still doesn't stop M$ from abusing other broad and dubious patents to extort Android.

The FAT patent in question revolves around the storage of short/long file names, something that's both obvious and has prior art anyway. Clearly software patents in general need to be abolished globally, because it enables evil companies like Micro$haft to bully would-be competitors and forcibly hold on to its creaking desktop PC monopoly.

It won't matter in a few years anyway though, as M$ will be reduced to enterprise exclusivity, and patent trolling only. They're finished in the consumer market. And eventually they'll get kicked out of the enterprise market too.

10
4
Silver badge

Re: The gift that keeps on giving

Id rather they add the fee to the device so I can have an SD port. Shame my S2 doesnt support 64gb SD cards my 32 is full :(

2
0

Re: The gift that keeps on giving

You see, someone has to start using a different file system on portable media. If not Google, that has their OS on millions of devices, then who? It will get traction, if not overnight. If they would have started 3 years ago, everyone would have used it by now. But if they don't start, you have to assume that they are Ok with Android hardware manufacturers paying the Microsoft toll.

What's the big deal anyway in pushing another file system on a MicroSD card? You use it natively on Android, and for reading/writing it on Windows and Mac, you would install a small application.

4
0
Silver badge

Re: The gift that keeps on giving

> for reading/writing it on Windows and Mac, you would install a small application.

That is one of the reasons that Microsoft is moving to the walled garden model. On RT and WP8 - NO, you will NOT install a small app to do that. On Windows 9 it may be that NO, you will NOT install a small application either, we shall see.

0
0
Silver badge

Re: The gift that keeps on giving

UDF is a filesystem which should work on every OS released from XP onwards (OS X and Linux included), possibly even RT too. It's just a case of a big-enough company getting behind it. I think Google could push it if they wanted to, they made people download Android File Transfer for OS X for MTP.

1
0
Silver badge

Re: The gift that keeps on giving

"ExFAT is patented so as to be impossible to implement if you don't pay the tax. "

And, of course, the fact that there was prior art a mile long didn't affect the validity of the patent at all.

1
0
Bronze badge
Thumb Up

@ Dan55 Re: exFAT

Thanks for the concise and informative explanation

0
0
Silver badge

Excel

reinventing new ways of making it impossible to implement 40 years of good software practice.

Saying simply change the column type to text is all well and good but someone has to realise there is a problem first.

Mind you I can make a good fortnights holiday in Cancun with a stop over in Hawaii for doing just that for some poor desperate sod who is under the illusion that software is easy.

7
2
Silver badge

Re: Excel

"Saying simply change the column type to text is all well and good but someone has to realise there is a problem first."

Isn't that a bit like blaming the hammer, if you decide to use a hammer to paint your walls?

5
3
N2
Bronze badge

calculators?

Not needed for such a simple addition

7
0
Bronze badge

Re: calculators?

If you are numerate, you should be working, not commenting.

1
6
N2
Bronze badge

Re: calculators?

Work? I gave up that nonsense years ago.

Its a Jour Farie here in France for Armistice day, so march through village for service at war memorial followed by a petite anisette avec mon voisin.

5
0

Page:

This topic is closed for new posts.