|
via The Poke[^]
I had the last one this morning, panic ensued as I rebooted my lappie. It still didn't work - WTF! WTE! WTP!
Vilmos - switch on the WiFi router, switch it back on...
speramus in juniperus
|
|
|
|
|
I had the one with the internet not working at home most of the days over the last two weeks. It was the DSL modem that was getting old and needed replacement.
The good thing about pessimism is, that you are always either right or pleasently surprised.
|
|
|
|
|
Need help with Excel. I exported some data from SQL Server to Excel using the OpenRowSet function which includes some numeric columns (float in SQL Server). But no matter what I do, Excel treats it as Text. I tried formatting the cells to number, but no use.
If I create a Chart out of the data, the values are assumed to be 0 (or NULL) and the Chart is always empty. I checked by negating one of the values and the Chart does recognize it as a number and update itself. I can't edit each cell by hand since there are 50,000 cells to be edited. Got a solution?
|
|
|
|
|
Add a plus : "+Value" instead of "Value".
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Several options.
First, Highlight the column or range. Right Click. Format Cells. General
If that does not work:
Go to cell to the right, type "=VALUE(Cell address). Copy to bottom of range. Copy new range. Paste Special as Values into the previous cell range.
Failing that:
Ensure the DB has the number formatted correctly, wrap the field with an explicit conversion function (eg =CDbl(Fields!Example_Total.Value) or some such thing).
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
|
Now that they're in Excel (as text), select all, copy and paste values into a new Excel worksheet. That usually does the trick for me since that is a very messed up result that happens surprisingly often in Excel.
|
|
|
|
|
Also this is the lounge.
Rule 2. Technical discussions are welcome, but if you need specific programming question answered please use Quick Answers[^], or to discussion your programming problem in depth use the programming forums[^]. We encourage technical discussion, but this is a general discussion forum, not a programming Q&A forum. Posts will be moved or deleted if they fit better elsewhere.
|
|
|
|
|
WTE has Excel got to do with Programming?
Yeah I know there is VBA slapped on the back end, but his prob was nothing more than a moan about the SQL to Excel lack of communication.
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
|
I was once booted for asking what reporting software loungers like. 
I did not report them but just gave some advice. 
|
|
|
|
|
This is not a programming question. It is a guru question.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
So it should be asked in the Guru forum - This is the lounge. What on Earth could give ANYBODY the idea that this is where to find gurus of ANY sort? 
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
Look straight into my eyes, breathe slowly, look into my eyes, listen to my voice, take a profound breathe, close you eyes while you concentrate on my voice, you feel sleepy, ...
Now, you may call me guru.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Tyr copying a cell, and then paste it's value to another cell.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
|
|
|
|
|
And am annoyed.
Even before looking at any features.
Why would the update need to reboot TWICE??
An be careful with the prompts on the final reboot. They try to re-enable all the 'send to Microsoft...' options.
And they try to get you to log in with a web account, rather than a local account - again.
Pops up a logon screen that says - "please enter your email address to logon"
Wasn't obvious to me how to logon to a normal local account - but a couple of bashes on the escape key got me back to the normal logon.
Frustrating.
New colours in Metro are even worse - the orange is just awful.
Microsoft - what are you doing??
|
|
|
|
|
NeverJustHere wrote: Microsoft - what are you doing??
You think they know? 
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
I can guess at what they are trying to do - which is to leverage their dominance in desktop and laptop space into tablet and phone space - except in doing so, they have completely trashed the reason they are dominant in the desktop and laptop space.
They should have learned from their IE experience - a dominant product will yield to a superior product.
And right now I'd rather use Mint Linux that Windows 8.
|
|
|
|
|
NeverJustHere wrote: the orange is just awful.
Well, saying this on CP is a bit rude... 
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Fair point - and one that I hadn't considered.
But comparing them side-by-side (oh, wait I can't do that because Metro is full screen...)
no, Windows is definitely significantly more, and excessively too, orange on Metro.
CodeProject, as orange as it is, is subtle and understated in comparison.
|
|
|
|
|
OK, ok, I put the tar and the feathers back in their cabinet.
Seriously now, I think you can change the colors, can't you ?
And the whole subscribing stuff has been going on for ages, and has to do with the cloud. I bet you an sync a lot of things with mobile devices if you subscribe... but I hate it. I even refused to install some applications that look great because I did not freaking want to have yet another account.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
My biggest annoyance with 8.1 is that it insists on branding my desktop image with the version and build number. PLUS the text "Safe start has not been configured correctly" (translation from Swedish, so the actual English text might differ) - WITHOUT giving me the option to configure the flucking Safe start OR tell me how to do it! 
And Google is not helpful in removing the branding either. Doesn't seem like anybody but me cares about the text obscuring the picture of my cats!!! 
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
Johnny J. wrote: branding my desktop image with the version and build number
Ah, this is made that way so you can access the information more easily when calling the hotline 
Johnny J. wrote: Google is not helpful in removing the branding either.
Have you tried spitting on the screen and rubbing it with your fist ?
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Rage wrote: Have you tried spitting on the screen and rubbing it with your fist ?
Can't do that. I'm saving it if I should happen to come across an MS support technician IRL. 
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
Rage wrote: Have you tried spitting on the screen and rubbing it with your fist ?
Or spitting on your fist and using it on the screen?
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
It is a software problem, don't blame the hardware !
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
