(using VB2008)I was wondering if it's possible to implement dynamic (runtime) formulas between objects and properties. My inspiration is Excel, where any cell can have a hardcoded value or be a function of other cells. So via analogy of a property acting like a cell, depending upon the situation, I would like to either give it a defined value or make it a function of other properties of objects of the same type.
There seem to be two basic levels of functionality, 1) the dependent property recalculates its value every time it's accessed, or better is 2) it detects when its input properties change value and recalculates itself only once (as in Excel). But so far I've failed to find any way to do either with ordinary properties. It seems like I would either have to turn each property into a class (and use events, references to parent properties, etc), or use reflection heavily. Either way I feel like I'm going off the beaten path and making things complicated. Has anyone done something like this?
What I'm trying to do is extract values, colors, comments, and any formulas for a range of cells in a given worksheet. The ultimate goal is convert a spreadsheet someone has been using as a database into Access tables.
worksheet.Cells(row,column).Value 'extract value WORKS worksheet.Cells(row,column).Font.ColorIndex 'extract color index WORKS worksheet.Cells(row,column).Comment.Text 'extract comment WORKS worksheet.Cells(row,column).Formula 'extract formula DOES NOT WORK
The return value for .Formula is same as .Value. That's not what I need. I'm looking for a textual representation of the formula (to extract rate information embedded within the formula).
I have a range of data that I want to replace with new data.So, I want to clear the old data and replace it with new data.But the formulas in the old data are also required to work on new data.[code]...
We have an automatic process that opens a template excel file, writes rows of data, and returns the file to the user. This process is usually fast, however I was recently asked to add a summary page with some Excel formulas to one of the templates, and now the process takes forever.
It successfully runs with about 5 records after a few minutes, however this week's record set is almost 400 rows and the longest I've let it run is about half an hour before cancelling it. Without the formulas, it only takes a few seconds to run.
Is there any known issues with writing rows to an Excel file that contains formulas? Or is there a way to tell Excel not to evaluate formulas until the file is opened by a user?
The formulas on the summary Sheet are these:
' Returns count of cells in column where data = Y =COUNTIF(Sheet1!J15:Sheet1!J10000, "Y") =COUNTIF(Sheet1!F15:Sheet1!F10000, "Y")
using an object-binding I have a an object representing "Employee". The employee has an ID-property. The ID of the employee must be unique.
My validation of the entered data is handled in the property set part of the object. In general, I validate criteria belonging to the object to validate only (eg numeric range of the ID, if it's value is not empy, ...). But in this case I need to know all ID's from the other employees. My tried this:
there is a datagridview, which will display Group Name in first column, Variables in second column.Users will populate it manually. will select a group name in first column, variable in second column. in similar, for some count of rows the group name remains similar, with different variables in second column.There may be different groups with lot of variables in second columns.our requirement is to insert a formula where ever its needed by the users.like getting subtotals at each level of groups.Also in case if they needed to have subtotal after two or three groups they must be able to define the row a formula to add those groups sum.
I'm working on a project where I need to evaluate some formulas in VB.NET. I've been using the MS Script Control to evaluate some of the simple logical/mathematical formulasHowever, I'm now faced with dealing with string expressions that set variables in my program to certain values. So, for example, let's say I've got the following:
Dim netPrice As Decimal Dim expressionFormula As String = "netPrice = 0"
i want to autofill a formula down a column of cells in excel. to manually do this, i would double-click the little black square at the bottom right of the cell, but i cannot figure out a way to do this using a macro.
I search a lot and couldn't find a code that really worked. So, I search more and after that, I wrote the following class. I hope that this code be useful for someone.First, add the following references to yours VB project:
how to create this certain program. In short, I must calculate the velocity of a ball thrown in the air after 1, 2, and 3 seconds. The formula for this is: -16t^2 +velocity(t)+height. the height for the ball is 5 feet per-second. So after defining each textbox of 1 sec, 2 sec, and 3 secs (Dim stuff) I need the button click to run through the formula then display the result for each second. How would I do this?
I need to migrate from Excel 2003 VBA to Excel 2007 VBA. When Microsoft introduced Excel 2007 it removed many objects from the previous versions and added some new objects. Also it hid some properties of particular objects. These hidden properties can be viewed by going to the object browser, right clicking any object and selecting "Show Hidden Members". My problem is I need to access these hidden properties. Is there any way I can access these properties. I can successfully migrate from Excel 2003 VBa to Excel 2007 VBA with the same functionality?
I am trying to add some style properties to a column but the code I am currently using doesnt seem to work at all? Dim oApp As New Excel.Application Dim oWB As Excel.Workbook = oApp.Workbooks.Add() Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet) Dim style As Microsoft.Office.Interop.Excel.Style style = oWB.Styles.Add("Style1") [Code] ..... It's still the same as "default" would look when just opening up excel for the first time.
In VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top..The code is part of a routine to programmatically check whether an image overlaps cells that are used in a workbook. My current method of iterating over the cells in the UsedRange is slow since it requires repeatedly polling for the top / left / width / height of the cells.I'm going to go ahead an accept Doug's answer as it does indeed work faster than naive iteration. In the end, I found that a non-naive iteration works faster for my purposes of detecting controls that overlap content-filled cells. The steps are basically:
(1) Find the interesting set of rows in the used range by looking at the tops and heights of the first cell in each row (my understanding is that all the cells in the row must have the same top and height, but not left and width)
(2) Iterate over the cells in the interesting rows and perform overlap detection using only the left and right positions of the cells.[code]
I'm writing a VB app to do stuff with some existing spreadsheets. I'd like to add a "properties" data structure to an Excel object and have two options:
1.
class ExcelPlusPlus Dim properties As HashTable Dim xlobj As Excel.Application End Class
2.
class ExcelPlusPlus Inherits Excel.Application
[code]....
I much prefer solution 2, as ExcelPlusPlus should respond exactly as Excel.Application.However, Visual Studio (2005) errors out on the "Inherits..." line saying "Classes can inherit only from other classes"
I am attempting to create an application for my (very) small businessRight now I am trying to create an "Add a Customer" formI know VERY LITTLE about MySql so I thought I would save the text into a textfile.. I then realized I do not know how to save multiple text box in a text file (I only knew how to save one text box in a text file)
This is a debate that can never be fulfilled without you. Please come forward and respond.What if we have a client who wants to develop a web enterprise application (based on SAAS architecture) and prefers for C# and not VB.NET based. Argument can be:
1. C# is better suited for developing enterprise application versus VB.NET
2. C# is object oriented versus VB.NET is not
3. Programming in C# is faster than VB.NET
4. Libraries/function blocks in VS.NET is more for C# versus VB.NET
I would request you to help me answer this. I believe this is the type of questions many faces when deciding for which language to go for, both developers and organizations.
I have an application that does complex calculations for members. Each member can have multiple US states linked to their profile. Each state has got different calculations for each course a member completes. As of now I have been performing the calculations in the DB (SQL Server 2008) and then sending data back to app layer where they can see their history and then download a certificate for each course. I have a business logic layer but not a lot happens there. I know this has been asked a lot but where do you think I should perform these calculations: business layer or database? I am going back and forth
Due to a discussion in another thread , I am starting to use business object in an 3-Tiered windows app. As a starting point, I am trying to build objects/classes on a table from my database.
The issue I'm currently having is mapping multiple GUI fields to object properties (i.e. Presentation layer to Business Logic Layer mapping). To be more specific, this is in VB.Net 2.0 WinForms. The nature of the solution requires us to have 4 columns which exhibit the same type of behavior on our GUI - each column consisting of 11 textboxes (we'll just use this small sample size, as the problem extends beyond 11 textboxes).
What I am currently doing is setting the tag of each textbox in all four columns to a value like so:
As you can see this can get very bad, rather quickly. Currently we're setting 43 some odd properties that can be mapped to -- thus that select statement is extremely long -- many of which are embedded in multiple methods to try and attempt DRY (I've watered down the code to essentially a conceptual implementation).
Question is: how can I refactor this? I've attempted using a dictionaries/hashes to a certain extent, but it either became overly complex, or just plain didn't make an implementation sense as it convoluted the problem even more.
I was having a discussion with a colleague about a method used to check business rules. In general there are two conditions:
"If one fails the whole thing fails"
Example 1: "If one fails the whole thing fails"I have used the following technique for condition 1 in several cases. Essentially if one of those conditions is false then the whole thing fails
Dim blnTemp As Boolean = True If Fail=False Then blnTemp = blnTemp AndAlso False {code code code}
does a big business in shirts, especially for groups and teams. They need a project that will calculate the price for individual orders, as well as a summary for all orders.The store employee will enter the orders in an order form that has text boxes for customer name and order number. To specify the shirts, use a text box for the quantity, radio buttons to select the size (small, medium, large, extra large, and XXL), and check boxes to specify a monogram and/or a pocket. Display the shirt price for the current order and the order total in labels.
Include buttons to add a shirt to an order, clear the current item, complete the order, and display the summary of all orders. Do not allow the summary to display if the current order is not complete. Also, disable the text boxes for customer name and order number after an order is started; enable them again when the user clicks on the button to begin a new order. Confirm the operation before clearing the current order.
When the user adds shirts to an order, validate the quantity, which must be greater than zero. If the entry does not pass the validation, do not perform any calculation but display a message box and allow the user to correct the value. Determine the price of the shirts from the radio buttons and check boxes for the monogram and pockets. Multiply the quantity by the price to determine the extended price, and add to the order total and summary total
The assignment also requires a pop up message "Daily Summary" with total shirts sold, total sales, and average sale per customer.So far I have this as my code but I am not sure what needs to change in order to display the correct total shirts- mine only displays the last accepted shirt order.
I am writing a program that takes a shipdate and generates a timeline of deadlines for a manufacturing job by working backwards from the shipdate. I hav no problem handling weekends. However, some holidays are giving me problems. For holidays that don't have a set date (Thanksgiving, Labor Day, Memorial Day...) what is the best way to determine the date they fall on? Most of the examples I have seen use an array of dates (either from a file or hard coded) for these holidays. Is there a way to do this tha won't require someon to generate a list every year for these holidays?
I need to calculate the end date given the number of business days (excluding weekend and holidays). All the examples I've seen so far return the number of business days between a start date and an end date.
I have a custom business object called Customer and a Form1 with a BindingSource1, NumericUpDown1, TextBox1 and ComboBox1 and the attached code. Setting break points in the Property Sets shows that the Set for the ComboBox never fires at all even though the Set for the NumericUpDown and TextBox fire like crazy. [code]
I'm working with BCM to create Business Project. I'm able to create the Business Project but what i would like to do that to create the Business Project with it's ItemProperties Vaue. For example : BusinessProject.ItemProperties("Project Start Date").Value = dtpStartDate.Value.Date. It gives an error (System.NullReferenceException: Object Reference not set to an instance of an object).
But when i edit the existing Business Project it allows me to add ItemProperties Value.