Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » Developing U++ » UppHub » Ole Automation [FEATURE REQUEST?]
Re: Ole Automation [FEATURE REQUEST?] [message #21174 is a reply to message #21173] Wed, 06 May 2009 15:58 Go to previous messageGo to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

Hello Koldo,

Try this for Ms Excel in demo example:
sheet.SetValue(1, 2, "123456789123456789");


I have lost data:
for this example in excel I have "123456789123456000" instead "123456789123456789"

I was modified a little the code:
bool MSSheet::SetValue(int col, int row, Value value)
{
	if (!Sheet)
		return false;

	VariantOle x, y, val;
	x.Int4(col);
	y.Int4(row);
	val.Value(value);
	
	// >>> Ion Lupascu 06.05.2009 Set Cell Format for string cell
	if (!(Range = Ole::GetObject(Sheet, "Cells", x, y)))
		return false;	

	if(IsString(value)){
		VariantOle txt_format_ole;
		txt_format_ole.BString("@");
		
		Ole::SetValue(Range, "NumberFormat", txt_format_ole);
	}
	
	return Ole::SetValue(Range, "Value", val);
	// <<< Ion Lupascu 06.05.2009
}


I thing that exist memory leak in the program!
Every time when I run the program that it only preparing excel file and text file (specific converting from text to excel file) I have memory leak. Memory usage is increasing every time!
Is it a normal situation?

[Updated on: Wed, 06 May 2009 16:12]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: MAPIEx works with MinGW
Next Topic: [Controls4U] IE shows script errors
Goto Forum:
  


Current Time: Tue May 14 06:37:03 CEST 2024

Total time taken to generate the page: 0.02333 seconds