Search found 820 matches

by Albireo
Yesterday, 16:42
Forum: Ask For Help
Topic: Convert filenames from Windows to URL
Replies: 3
Views: 149

Re: Convert filenames from Windows to URL

Thanks for the "push" :D This solution .: FileNameURL := "File:///" StrReplace(StrReplace(File, "\", "/",, Limit := -1), " ", "%20",, Limit := -1) works in my example (but there are maybe better ways? Which works in more cases?) A Test program .: File := "c:\Temp\Test File.ods " File = %File% ; Repl...
by Albireo
Yesterday, 08:39
Forum: Ask For Help
Topic: Convert filenames from Windows to URL
Replies: 3
Views: 149

Convert filenames from Windows to URL

Is there any AHK function that converts to the Internet Standard RFC 1738? The Internet Standard RFC 1738, upon which this is based, permits use of the 0-9, a-z, and A-Z characters. All other characters are inserted as escape coding in the URLs. To do this, they are converted into their hexadecimal ...
by Albireo
15 Sep 2019, 18:30
Forum: Ask For Help
Topic: API LibreOffice Calc - Save the spreadsheet.
Replies: 0
Views: 76

API LibreOffice Calc - Save the spreadsheet.

I want to save the open spreadsheet (LibreOffice Calc) with AHK through the OO API The path and name, is saved in the cells ( C3 and C4 ). C3 = c:\temp C4 = TestFile.ods I have write an AHK-program as use an API to LibreOffice (/OpenOffice?) as .: Opens a new spreadsheet (LibreOffice Calc) Give a ta...
by Albireo
15 Sep 2019, 13:50
Forum: Ask For Help
Topic: Is Autohotkey and Win CE 5.0/6.0 a possible combination
Replies: 9
Views: 386

Re: Is Autohotkey and Win CE 5.0/6.0 a possible combination

Great!
I have to test (a little later this autumn ...)
by Albireo
15 Sep 2019, 08:30
Forum: Ask For Help
Topic: Is Autohotkey and Win CE 5.0/6.0 a possible combination
Replies: 9
Views: 386

Re: Is Autohotkey and Win CE 5.0/6.0 a possible combination

Thank you for your suggestion! Do you have any experience with PDA / Win10) Is this combination fast? Is it possible to find a high-resolution 2D scanner with fast software? I have to consider how communication between the desktop system with e.g. computers and servers should be managed. One disadva...
by Albireo
14 Sep 2019, 15:35
Forum: Ask For Help
Topic: Use a variable - API for LO Calc Topic is solved
Replies: 9
Views: 381

Re: Use a variable - API for LO Calc Topic is solved

Yes, it works!
Thank you!
by Albireo
14 Sep 2019, 12:13
Forum: Ask For Help
Topic: Draw lines around cells - API LO Calc
Replies: 0
Views: 85

Draw lines around cells - API LO Calc

This is, first and foremost, a structure question I have done an AHK program that works. (at my place) It marks different areas in a spreadsheet, with colors and lines around the cells. ; Version 2019-09-13 ; Andrew Pitonyak, Macros Explained - "OOME_3_0.pdf" ; Listing 411 - Add cell borders ; #Warn...
by Albireo
14 Sep 2019, 10:37
Forum: Ask For Help
Topic: Use a variable - API for LO Calc Topic is solved
Replies: 9
Views: 381

Re: Use a variable - API for LO Calc Topic is solved

...Btw it's a bit confusing that you used 8355711. I.e. there are 2 example colours in your post: 0xFFFF9E = 16777118 0x7F7F7F = 8355711 Excuse me! - I did many tests and copied from different tests ... (the color does not matter in this case) I have tried your tips, like this .: oCells := oSheet.g...
by Albireo
14 Sep 2019, 09:22
Forum: Ask For Help
Topic: Use a variable - API for LO Calc Topic is solved
Replies: 9
Views: 381

Re: Use a variable - API for LO Calc Topic is solved

Thank you! Now I have found a "walk around" the problem :D It is possible to do the same thing in many ways... 1) This was my desire (but with the color in the variable) oCells.setPropertyValue("CellBackColor", 0xFFFF9E) 2) This gives the same results as (1) (but the number of the color is not easy ...
by Albireo
14 Sep 2019, 08:08
Forum: Ask For Help
Topic: Use a variable - API for LO Calc Topic is solved
Replies: 9
Views: 381

Re: Use a variable - API for LO Calc Topic is solved

Thanks! I tried with the following solution .: BgColor := "0xFFFF9E" oCells.setPropertyValue("CellBackColor", (%BgColor%)) But my problem remains... A part of the AHK-program .: ... FrameWidth := "50" ; x 0,01mm => 0,5mm FrColor := RGB(255, 0, 0) ; Red GridWidth := "20" ; x 0,01mm => 0,2mm GrColor :...
by Albireo
14 Sep 2019, 06:50
Forum: Ask For Help
Topic: Use a variable - API for LO Calc Topic is solved
Replies: 9
Views: 381

Use a variable - API for LO Calc Topic is solved

Hi! I want to control the contents of a spreadsheet (LibreOffice Calc) with AHK. The command to change the background color of a cell looks like this .: oCells.setPropertyValue("CellBackColor", 0xFFFF9E) ; Light yellow background (R G B) and it works! But I want to use a variable to select the color...
by Albireo
13 Sep 2019, 10:02
Forum: Ask For Help
Topic: Show text in UTF-8 with MsgBox - possible? Topic is solved
Replies: 7
Views: 342

Re: Show text in UTF-8 with MsgBox - possible? Topic is solved

Maybe later! (I have no time - right now)
(I do not know how to best manage files / images on this forum)

But as I said - Cut out the entire AHK program in Notepad++ (if it is written in UTF-8 format)
then switch to ANSI and paste everything again (and save the result) the problem is solved ...
by Albireo
13 Sep 2019, 07:32
Forum: Ask For Help
Topic: Open Office API/UNO Writer Topic is solved
Replies: 9
Views: 500

Re: Open Office API/UNO Writer Topic is solved

Have you made any progress with the AHK / Calc project?
Any ideas?

Now I am thinking how text can be changed in Calc with AHK. (bold / normal / color / font size.)
Is there anyone who knows?
by Albireo
12 Sep 2019, 06:04
Forum: Ask For Help
Topic: Show text in UTF-8 with MsgBox - possible? Topic is solved
Replies: 7
Views: 342

Re: Show text in UTF-8 with MsgBox - possible? Topic is solved

I'll look at what you say (maybe I don't understand) ... change *cp65001 to the correct codepage .... Is this wrong syntax? FileRead InputTXT, *t *p65001 %A_ScriptDir%\%NameTXT%.txt ( *p65001 comes from the AHK manual FileRead ) *cp65001 doesn't work for me. I get the same result, (åäö is not åäö :)...
by Albireo
12 Sep 2019, 01:42
Forum: Ask For Help
Topic: Show text in UTF-8 with MsgBox - possible? Topic is solved
Replies: 7
Views: 342

