Comments by avianrand (Top 29 by date)

Before I posted my question I tried setting DefaultRowHeight to other values like 25, 40, etc. None of them had an effect.

Anyway, why does CodeProject have tags for tons of other things that can be handled elsewhere? I don't think I made an unreasonable request.

GitHub is not the right place. They don't take tech questions there. They want everyone to go to stackoverflow. I don't use stackoverflow. The people there are extremely uncool. I stopped using it a long time ago. The people here are (generally) nicer.

Could y'all add a tag for EPPlus?

Why does this forum change my subject to mostly lower case? That doesn't make sense. It should read "EPPlus DefaultRowHeight doesn't work" but it changed it on its own. Ugh.

I had an email conversation with a tech support person at Embarcadero. I'm fairly certain that my issue has nothing to do with Delphi. I think it's the way I'm creating the DLL. I created a new question focusing exclusively on that issue:

https://www.codeproject.com/Questions/1248969/My-registered-DLL-doesnt-show-up-in-assemblies-ext

Once that's solved, I'll repost here whatever ends up working.

Yes. I did try that. I tried adding the path to the release folder of the dll into the function declaration in Delphi as well. Neither of those worked. I'm sure I'm mucking up something with how I'm creating the dll or how I'm registering it. I tried it as com too, that did nothing. I registered it with RegAsm.exe but even if it's not registered it still works when I call it from my test vb.net app so I'm not sure what's up. I'm not a dll expert by any means. I need to do something in .net that I can run from Delphi because it can't be done in Delphi.

I was going to do that but it meant rewriting a ton of existing code to handle the fact that rows were still there but marked as deleted. It got more complicated than I wanted it to be. Easier to delete and post to log.

Oh, that seems like a good idea. So you're saying to add a column to the trigger table to store the user that makes whatever mods are made to it? So if the data is added new, store the user name there, if it's updated, store it there too. Deletes get a little trickier. I guess I'd store the user name in the row first and then do the delete. The "deleted" table in the trigger would still have that value in it.

I'm looking into the context_info idea right now but if that doesn't pan out, your idea should work. Thanks.

I looked up version numbers for SQL 2005. Apparently the production server is running SP2 and my development machine is running SP3. We're updating the dev server over the weekend so hopefully that solves the problem. If anyone has any input on this before hand, it would be welcome. Otherwise we'll see how it goes and I'll report back.

Thanks Ryan. That worked. Much appreciated. Nice of MS to put it in such a convenient location! LOL.

Yep. SSL, IP filtering, authentication, etc. All in the plans. Just wanted to be sure that a web service is the best way to go on this. Since there won't be a U.I. for this, we just wondered if there were other ways to go that might be better. Thanks for your answer.

That's what I 'm doing now, but where this is currently run by one person at a time, there will be 2 more offices that could do this all at the same time. The data that I'm putting in is a "date/time of import" for the entire batch (every row must have the same date/time so it can't be a datetiemstamp) and an office designation. These 2 columns are initially null and are updated immediately after the import. The update is filtered on the nulls. But it's remotely possible now that 2 people could run this at the exact same time and end up with one of them populating the null values on both batches. I tried to get the people that create the text file to add an office designator column but they can't do that apparently.

Thanks, but neither of those solutions work. I've tried many variations on the "i" and even just hard coded things like Range("A1:B2"), etc. The problem doesn't seem to be in the way I'm referencing the cells but in the way I'm referencing the workbook or worksheet or something like that.

I wanted to do that but all these comments, including your solution are under "solution 1" which is not the solution. I don't want to mark that as accepted because it's wrong. Add your solution, the one that worked, as a new solution and then I'll mark that as correct.

Thanks E.F. The solution of not using the clipboard for copy/paste seems to have done the trick. Much appreciated.

It's always invisible. I've got the visibility set to false the entire time. After the file is saved and closed it asks if the user wants to view it and then opens it up if he/she does. Most of the time they don't want to view it. They just grab it and send it off to their client. And to answer your question, no, it goes wrong on my laptop also. I created all this code on my main dev desktop pc last week (winxp, office 2003) and it ran fine. But on my laptop (same os and office as my other) it doesn't work as well as not working on the client machine that it's been tested on. Ugh!

ONe other odd thing is that when I stepped through the code, i stopped it right after the "copy" command and then did a manual paste into an open spreadsheet and it worked fine. It just won't paste via code. Not sure if that helps anyone figure this out or not.

Same error. I did what you have and also tried it this way (there is "Add" code above the xlWkShtFinal declaration):

Collapse | Copy Code

Dim xlFinal As Excel.Application
Set xlFinal = CreateObject("Excel.Application")
Dim xlWkBkFinal As Excel.Workbook
Set xlWkBkFinal = xlFinal.Workbooks.Add
xlWkBkFinal.Worksheets.Add

Dim xlWkShtFinal As Excel.Worksheet
Set xlWkShtFinal = xlWkBkFinal.Worksheets(1)

With xlWkShtFinal

.Range("A2:A2").Select
.Paste



The odd thing is that my original code worked last week on my main computer. I'm running from my laptop right now as my desktop is down for the moment. I thoroughly tested the code before sending it to my client. I know it worked fine. So something else is going on here. No missing references either if anyone wonders about that one. Same version of Office on both of my machines as well.

I thought I found an answer here: http://brainof-dave.blogspot.com/2006/11/paste-method-of-worksheet-class-failed.html[^] but it didn't fix the problem.

I should also point out that when I comment out the "paste" line, all the rest of the code runs fine. The spreadsheet is created and saved with all the formatting and column headings I'm adding via code.

You're right. I got a little ahead of myself when I responded to your answer. LOL.

Thanks. I'll check it out. That makes sense. At a glance it looks like by using CancellationPending, there's no need for a timer?

Thanks but that didn't work. Here's what I did:

Dim sTestString As String = "Mr. [[husband name]] is married to Mrs. [[wife name]] and they have [[num kids]] kids"
Dim sTestPattern As String = "([^\[]*(\[\[[a-zA-Z0-9\s]*\]\])?[^\[]*)*"
Dim sTestResult() As String = Regex.Split(sTestString, sTestPattern, RegexOptions.IgnoreCase)

Which returned this:

(0) = ""
(1) = ""
(2) = "[[num kids]]"
(3) = ""
(4) = ""
(5) = ""

Additionally the string being tested may or may not have unbracketed text at the beginning or the end of the string. It could look like this:

[[husband name]] is married to Mrs. [[wife name]] and the number of kids they have is [[num kids]]

Could you explain with an example of what you would do?