C# Discussion Boards - CodeProject

UDF 64bit vs 32bit Excel 2010

PozzaVecia2-Dec-12 4:39

2-Dec-12 4:39

I'm checking this article http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx?Redirected=true[^]

I create a simply UDF of the article. In 32bit system, it is all right. In a 64bit, a simply function works only if I directly insert argument in the function. If I link the argument to a cell it doesn't work. Apparently it doesn't recognized that the number coming from excel cell (64bit) is a correct double for my function (which accept double)

Any idea?

Later note: really my Excel 2010 it is 32bit too.

So: the same project:
on windows xp, excel 2010 32bit, single processor works
on windows 7, excel 2010 32bit, 4 processors : excel udf works only if I directly use numbers in formulas, but it doesn't works if my UDF arguments refers to cells containing nmbers

Later note:

I found the same problem here http://social.msdn.microsoft.com/Forums/en-SG/exceldev/thread/8168c603-a7c8-4c01-98d2-3c0385294325[^]

it is more clear: from "Wolfgang"
"
I also used Eric's blog to create an automation add-in: http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx.
"
I created this Automation add-in with Office 2010, Visual Studio 2010 and .NET Framework 4.0 on Windows 7 (it should be the same configuration as Bessie's). But it does not work for me. I get #VALUE! as error. As soon as I replace the call "=MultiplyNTimes(B1,B2,C2)" with "=MultiplyNTimes(VALUE(B1),VALUE(B2),VALUE(C2))" it works.

I created this add-in with Office 2003, Visual Studio 2010 and .NET Framework 4.0 on Windows XP and it worked ("=MultiplyNTimes(B1,B2,C2)")

Does anybody has an idea what's the problem?
"

modified 2-Dec-12 17:19pm.

Re: UDF 64bit vs 32bit Excel 2010

Mycroft Holmes2-Dec-12 11:36

Mycroft Holmes

2-Dec-12 11:36

Sorry no help but the whole issues justifies my stand NEVER to use Office products in a solution to a clients problems. Office is a great productivity tool, IT IS NOT A DEVELOPMENT PLATFORM.

Never underestimate the power of human stupidity
RAH

Re: UDF 64bit vs 32bit Excel 2010

Richard MacCutchan2-Dec-12 21:48

Richard MacCutchan

2-Dec-12 21:48

Mycroft Holmes wrote:
NEVER to use Office products in a solution to a clients problems.

Sage advice. Thumbs Up | :thumbsup:

One of these days I'm going to think of a really clever signature.

determine listbox items origin

User 94041061-Dec-12 11:40

User 9404106

1-Dec-12 11:40

Hi,

I'm working on an application of which requires me to have one list-box to hold data.

I'm having a little issue when deleting an object from a list-box. The issue comes into play when I fill the list-box with items from TWO separate lists.

Normally to delete the object I would get it's index and then remove it from the list in a separate class then reload the list-box to reflect the changes but in certain instances I need to fill the list-box with objects from two different lists and determining the origin of the object to delete from one of the two lists, well I'm not entirely sure how to do this.

this code is populating the list-box control.

//clear all items in the listbox
            ViewListBox.Items.Clear();

            //create the lists
            List listOfPickups = visits.listPickups();
            List listOfdeliveries = visits.listDeliveries();
            //populate
            ViewListBox.Items.AddRange(listOfPickups.ToArray());
            ViewListBox.Items.AddRange(listOfdeliveries.ToArray());

this is how i delete when i am only loading the listbox from one list.

if (ViewListBox.SelectedIndex < 0)
{
    EditSelectBtn.Enabled = false;
    DeleteSelectBtn.Enabled = false;
}
else
{
    if (MessageBox.Show("are you sure you want to delete the selected item?", "Are You Sure?", MessageBoxButtons.YesNo) == DialogResult.Yes)
    {
        visits.removePickup(this.ViewListBox.SelectedIndex);
        //refresh listbox.
        updateList("pickups");
    }
    else
    {
        //clicked no so do nothing!
        ViewListBox.ClearSelected();
    }
}

Any help would be greatly appretiated.

modified 11-Mar-21 21:01pm.

Re: determine listbox items origin

Mycroft Holmes1-Dec-12 13:04

Mycroft Holmes

1-Dec-12 13:04

I don't work with winforms anymore but I believe there will be a tag property on the listboxitem, I would put an identifier in there. OR add a hidden column (width = 0) with the identifier.

Never underestimate the power of human stupidity
RAH

Re: determine listbox items origin

Freak303-Dec-12 0:53

Freak30

3-Dec-12 0:53

If the list box doesn't sort (so always displays the items from the first list first and items from the second list below that), the easiest solution would be to compare the index to delete with the size of the first list. If the index is too large, just subtract firstList.Count to get the index to remove from the second list.

Re: determine listbox items origin

User 94041063-Dec-12 9:35

User 9404106

3-Dec-12 9:35

Thank you i tried this and it works perfectly! Smile | :)

