Excel: Reference Range from other worksheet

Vote count:

0

How can I reference a range from sheet1 in sheet2 while all changes especially adding or removing rows are accordingly reflected on sheet2?

For example I have a table on sheet1 from B20 to D24. (4 columns, 5 rows). This are should be referenced on sheet2 from A2 to C6. If user inserts row it should be added as well to the referenced sheet. If one is removed, same applies.

if I do =Sheet1!B20 and so forth new rows are ignored and I get a gap. Say a new row is added after row 20 only references from row 20 and 22 (previously 21) are shown on sheet2. If I remove a row I get a #ref error. With an array formula additions are ignored and deletions get a #na error.

How can I solve this especially without vba?

asked 51 secs ago

beginner_

1,301

Excel: Reference Range from other worksheet

Self-host of ASP.NET MVC application

Vote count:

0

I have a full-working ASP.NET MVC application (consisting of 5 assemblies, .NET 4.5.1, ASP.NET MVC 5.2.2) which runs fine in Visual Studio (which uses IISExpress).

I would now like to have a console application which takes the MVC application and hosts it (self hosting).

I tried with Microsoft.Owin.Host.HttpListener and Nancy.Owin but while I get 404 pages my configurations lacks the mapping to my MVC-app.

I got

public class Startup
{
    public void Configuration(IAppBuilder app)
    {
        app.UseNancy();
    }
}

and

    static void Main(string[] args)
    {
        StartOptions so = new StartOptions("http://localhost:9000/");
        using (WebApp.Start<Startup>(so))
        {
            Console.WriteLine("Press Enter to Exit");
            Console.ReadLine();
        }
    }

But obviously the configuration to use MyMvcApplication from the running MVC application is missing. How to do that? Or how to selfhost it otherwise?

The answers I found on the web refer to older versions and I was hoping to have a more easy way today.

asked 40 secs ago

ZoolWay

1,364

Self-host of ASP.NET MVC application

java.lang.NullPointerException with JAXB

Vote count:

0

I am using jaxb-impl-2.0.2 for my application and when I deploy to Oracle Application Server 10.1.3.5 which uses JDK1.6, I am getting the following error. I even tried using jaxb-impl-2.0.5, but didn't resolve the issue.

How can I resolve this error?

java.lang.NullPointerException
    at com.sun.xml.bind.v2.model.impl.PropertyInfoImpl.calcXmlName(PropertyInfoImpl.java:287)
    at com.sun.xml.bind.v2.model.impl.PropertyInfoImpl.calcXmlName(PropertyInfoImpl.java:262)
    at com.sun.xml.bind.v2.model.impl.ElementPropertyInfoImpl.getTypes(ElementPropertyInfoImpl.java:96)
    at com.sun.xml.bind.v2.model.impl.RuntimeElementPropertyInfoImpl.getTypes(RuntimeElementPropertyInfoImpl.java:50)
    at com.sun.xml.bind.v2.model.impl.ElementPropertyInfoImpl$1.size(ElementPropertyInfoImpl.java:42)
    at java.util.AbstractList$SimpleListIterator.hasNext(AbstractList.java:51)
    at com.sun.xml.bind.v2.model.impl.ModelBuilder.getClassInfo(ModelBuilder.java:139)
    at com.sun.xml.bind.v2.model.impl.RuntimeModelBuilder.getClassInfo(RuntimeModelBuilder.java:49)
    at com.sun.xml.bind.v2.model.impl.RuntimeModelBuilder.getClassInfo(RuntimeModelBuilder.java:41)
    at com.sun.xml.bind.v2.model.impl.ModelBuilder.getTypeInfo(ModelBuilder.java:189)
    at com.sun.xml.bind.v2.model.impl.RegistryInfoImpl.<init>(RegistryInfoImpl.java:63)
    at com.sun.xml.bind.v2.model.impl.ModelBuilder.addRegistry(ModelBuilder.java:232)
    at com.sun.xml.bind.v2.model.impl.ModelBuilder.getTypeInfo(ModelBuilder.java:201)
    at com.sun.xml.bind.v2.runtime.JAXBContextImpl$3.run(JAXBContextImpl.java:352)
    at com.sun.xml.bind.v2.runtime.JAXBContextImpl$3.run(JAXBContextImpl.java:350)
    at java.security.AccessController.doPrivileged(AccessController.java:276)
    at com.sun.xml.bind.v2.runtime.JAXBContextImpl.getTypeInfoSet(JAXBContextImpl.java:349)
    at com.sun.xml.bind.v2.runtime.JAXBContextImpl.<init>(JAXBContextImpl.java:215)
    at com.sun.xml.bind.v2.ContextFactory.createContext(ContextFactory.java:76)
    at com.sun.xml.bind.v2.ContextFactory.createContext(ContextFactory.java:55)
    at com.sun.xml.bind.v2.ContextFactory.createContext(ContextFactory.java:124)

