VBA: Convert Text to Number

I have columns of numbers that, for whatever reason, are formatted as text. This prevents me from using arithmetic functions such as the subtotal function. What is the best way to convert these "text ...

4 Dec at 12:45

No tests to execute msTest

I'm trying to run .NET unit tests on the command line using MSTest My command is ``` "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\MSTest.exe" /testcontainer:"full path of dll" /...

How to create a DataFrame from a text file in Spark

I have a text file on HDFS and I want to convert it to a Data Frame in Spark. I am using the Spark Context to load the file and then try to generate individual columns from that file. ``` val myFil...

ASP.NET Identity, add another user to role instantly (they don't have to log out and in again)

First of all, I'm aware of this question: [MVC 5 AddToRole requires logout before it works?](https://stackoverflow.com/questions/20495249/mvc-5-addtorole-requires-logout-before-it-works) and this one...

How to only load certain fields of a child object in Entity Framework 6.1?

I'm working on a model that has two classes, `Product` and `Transaction`. ``` public class Product { [DataMember] public Guid ProductId {get; set;} [DataMember] public virtual IColle...

In ServiceStack, how can I do integration testing with multiple endpoints?

We're using ServiceStack for a client project with several distinct problem domains, which we'd prefer to keep separated. We've developed a testing framework that spins up an AppHostHttpListener and ...

23 May at 12:7

Is there a "String.Format" that can accept named input parameters instead of index placeholders?

This is what I know ``` str = String.Format("Her name is {0} and she's {1} years old", "Lisa", "10"); ``` But I want something like ``` str = String("Her name is @name and she's @age years old"); ...

21 Apr at 04:56

How to have multiple conditions for one if statement in python

So I am writing some code in python 3.1.5 that requires there be more than one condition for something to happen. Example: ``` def example(arg1, arg2, arg3): if arg1 == 1: if arg2 == 2: ...

Is it possible to get a warning if return value is not used?

I have an extension method which returns a value. In this case, it should set a specific bit in a byte: ``` public static byte SetBit(this byte b, int bitNumber, bool value) { if (value) { ...

5 Nov at 00:9

Add Scrollbars to a Textbox

How does one get scrollbars on a `TextBox`?

6 Feb at 00:28

JS generate random boolean

Simple question, but I'm interested in the nuances here. I'm generating random booleans using the following method I came up with myself: ``` const rand = Boolean(Math.round(Math.random())); ``` W...

20 Apr at 22:57

Problems with multiple primary keys using ORMLITE

I use the ORMLite Poco generator for my database. The problem is that I have a table with multiple primary keys, and when I try to add any data into the database I get unique constraints. I have rea...

6 Nov at 13:11

Postgresql tables exists, but getting "relation does not exist" when querying

I have a postgresql db with a number of tables. If I query: ``` SELECT column_name FROM information_schema.columns WHERE table_name="my_table"; ``` I will get a list of the columns returned properl...

25 Apr at 01:36

Completely uninstall VS Code extensions

Since the latest release of VS Code, I get an error whenever I open a C# file (I have installed the csharp language extension, powered by OmniSharp). This is the error I get: [](https://i.stack.imgu...

12 Apr at 12:18

Passing MSBuild Arguments to Cake Build Script to produce _PublishedWebsites

I am currentlly in the process of writing a Cake build script to build a number of ASP.NET MVC sites. At the moment I am unable to see an option to pass arguments to MSBuild to produce the _Publishe...

How to add conditional attribute in Angular 2?

How can I conditionally add an element attribute e.g. the `checked` of a checkbox? Previous versions of Angular had `NgAttr` and I think `NgChecked` which all seem to provide the functionality that ...

17 May at 15:6

String interpolation using named parameters in C#6

Given I have a Meta Data resource string stored in my Database that will return like this: ``` var pageTitle = "Shop the latest {category1} Designer {category2} {category3} at www.abc.com"; ``` An...

21 Apr at 00:44

How to write 1GB file in efficient way C#

I have .txt file (contains more than million rows) which is around 1GB and I have one list of string, I am trying to remove all the rows from the file that exist in the list of strings and creating ne...

20 Apr at 13:58

Proto2 vs. Proto3 in C#

I have to send messages to another team using the proto2 version of Google Protocol Buffers. They are using Java and C++ on Linux. I'm using C# on Windows. Jon Skeet's protobuf-csharp-port (https://gi...

7 May at 07:20

ServiceStack event for client disconnect

I'm experimenting with ServiceStack's Server Events feature and want to make a sort of "online users" test app. The idea is I want to update each user that connects to a channel "Users" whenever a new...

20 Apr at 10:51

Elegant initialization of an array of class instances in C#

Let's say I have a class like this: ``` public class Fraction { int numerator; int denominator; public Fraction(int n, int d) { // set the member variables } // And then a b...

24 Jan at 01:46

Why can't I debug code in an async method?

I actually started the night trying to learn more about MongoDB, but am getting hung up and the .NET await/async stuff. I am trying to implement the code shown on MongoDB's [site](https://docs.mongodb...

10 Sep at 12:20

Rendering newline character in VueJS

I'm creating a note app where users can add a note by entering multiline text in a textarea. When I save the note in Firebase it is being saved with newline (\n) characters which I want to visualize. ...

26 Sep at 21:8

How to remove the "Go to live visual tree" / "Enable selection" / "Display layout adorners" overlay when debugging?

How do I remove the box with the 3 icons when debugging? [](https://i.stack.imgur.com/rhlua.png)

installing python packages without internet and using source code as .tar.gz and .whl

we are trying to install couple of python packages without internet. ``` For ex : python-keystoneclient ``` For that we have the packages downloaded from [https://pypi.python.org/pypi/python-keysto...

19 Apr at 17:49