No announcements
Found 1659157 threads
-
0 VotesHow to set a cell's formula
> I just need to know how to set a cell's formula in excel.Answered | 1 Replies | 1809 Views | Created by JBDevoArch - Monday, August 31, 2015 2:46 PM | Last reply by Edward8520 - Tuesday, September 1, 2015 5:53 AM
-
0 Votes
Excel Interop line break in cell
Refer this ...Answered | 3 Replies | 19270 Views | Created by Newmanb1 - Wednesday, July 25, 2012 9:23 PM | Last reply by Sivalingam Ramasamy - Thursday, July 26, 2012 9:36 AM -
0 Votes
Excel Interop and regional settings
Upon clicking on the ribbon button it reads the formula from an active cell (if there's any), displays it and allows you to write it back (it, or anything else).Answered | 12 Replies | 7549 Views | Created by Dmitry Hohlyshev - Tuesday, February 11, 2014 12:31 PM | Last reply by Pradeep Ra - MSFT - Friday, March 14, 2014 10:57 PM -
0 Votes
Importing Excel Sheet with Formula cell
When I try to import excel file to the database.Answered | 7 Replies | 10592 Views | Created by Tareq Ali [MSFT] - Wednesday, March 17, 2010 10:08 AM | Last reply by Galina_Maystrenko - Thursday, April 7, 2011 11:33 AM -
0 Votes
Excel Formula
Use it on a blank Excel file, so that you understand how it works, and then use it on your main file.Answered | 2 Replies | 1319 Views | Created by Maggiejt - Sunday, May 28, 2017 3:04 AM | Last reply by Vijaykumar Shetye - Monday, May 29, 2017 4:52 AM -
0 Votes
Excel EWA get formula from a cell
Hi, To achieve your requirement, you can convert formula to text string in Excel files.Answered | 1 Replies | 1216 Views | Created by mmumshad - Friday, November 13, 2015 8:40 PM | Last reply by Dean_Wang - Tuesday, November 17, 2015 5:04 AM -
0 Votes
Hook into Excel formula mechanism
Any cell or group of cells is represented by a Range object.Answered | 1 Replies | 4816 Views | Created by Adam Cataldo - Saturday, April 25, 2009 12:20 AM | Last reply by Jose Anton Bautista - Monday, April 27, 2009 4:36 PM -
0 Votes
Add the formula to the formula bar in excel
Hi Helix, According to your description, you want to see the expression in the excel file after exporting to excel, right?Answered | 3 Replies | 1056 Views | Created by Helixpoint - Tuesday, September 1, 2015 5:41 PM | Last reply by 王者荣耀 - Wednesday, September 2, 2015 2:38 AM -
1 Votes
Have cell equal the value not the formula
The problem is that lookup_value MUST be a value and will not match to the cell in the lookup_array if the cell in the array is a formula.Answered | 14 Replies | 29452 Views | Created by Justin1426 - Monday, April 20, 2015 6:39 PM | Last reply by Luke Aiello - Friday, November 3, 2017 3:02 PM -
1 Votes
Excel Formulas in SSRS 2008
I tried to add my formulas in my dataset (I can know which excel cells I need in the formulas) but they end up being displayed as text.Answered | 11 Replies | 21423 Views | Created by Simon Ringuet - Tuesday, July 20, 2010 5:50 PM | Last reply by LuisNY - Friday, May 1, 2015 6:53 PM -
0 Votes
Excel Formulas in Sharepoint
error appears when the formula that contains the function refers to cells in a closed workbook or the cell are calculated.Answered | 4 Replies | 7457 Views | Created by torystcyr - Tuesday, December 1, 2015 4:05 PM | Last reply by taylor.l - Wednesday, December 2, 2015 12:26 PM -
1 Votes
How to identify a formula of cell contains defined names in Excel by using VSTO?
I'm not sure if this will help, but you can try to enumerate all the used ranges in your worksheet,then check the formula of each.Answered | 2 Replies | 3332 Views | Created by Ystlife - Monday, October 12, 2009 1:47 AM | Last reply by Ystlife - Monday, October 19, 2009 11:19 AM -
0 Votes
What is the formula to find a set of characters in a cell?
Copy my function from above into a regular module, add a helper column and use the formula ...Answered | 3 Replies | 752 Views | Created by IWAR - Friday, January 17, 2014 1:42 AM | Last reply by Andreas Killer - Friday, January 24, 2014 11:06 AM -
0 Votes
excel if then formula/macro
I need a simplified if/then formula.Answered | 1 Replies | 2412 Views | Created by chilimichigan - Wednesday, October 19, 2011 4:53 PM | Last reply by Tushar Mehta - Wednesday, October 19, 2011 5:25 PM -
3 Votes
Updating contents of the formula cell using OpenXML SDk
I was able to update the formula cell with no issues.Answered | 5 Replies | 16942 Views | Created by winracer - Wednesday, March 17, 2010 2:27 PM | Last reply by MatteoGRN - Friday, October 31, 2014 3:08 PM -
3 Votes
Cube formulas not working when linking against cells with formulas in them
Cube functions in Excel are very powerful, but also quite hard to work with.Answered | 2 Replies | 893 Views | Created by cenigk - Thursday, September 29, 2016 12:08 PM | Last reply by Michiel Rozema - NL - Thursday, September 29, 2016 9:27 PM -
3 Votes
How to set Date Format in Excel using Interop library ?
Thanks Viorel, your answer is very helpful to me. but i cant able to use this, because i have large amount of data in my datatable. so writing ...Answered | 5 Replies | 5665 Views | Created by VRKarthikeyan - Friday, March 1, 2013 5:37 AM | Last reply by VRKarthikeyan - Friday, March 1, 2013 3:41 PM -
0 Votes
Excel Interop - setting formula for a cell
User1918990383 posted In the Excel, if you drag the a formula, then automatically increment happens for the cell.Unanswered | 1 Replies | 46 Views | Created by Anonymous - Friday, August 21, 2009 3:58 PM | Last reply by Anonymous - Monday, August 24, 2009 8:23 AM -
1 Votes
C# OpenXmlReader get cell value from excel instead of formula
> C# OpenXmlReader get cell value from excel instead of formula With the code below, you could find the cell value is stored in the value ...Answered | 3 Replies | 15279 Views | Created by mnoi - Friday, September 4, 2015 3:56 AM | Last reply by Edward8520 - Monday, September 7, 2015 11:30 AM -
0 Votes
Reading DropDown Cell In Excel File Using Microsoft Interop Excel
Here is C# solution to fetch values from dropdown cell.Answered | 3 Replies | 2916 Views | Created by Muneer Salma - Thursday, August 18, 2016 11:20 AM | Last reply by Vadim Yangunaev - Monday, August 22, 2016 8:10 AM - Items 1 to 20 of 1659157 Next ›
No announcements