asked 1 min ago

Polppan

4,323

java.lang.NullPointerException with JAXB

SQL Access GROUP BY et ID

Vote count:

0

I found out some examples but I have difficulties applying this to my case and as I need the query very quickly, I am coming to you SQL masters :)

I need the below SELECT to return Sessions.id (the one that corresponds to Max(Sessions.DateFin) for each row)

SELECT Sessions.idFormation, Inscriptions.idPersonnel, Max(Sessions.DateFin) AS Dernier FROM Sessions INNER JOIN Inscriptions ON Sessions.id = Inscriptions.idSession GROUP BY Sessions.idFormation, Inscriptions.idPersonnel

I believe I need to use something like SELECT * FROM Table1 t1 JOIN ( SELECT category, MAX(date) AS MAXDATE FROM Table1 GROUP BY category ) t2 ON T1.category = t2.category AND t1.date = t2.MAXDATE

but as t1 in my case is already a query I do not get how to implement this solution.

asked 29 secs ago

Raphael Camus

34

SQL Access GROUP BY et ID

Colspan styling in nested tables failed

Vote count:

0

I have a problem with nested tables. In my Company we have an old website wich is based on an table layout. I want to add dynamicaly a new td in one tr. If this td is set, in the other tr's i will set on the last td a colspan=2. If i do this, my table looks like this:

|----|-|-------|--|---|-|-| |----|-|-------|--|---|-|-| |----|-|-------|--|---|-|-|

instead of looking like this:

|---|-|----|--|---|-|-----| |---|-|----|--|---|-|-----| |---|-|----|--|---|-|-----|

( - only defined as width not as colspan)

This is sample markup from my code:

<table border="0" width="100%" cellspacing="0" cellpadding="1">
    <tbody>
        <!-- Headline tr -->
        <tr>
            <td width="100%" valign="middle" nowrap align="left" colspan="7"> 
                Titel 
            </td>
            <!-- New dynamic Field -->
            <td nowrap align="right"> 
                <img src="example.gif" width="15px" height="15px"/>               
            </td>
        </tr>
        <tr>
            <td nowrap align="left"> 
                Name
            </td>
            <td> 
                :
            </td>
            <td width="50%" align="left"> 
                <input readonly value="test" />
            </td>
            <td nowrap align="left"> 
                Number
            </td>
            <td> 
                :
            </td>
            <td width="100%" align="left" colspan="2"> 
                <input readonly value="test" />
            </td>
        </tr>
        <tr>
            <td nowrap align="left"> 
                Name
            </td>
            <td> 
                :
            </td>
            <td width="50%" align="left"> 
                <input readonly value="test" />
            </td>
            <td nowrap align="left"> 
                Number
            </td>
            <td> 
                :
            </td>
            <td width="100%" align="left" colspan="2"> 
                <input readonly value="test" />
            </td>
        </tr>
        <tr>
            <td nowrap align="left"> 
                Name
            </td>
            <td> 
                :
            </td>
            <td width="50%" align="left"> 
                <input readonly value="test" />
            </td>
            <td nowrap align="left"> 
                Number
            </td>
            <td> 
                :
            </td>
            <td width="100%" align="left" colspan="2"> 
                <input readonly value="test" />
            </td>
        </tr>
    </tbody>
</table>

This table is nested in a table with <table width="100%" height="100%">

Whats the failure?

asked 53 secs ago

Tanktiger

22

Colspan styling in nested tables failed

how to convert images and change quality via GD?

Vote count:

0

I want to convert images to another formats (jpg, png or gif) and change the quality of image's destination via GD. Can you help me?

asked 26 secs ago

behzad

1

how to convert images and change quality via GD?

Which is the best way to take user input and show them in pairs? (use of controls and format)

Vote count:

0

I have certain pairs in DB (in separate column though). When UI comes up, it should show existing pairs. it should be able to edit the existing ones and add new ones also. All will updated in DB when save button is hit.

I tried: 1) Mark;mark@mail.com,Peter Johnson;peter@mail.com Before ';' is name and after is email. 2) I had 2 textboxes to input name and email and shown them in a grid once added.

Could you please suggest some good way to achieve this? easiest and obvious for user and developer.

asked 37 secs ago

Srikanth P Vasist

169

Which is the best way to take user input and show them in pairs? (use of controls and format)