Encerrado

#DIV/0! is shown after merging data using C# and oledb

We are looking for an C# developer who has experience with merging data from C# into Excel. Currently we have a fully functional solution, which merges data from a database with C# and oledb connection in Excel, the only problem is that the calculations in the Excel sheet aren’t working with the cells in which the data is merged.

To recap:

Data is successfully written in the excel file but the problem is functions of cells which are dependednt on another cell. These cell functions are not calculated in excel sheet. The cells show #DIV/0!. Clicking on the shows shows the calculation in the Excel sheet correctly but somehow it isnt showing the result.

The process is:

1. We have an excel sheet with calculations/formulas.

2. We merge data with a C# applications in different cells

3. These cells are part of the calculations/formulas.

4. The objective is that when we open the Excel sheet that the formulas use the values correctly.

Possible problem:

1. The merged values (numeric) are seen in the Excel Sheet as text not as value and therefore not used by the calculations.

Because this is probably a simple setting or code change, we do not expect that this will take a lot of time. Furthermore we are looking for someone who has encountered the same problem and therefore has experience how to solve this.

Habilidades: .NET, Programação C#, Excel

Ver mais: programming using c++, programming using c#, programming in objective c, objective of c programming, excel c# programming, div programming, div 1 a, c# functional programming, programming with objective c, programming objective c, objective c programming, objective c code, objective-c developer, merge data, div, c objective, excel recap sheet, recap excel sheet, data merging, excel sheet merge, merge excel sheet, merge sheet, excel show different value, data excel objective, solve excel problem

Acerca do Empregador:
( 31 comentários ) Utrecht, Netherlands

ID do Projeto: #6786498

17 freelancers estão ofertando em média $51 para este trabalho

koolsidz

Easy Job. Sure I can fix this but I need team viewer access to your machine. Excel/.Net Expert. You may see my reviews.

$30 USD em 1 dia
(119 Comentários)
6.1
digidreamstech

Dear Client, It’s Ram from, India. I thoroughly have gone through your requirements to merge data from C# into excel and understood the description of dependent cells calculation error and excel formulas. I hav Mais

$144 USD em 1 dia
(18 Comentários)
5.2
kher78

Hello, I can help you right away. A small modification to your formula is most likely the only thing that is needed.

$25 USD in 0 dias
(51 Comentários)
5.0
murtaza1981

Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza

$50 USD em 1 dia
(12 Comentários)
4.6
pmurugan

A proposal has not yet been provided

$131 USD in 3 dias
(2 Comentários)
4.1
RKYSP

Hi, I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) kendo ui, MySQL and SQL Server etc). Mais

$30 USD in 2 dias
(15 Comentários)
4.1
sergpooh

I Have experience with merging data from C# into Excel. Will do the job quickly with detailed comments.

$19 USD em 1 dia
(2 Comentários)
1.4
officesoftin

I have extensively worked on C#.NET, VSTO and Excel, 17 years of experience. You are right, this is simple problem, you can show me on TeamViewer and we can fix in couple of hours. Its just require formula fix somewher Mais

$25 USD em 1 dia
(0 Comentários)
0.0
OguzK

Bir öneri henüz sağlanmadı

$80 USD in 3 dias
(0 Comentários)
0.0
berian

Hi Sir, I have experience of merging data from c# to [url removed, login to view] give me an opportunity to prove my skills with in time and with perfection. Regards, Berian

$30 USD in 3 dias
(0 Comentários)
0.0
TooSexyforU

Hi there, I have 5 years experience in PHP, Wordpress, CSS, HTML and Web development. If you want just something - go with the indians, but if you want a really professional work - you can trust me!

$45 USD em 1 dia
(0 Comentários)
0.0
karthi732

Have 5 yrs of exp in .net. will make proper code and will cmplete in time. you can gie this project to me to complete within time as per you expection

$98 USD em 1 dia
(0 Comentários)
0.0
Broodware

Hello, my name is Dmitriy. I just started using freelancer and hence you can see that I do not have much ratings to show you, but I have experience working with MS Office using .NET. Concerning your task first assumpti Mais

$40 USD em 1 dia
(0 Comentários)
0.0
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal Mais

$50 USD in 3 dias
(0 Comentários)
0.0
ageblade

I'm an experienced C# developer, with 6 years under my resume. I think i can handle your problem fast and reliable.

$25 USD em 1 dia
(0 Comentários)
0.0
realTeddy

Yes I encountered a similar problem before. The problem is a number is divided either by zero or by a cell that contains no value. All you have to do is check the condition where the denominator is zero and set the Mais

$15 USD em 1 dia
(0 Comentários)
0.0
andrewdecker

I have encountered this problem with Excel spreadsheets before. It should be an easy fix, and I'd be happy to walk you through the details. Please message me if you have any questions!

$25 USD em 1 dia
(0 Comentários)
0.0