Re: Show text in UTF-8 with MsgBox - possible? Topic is solved

Thanks!
(I did not know the instruction strput())
by Albireo
11 Sep 2019, 17:35
Forum: Ask For Help
Topic: Capture OCR - in text format
Replies: 14
Views: 862

Re: Capture OCR - in text format

Thanks! Ahk_fan I have tested your example (but I don't understand the result… :? ) I like your use of the variables Column1 ... Column5 . After a deeper analysis, I get the best result from pdftotext.exe with the option -table like this .: RunWait, %comspec% /c ""%A_ScriptDir%\pdftotext.exe" "-tabl...
by Albireo
11 Sep 2019, 16:07
Forum: Ask For Help
Topic: Show text in UTF-8 with MsgBox - possible? Topic is solved
Replies: 7
Views: 342

Show text in UTF-8 with MsgBox - possible? Topic is solved

I'm read a file written in UTF-8 with .: FileRead InputTXT, *t *p65001 %NameTXT%.csv (it works) But, If I want to display the content of each line as follows .: FileRead InputTXT, *t *p65001 %A_ScriptDir%\%NameTXT%.txt Loop Parse, InputTXT, `n { MsgBox ,,, % A_LoopField ... MsgBox shows a number of ...
by Albireo
11 Sep 2019, 06:39
Forum: Ask For Help
Topic: Divide a row into columns
Replies: 4
Views: 290

Re: Divide a row into columns

Thanks for your time! The both suggestions work based on my description (but ...) Have analyzed the results of both AHK-programs. (and I also analyzed the contents of the original file - do I understand the content?) Have searched for differences in the origin files (Have all the files I want to ana...
by Albireo
06 Sep 2019, 03:44
Forum: Ask For Help
Topic: Capture OCR - in text format
Replies: 14
Views: 862

Re: Capture OCR - in text format

Thanks every one! Now it works. (even with the latest version of pdftotext.exe ) (I made many mistakes by myself …) - I had written the AHK-program in UTF-8 format. (the file 01-Umeå.pdf could not be found.) - I missed putting the outer quote characters around the entire string like this ""pdftotext...
by Albireo
05 Sep 2019, 17:23
Forum: Ask For Help
Topic: Divide a row into columns
Replies: 4
Views: 290

Divide a row into columns

Hi! I have (many - maybe 100...) text files with columns (and spaces between the columns) I would like to process the content so that it is easier to import into Excel / Calc This is an example (vith fake numbers) - only for tests _____________________________________________________________________...

Go to advanced search