9/21/2020: Angela.py macro for LibreOffice cryptology

install fonts

• download Symbola fonts
• unzip (?)
• copy/paste file to windows system font dir

LibreOffice

install as directed, then:

• select Symbola font
• -> Insert -> Special Character
• manually step through all and choose "Hexadecimal U+hhhh" of ones that look good
• put those into cy_trans dictionaries in macro
• install macro to here: /cygdrive/c/Users/wendell/AppData/Roaming/LibreOffice/4/user/Scripts/python

create code:

• open new LibreOffice Text document
• insert desired text to be encoded
• manually fill background of consanants with "Gray 3"
• highlight all text
  • Tools -> Macros -> Run Macro
  • -> MyMacros -> Angela -> angelaPython
  • -> Run
• for each group of 4 (hex) characters, put cursor after that group, and Alt-x

problem: consanant highlighting/background disappears!
solution: use groups for vowels (dice, chess, arrows, trigraphs, etc.)

Unicode

Unichar

Unicode hex values in LibreOffice on Debian Linux

Type special characters in LibreOffice (using Unicode)

==============================================================================

11/3/2019: make postg table

1) in /cygdrive/c/Users/wendell/Documents/angela/betty_feezor/tabs, edit together.ods (using LibreOffice)

clean up, and put all data into one column, adding section and cookbook name (but don't know proper name today)

2) on webfaction

• clean up using sed to cvt x92 and x91 to single quote, and remove empty lines
  

    sed "s/\x92/'/g" together_v1d.csv | sed "s/\x91/'/g" | grep -v ",,," > cleaned.csv

• clean up using sed to cvt x92 and x91 to single quote, and remove empty lines
  

    ./create_and_insert.sh

Macro to clean up scanner text

This macro cleans up the index scanner text.

1) create dir for LibreOffice macros

In File Explorer, open to the home directory:

    - Windows (C:) -> Users -> you
    enter %appdata% in search box
    dbl click on "AppData C:\Users\you\"

    -> View (in top menu bar) and check 'X' Hidden Items
    -> Roaming
    -> LibreOffice
    -> 4
    -> user
    Create new directory 'Scripts'
    -> Scripts
    Create new directory 'python'
    -> python

2) Download the script

Get it from here: http://notes.ilikecarrots.com/macros/Betty.py.txt

and put it into the 'python' directory just created.

Rename the script (if needed) from Betty.py.txt to Betty.py

3) Start LibreOffice

Enable the macro.

    -> Tools -> Customize
    (under) Category -> '+' LibreOffice Macros
    -> '+' My Macros
    -> '+' Betty  (or maybe just on 'Betty')

`bettyPython' should show up in the Function window

Highlight the key combination desired to call the macro, e.g.

-> Alt+D
-> Modify

4) Use macro

In the LibreOffice editor, hightlight the text.

The pattern that the macro recognizes is:

    <string of letters and spaces><string of not letters or numbers><numbers>

When a block of text is highlighted, press the keyboard shortcut to run the macro:

    Alt+d

Text should be reformatted to csv-like lines.

5) Copy into spreadsheet

Highlight the text (is may already be done)

    Copy to clipboard

In another window, have the LibreOffice Calc (spreadsheet) open.

    right click on first cell
    -> Paste Special -> Unformatted Text

Two columns should appear in the spreadsheet.

done.