|
Hi every body,
I am getting a problem when i work with Microsoft.Interop.Excel.dll
I tried to export and modify excel file with my conditional formatting for each cell of rows.
the function is :
Microsoft.Office.Interop.Excel.Range cellitem;
cellitem.FormatConditions[1].Modify(XlFormatConditionType.xlExpression, XlFormatConditionOperator.xlEqual, "=AND($X$" + position + ">2,MOD($X$" + position + ",2)=0)", "");
it was working good in English region but when i changed the region to Germany(de) it was crashed.
I don't know what is wrong .
Could you help me any solutions!
Thanks,
modified on Monday, September 22, 2008 2:28 AM
|
|
|
|
|
Try to use "," instead of "." in float number.
|
|
|
|
|
hi,
Thanks for your answer, but I'm sorry, I don't understand your answer.
Maybe you thought that the formula contained a float number. Unfortunately, it does not contain any float number. I tried to modify a simple formula but it still does not work well when changing to German region.
I updated the example that I did for clearer question.
I really appreciate if someone can help me this urgent issue.
Thanks.
|
|
|
|
|
I don't know about the formula. But English Excel has some differences with German Excel.
For example, if you want to count the average, in german excel you must use:
=MITTELWERT(...)
|
|
|
|
|
hi stancrm,
 Thanks a lot, I have finished solving my problem.
From your ideal I have changed the format of formula input because in German the ',' is changed to ';'.
Now it works well.
One again thanks to you .
I posts the change here to any one can compare and understand clear about the problem if they have.
cellitem.FormatConditions[1].Modify(XlFormatConditionType.xlExpression, XlFormatConditionOperator.xlEqual,
"=AND($X$" + position + ">2;MOD($X$" + position + ";2)=0)", "");
|
|
|
|
|
Does anybody knows how to u use ming in windows.<a href="http://sourceforge.net/projects/ming/">http://sourceforge.net/projects/ming/</a>[<a href="http://sourceforge.net/projects/ming/" target="_blank" title="New Window">^</a>]. How do we do the windowsxp installation i couldn't find and searched alot may be only gurus knows.
|
|
|
|
|
Best bet is to contact the developer at sourceforge.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hey, I was writing some code for my class and the assignment is to create a domain model and then also make an xml document of the information. I have been getting the following error
System.InvalidOperationException was unhandled
Message="There was an error generating the XML document."
Source="System.Xml"
StackTrace:
at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o)
at Assignment2.CustomerSerializer.ObjectToXml(Object obj) in C:\Users\xxxx\Documents\Visual Studio 2008\Projects\Assignment2\Assignment2\CustomerSerializer.cs:line 42
at Assignment2.CustomerSerializer.SerializeObjectToFile(Object customer, String fileName) in C:\Users\xxxx\Documents\Visual Studio 2008\Projects\Assignment2\Assignment2\CustomerSerializer.cs:line 20
at Assignment2.Customer.SaveObjectToFile(String fileName) in C:\Users\xxxx\Documents\Visual Studio 2008\Projects\Assignment2\Assignment2\Customer.cs:line 106
at TestAssignment2.Program.Main(String[] args) in C:\Users\xxxx\Documents\Visual Studio 2008\Projects\Assignment2\TestAssignment2\Program.cs:line 36
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: System.InvalidOperationException
Message="A circular reference was detected while serializing an object of type Assignment2.Customer."
Source="System.Xml"
StackTrace:
at System.Xml.Serialization.XmlSerializationWriter.WriteStartElement(String name, String ns, Object o, Boolean writePrefixed, XmlSerializerNamespaces xmlns)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterCustomer.Write3_Customer(String n, String ns, Customer o, Boolean isNullable, Boolean needType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterCustomer.Write2_Vehicle(String n, String ns, Vehicle o, Boolean isNullable, Boolean needType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterCustomer.Write3_Customer(String n, String ns, Customer o, Boolean isNullable, Boolean needType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterCustomer.Write4_Customer(Object o)
InnerException:
I checked through the inner exception and found that im getting a circular reference error and when i checked on boards and also other articles I found that basically its because i can't use a circular reference. Im having a hard time understanding this and was hoping that i could get an answer to how this can occur.
Thank you.
|
|
|
|
|
The built-in XML serialization is evil and should be avoided; always write custom serialization.
Having said that, and not wanting to read too much of what you posted, I can only guess that a Customer has a Vehicle and that Vehicle has the Customer and that is the circularity. How you remedy that (with the built-in XML serialization) I don't know, but once you figure it out you should have learned something.
"We learn more from our mistakes than we do from getting it right the first time."
|
|
|
|
|
Thank you for the advice and explaining how this is probably happening. I do have the customer in vehicle even though I don't want that. I will keep going through the code and hopefully I can figure it out.
For right now I would rather use the built-in stuff since im not entirely familiar with writing custom serialization.
Again thank you and I will post on what I did after i figure it out.
|
|
|
|
|
Thank you for your help. I figured the problem out and you were right. I was calling the customer class in vehicle and then using this in my test model. This was kinda, for lack of a better term, circular. Once i fixed this up, my code worked great.
Thank you again.
|
|
|
|
|
Don't get me wrong, it might make sense to have the circularity in the data. You just might not want to do a very deep serialization. And I don't know enough about the built-in serialization to say how to do a shallow serialization (if that's even a proper term).
|
|
|
|
|
hello friends,
How can I have my command prompt in the programming?
for example I want to write "attrib +h +s [address]" and run the attrib.exe in my program procedure (with the arguments (+h and +s)) and see the output lines if any.
how is that?
thanks
|
|
|
|
|
You can use Process class to start attrib.exe with the parameters you need. You can also redirect standard input and output to read/write input/output. A simple google search will bring many examples.
Have a look at this too: Command Prompt Control[^]
|
|
|
|
|
|
hi,
m trying to learn about Design patterns is there any helpful Sites or territorials
|
|
|
|
|
I personally would start with a Google search on "software design patterns".
mrcooll wrote: territorials
Tutorials or territorials?
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
Sorry 4 sure Tutorials 
|
|
|
|
|
|
I think this may be a good site to you:
www.dofactory.com
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Hi i am making Chat client which is both the client and the server
i have already made using the sockets. but it is not secure
I need to use sslstream to make the connection secure.
Can someone guide me through this?
Looking forward
Regards
Aditya
|
|
|
|
|
Have you seen the sample code in the SslStream Class documentation[^]?
There's both server and client code there - may be helpful ...
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hi!
I have search for hours after a good guide to create, edit, save and load a Excel file in C#. Those I have found does not work!
I use: Microsoft Visual C# 2008 Express Edition
and I can add the following references:
"Microsoft Excel 12.0 Object Library" or
"Microsoft Excel 5.0 Object Library"
I have no clue which of them to use.
Can someone give me a working example so I can get started? No solution in ASP please!
|
|
|
|
|
Mc_Topaz wrote: "Microsoft Excel 12.0 Object Library" or
"Microsoft Excel 5.0 Object Library"
I have no clue which of them to use.
Is the one you are going to want to use.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
modified on Sunday, September 21, 2008 2:23 PM
|
|
|
|
|
I don't care if it's version 5 or 12. I just need an example.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