modified 11-Mar-21 21:01pm.

highlight list view

dominioYP1-Dec-12 10:46

dominioYP

1-Dec-12 10:46

hi men
I have a listView called lw1.
When I use lw1.selectedItem, I can check which item is selected.
But, how I can know which item is alone highlighted by mouse cursor?

note:http://dl.dropbox.com/u/45898865/Immagine.jpg[^]
in picture 1
gimppoi is selected with one click of mouse cursor
in picture 2
gimppoi is selected with one click of mouse cursor
poweooooooooo has alone mouse cursor over the line

modified 3-Dec-12 16:01pm.

Re: highlight list view

Mycroft Holmes1-Dec-12 13:01

Mycroft Holmes

1-Dec-12 13:01

Some grids (not sure about listviews) allow you to select the item on mouseover. Otherwise you need to handle the mouseover event, use hittest to identify the record and decide what to do with it!

Never underestimate the power of human stupidity
RAH

Re: highlight list view

dominioYP2-Dec-12 1:24

dominioYP

2-Dec-12 1:24

good idea

I had tried it yesterday without success.

private void buttonGV_Click(object sender, RoutedEventArgs e)
{
Attivita attivita = null;
for (int i = 0; i < listViewAttivita.Items.Count; i++ )
     if ( listViewAttivita.IsMouseOver )
         attivita = listViewAttivita.Items[i] as Attivita;

if ( listViewAttivita.IsMouseOver )

this test is needless, because I want know which row is selected. That test told me if the mouse is over one of all ListView rows.

Can you tell me what I should search to understand which row has the mouse over?

this is the XAML part. Does it help?

HTML

<ListView ItemsSource= "{Binding AttivitaCollection, UpdateSourceTrigger=PropertyChanged}" Height="206" HorizontalAlignment="Left" Margin="12,33,0,0" Name="listViewAttivita" VerticalAlignment="Top" Width="auto" SelectionChanged="listViewAttivita_SelectionChanged">
    <ListView.Resources>
        <med:ImageConverter x:Key="imageConverter"/>
    </ListView.Resources>
    <ListView.View>
        <GridView>
            <GridViewColumn Header="Azioni registrate" Width="150" DisplayMemberBinding="{Binding nome, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"/>
            <GridViewColumn Header="Stato" Width="auto" >
                <GridViewColumn.CellTemplate>
                    <DataTemplate>
                        <Button Width="24" Name="buttonGV" Click="buttonGV_Click" Height="24" Background="Transparent"  BorderBrush="Transparent">
                            <Image Source="{Binding Path=imgStato, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged, Converter={StaticResource imageConverter}}" />
                        </Button>
                    </DataTemplate>
                </GridViewColumn.CellTemplate>
            </GridViewColumn>
        </GridView>
    </ListView.View>
</ListView>

Re: highlight list view

Mycroft Holmes2-Dec-12 11:31

Mycroft Holmes

2-Dec-12 11:31

I would post this in the WPF/Silverlight forum, there are some guys there who have a very deep knowledge. At a guess you probably need a trigger on the listview servicing the mouseover event.

Never underestimate the power of human stupidity
RAH

App.Config or Windows Registry?

Jassim Rahma1-Dec-12 10:27

Jassim Rahma

1-Dec-12 10:27

Hi,

I would like to ask which way you prefer t store variable which could be available for read/write? do you prefer to store in App.Config or Windows Registry is still best to use?

Thanks,

Jassim[^]

Technology News @ www.JassimRahma.com

Re: App.Config or Windows Registry?

Eddy Vluggen1-Dec-12 12:06

Eddy Vluggen

1-Dec-12 12:06

I prefer text files. Is it a WinForm app, a WebApp, a widget? Does it run under limited permissions, or in the users' context?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: App.Config or Windows Registry?

Jassim Rahma1-Dec-12 18:59

Jassim Rahma

1-Dec-12 18:59

It's winForm and as you know standard users won't have access to C:\Program Files so will the App.config work in this case?

Technology News @ www.JassimRahma.com

Re: App.Config or Windows Registry?

Eddy Vluggen1-Dec-12 23:31

Eddy Vluggen

1-Dec-12 23:31

I'd use the Settings-file, not the App.Config. Which, by the sound of it, is an application-level configuration, not user-level.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: App.Config or Windows Registry?

PIEBALDconsult2-Dec-12 4:28

PIEBALDconsult

2-Dec-12 4:28

I roll my own config files (XML) and read and write to them.

I never touch the Registry.

Re: App.Config or Windows Registry?

J4amieC2-Dec-12 21:51

J4amieC

2-Dec-12 21:51

So rather than use the infrastructure that's there for you, tested, and with reams of documentation available - you choose to roll your own?

Wow!

Re: App.Config or Windows Registry?

PIEBALDconsult3-Dec-12 9:08

PIEBALDconsult

3-Dec-12 9:08

Of course. It works the way I want, not the way someone else who knows nothing of what I do thinks everyone should do it.

J4amieC wrote:
with reams of documentation

That would be a clear reason not to use it. My way requires no documentation, it is therefore superior. Big Grin | :-D

Re: App.Config or Windows Registry?

Matty223-Dec-12 18:13

Matty22

3-Dec-12 18:13

Do your xml files properly handle multiple NT accounts each with different settings like the registry does?

Do your xml files handle concurrent write by eg, configuration tool, like the registry does?

Can your xml files be modified easily by domain login scripts like the registry does?

Can your xml files be centralized into AD for centralized enterprise management? Like registry entries can be?

Re: App.Config or Windows Registry?

PIEBALDconsult4-Dec-12 3:54

PIEBALDconsult

4-Dec-12 3:54

Of course not, I don't want that.

Can registry entries be stored on a flash drive and used on whatever system I happen to be using only while I'm using the software?

Ms cindy1-Dec-12 6:18

Ms cindy

1-Dec-12 6:18

or anyone like done c# or c c+ if anyone interesws email me Poke tongue | ;-P

Re: ok

Dave Kreskowiak1-Dec-12 18:45

Dave Kreskowiak

1-Dec-12 18:45

again....you posted something completely incomprehensible.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: ok

AmitGajjar1-Dec-12 19:36

AmitGajjar

1-Dec-12 19:36

I believe your English is poor.
what you mean by interesws ? is this interest or interview ??

One more point, do not expect email from codeproject. people will help you by posting question's answer here. that may help others as well.

For interest, you can read top rated articles in codeproject

For interview, you should read ebooks. that will help you to understand basic concepts. reading interview question never help when there is some smart interviewer.

just make sure whatever you read, you are conceptually clear for that.

Thanks
-Amit Gajjar (MinterProject)

hekp

Ms cindy1-Dec-12 6:16

Ms cindy

1-Dec-12 6:16

i want know want do work need do i like see terry is interresed in spades for me

Re: hekp

Mycroft Holmes1-Dec-12 12:58

Mycroft Holmes

1-Dec-12 12:58

Ms Cindy, I would report this but it is neither spam or abuse, just incomprehensible. Change you profile to reflect your country of origin, your first language is obviously not english. Get someone to help you who knows english!

Never underestimate the power of human stupidity
RAH

Last Visit: 31-Dec-99 18:00 Last Update: 16-May-24 20:12

Refresh

ᐊ Prev 1...1766 1767 1768 176917701771 1772 1773 1774 1775 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.