In the report I then converted where it is needed. Return Math.Round(numberToConvert, 4, MidpointRounding.AwayFromZero).ToString("#.0000")
Public Shared Function GetCustomFormatToFourPlaces(ByRef numberToConvert As Double) As String To fix the report in this case I created a new method. This way as a user you don’t have to find a replace to make the numbers into real numbers and not dumb strings. When I do a report for a fee I do the report correctly and place the numbers in Excel and then format it utilizing Excel formatting. So to fix this issue I’m going to use the same method as Autodesk since I’m doing it for free.
Autodesk could have chosen to be nice to us users and placed the number in the Excel Spreadsheet and then formatted the numbers using Excel formatting. Autodesk creates a string value and when you save to Excel you get the string value. In this case I have a problem on how Autodesk implemented the reports. You are supposed to go in and program the reports to get what you want. Now this goes back to the little dirty secret of reports. Autodesk also puts a comma grouping in the numbers. So a meters drawing will get a “m” behind, for feet it will get “ft”. Their complaint is that Civil 3D for some reason puts the units behind a distance number. I recently got a request to modify one of the reports and I thought I’d make it into this block post. The expectation by Autodesk is that you go in and modify them to meet your needs and requirements. There is a little dirty secret regarding reports in Civil 3D they are not intended to be used out of the box without modification. Here is a link to a drawing with the expressions. Now the ending expression can be used in an alignment label or curve table. Here is the expression to get that value: In this case I know the center point location and the PI point, this has a length property that I can use. So first I have to figure out what similar triangle to use. I could have solved this problem by solving for the equation of line, or utilize the delta angles of a curve. The first part is to determine how you want to solve the problem. I usually break out the problem into parts. The problem is adding Northing and Easting value of the mid point of an alignment curve.
So sometimes I spend too much time solving other people’s problems. I learned it in Middle School math class and then once again during surveying class and once again programming numerous solutions. I find I’m relearning the remedial math over and over again since I forget the intricacies of what I learned before. Remember primary school math? I sure don’t remember all of it.
0 kommentar(er)
