User:Htietze

User:htietze

Name: Heiko Tietze IRC: htietze Telegram / Matrix: @htietze Email: Affiliation: UX Mentor @TDF Blog: https://design.blog.documentfoundation.org/ Location: Neuhaus am Rennweg, Germany Timezone: UTC+1

Surveys

 * Website2020 "Results from the survey about LibreOffice’s web presence" [[File:20200622_WebsiteSurvey.zip]]
 * Calc Survey 2021 "Results from the Survey about LibreOffice Calc": Raw data [[File:CalcSurvey_RawData.zip]], R scripts [[File:CalcSurvey_RScripts.zip]]

Presentations

 * FOSDEM2019 "Quo vadis, LibreOffice extensions?" [[File:20190125_FOSDEM-ExtensionsOCS.odp]]

Impress templates

 * [[File:20180210_Templates.zip]]

Table Styles
User defined TS are located at ~/.config/libreofficedev/4/user/config/ on Linux and C:\Users\ \AppData\Roaming\LibreOfficeDev\4\user\config on Windows, both named autotbl.fmt. This file is copied from \LibreOfficeDev 6\presets\config when not existing.


 * Writer [[File:TableStyleDummy.odt]]
 * Calc [[File:Calc-TableStyleDummy.ods]]

TDF Nextcloud via WebDAV

 * Type: WebDAV
 * Host: nextcloud.documentfoundation.org
 * [x] Secure connection (=> Port: 443)
 * Label:
 * Root: /remote.php/webdav

Prefix rules (by MikeK)

 * If this is a (smart) pointer/reference to an UNO interface -> xName
 * If this is a (smart) pointer to anything else -> pName
 * If this is a reference to anything else -> rName
 * If this is an integer value -> nName
 * If this is a floating-point number -> fName
 * if this is a boolean -> bName, or isName, or canName
 * If this is a string -> optionally sName (for char* you may use pName; for OUString you may use aName)
 * If this is another object -> aName
 * Code convention: https://wiki.openoffice.org/wiki/Writer/Code_Conventions

Extract daily build
wget -r -np -A '*x86-64_deb.tar.gz' http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86_64@70-TDF/current/ mv "dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86_64@70-TDF/current/"*. rm -r dev-builds.libreoffice.org/ tar -zxvf *.tar.gz --strip-components=2 rm README_en-US rm -r opt/ rm -r usr/ deb2targz *.deb rm *.deb for f in *.tar.gz; do tar -zxvf $f; done rm *.tar.gz
 * 1) !/bin/bash
 * 2) download
 * 1) extract everything ignoring up to two path
 * 1) remove old stuff
 * 1) extract debs; use second line for debian based systems like Ubuntu
 * 1) for i in *.deb; dpkg -x $i ./; done
 * 1) clean up

Telegram

 * LibreOffice Design EN: https://t.me/joinchat/AAAAAAx1jkAG95bMPMKh8Q
 * LibreOffice Design DE: https://t.me/joinchat/AAAAAAxsR8PjxfJxtsnLfQ
 * Channel icon: https://wiki.documentfoundation.org/File:Telegram-LibODesign.odg

Logo colors

 * Basic: 666666 to 333333
 * Writer blue: *0369a3 to 023f62 (*Blue 1)
 * Calc green: *18a303 to 106802 (*Green 1)
 * Impress red: *a33e03 to 622502 (*Orange 1)
 * Draw yellow: *c99c00 to 876900 (*Yellow 1)
 * Base pink: *8e03a3 to 530260 (*Purple 1)

Git cheat-sheet

 * New/delete branch: git checkout -b | git branch -D
 * Commit for another person: git commit --amend --author='Full Name '
 * Clean up: git fetch --all && git reset --hard origin/master
 * Contributions: git --no-pager shortlog -n -s --author=" "
 * Replace text: git grep -l | xargs sed -i 's/ / /g'
 * Find files with exclusion: git grep -- './*' ':(exclude)*.foo' ':(exclude)*.bar' ':(exclude)extra/source/'
 * Introduction/Modification of a string: git log --all -p --reverse --source -S 'needle' or git log -G 'needle'