Differences

This shows you the differences between two versions of the page.

--- home_server:mswindows_notes [2024-03-14 Thu wk11 05:37] – [friction factor calculation] baumkp
+++ home_server:mswindows_notes [2025-12-01 Mon wk49 13:22] (current) – [TOC (Table of Content Switches] baumkp
@@ Line 1: / Line 1: @@
-{{tag>mswindows windows setup tip notes personal license}}
+{{tag>mswindows windows setup tip notes personal license powertoys}}
 ======KPTree - MSWindows Setup======
 =====Background=====
@@ Line 19: / Line 19: @@
   *First up to make easier to load up system
      *Nextcloud Windows client - Cloud server client (**!L**)
-     *Keepass - Password and other secret info repository (**!L**)
+     *Keepass - Password and other secret info repository (L)
+     *KeepassXC - Password and other secret info repository, better than Keypass (**!L**)
      *I just use the built in Windows Defender for virus protection now
      *Xplorer2 - a multi-paned file explorer replacement - //I do not use any more. See notes below.//
@@ Line 28: / Line 29: @@
      *CCleaner - a Windows system maintenance program, clean junk files and registry and other - **Do not use anymore, looks like spam now**
      *FileZilla - and sFTP client program (**!**)
-     *Ghostscript - a PDF manipulator (**!L**)
+     *Ghostscript - a PDF manipulator (L)  I simply do not use much anymore
-     *iTunes - Apple iOS update control software - See Separate Section below (**!**)
+     *iTunes - Apple iOS update control software - See Separate Section below - I simply do not use much any more.
      *Setup printer / scanner - See separate notes below (**!**)
      *Vuescan - Is a paid scanner program. It is just for scanning and is simple and does the job __very__ well. (**!L**)
@@ Line 44: / Line 45: @@
      *Clementine - Music player, looks like a modern take on Winamp. I am using on Linux via Flatpak and also have installed on Windows 11 desktop. (!L)
      *Strawberry is a fork of Clementine and looks to be better maintained. (**!L**)
-     *Spotify (**!L**)  (I have family license as my sons have demanded.....) I am now family subscribed to YouTube which automatically gives YouTube Music.  I will probably move away from Spotify for this reason.
+     *Spotify (I no longer use this.  I have subscription to Youtube family, that includes Youtube music).
      *Youtube / Youtube Music, is web based on desktop and has apps for iOS (**!L**)
   *Remote Control / Cloud
      *Nextcloud Windows client - Cloud server client (**!L**)
      *Putty - a SSH terminal program for Windows (**!**)
-     *TigerVNC - remove video terminal program (**!L**)
+     *TigerVNC - remove video terminal program (**!L**) (Home server LAN access only)
+     *I run Guacamole on my server that allows remote VNC via HTTP. (**!L**) (Home server LAN access only)
   *Security
       *Keepass - Password and other secret info repository (**!L**)
@@ Line 58: / Line 60: @@
       *ACAD 2022 - CAD software I use at work.
       *Navisworks - 3D productivity software, I started using the limited free, version at work, Freedom.  I now have the full version at work, Manage.
-      *Foxit Pro - a PDF reader and writer (**!**) I use my private license at work.
+      *Foxit Pro - a PDF reader and writer (**!**) I no longer use, there is no full Linux that I can use on my home machines.
       *Qoppa PDF Studio - I got this for my Linux desktop.  It is sadly the only **full** pdf suit I could find on Linux. I have not tried on Windows or for work.  It looks pretty good though.(**!L**)
       *Bluebeam Revu - a PDF reader and writer I use at work now, definitely has the best PDF technician editing functions I have seen.  I still find working on standard documents easier on Foxit or Qoppa.
@@ Line 70: / Line 72: @@
   *YouTube Premium Family.  As much as I do not like supporting Google / Alphabeta I have been enjoying the use of YouTube Premium and they throw in YouTube Music too. The family like too.  Getting rid of the Ads has been wonderful!
   *Spotify - My son originally wanted this and I ended up going with family option.  Have move to YouTube option as it includes YouTube plus Music.
-====Microsoft PowerToys: Utilities to customize Windows====
+=====Microsoft PowerToys: Utilities to customize Windows=====
-[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]
+  *[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]
+  *[[https://github.com/microsoft/PowerToys|Github PowerToys]]
+  *[[https://learn.microsoft.com/en-us/windows/powertoys/fancyzones|Fancy Zones utility]]
+====Some key short cut keys====
+The Windows key is called the Super or Meta Key on Linux.  I will call the Meta key.
+So below is a list of special action keys.
+  *Shift (shift key, left or right)
+  *Alt (alt key, left of right)
+  *Ctrl (Control key, left or right)
+  *Meta (Meta, Super or Windows key, left or right)
+  *→ (Right arrow key)
+  *← (Left arrow key)
+  *↑  (Up arrow key)
+  *↓  (Down arrow key)
+  *PgUp (Page up Key)
+  *PgDn (Page Down Key)
+===Always on Top===
+  *Activate/Deactivate:  Meta + Ctrl + T
+===FancyZones====
+  *Activate/deactivate: Meta + Shift + `
+  *Apply saved Custom Layout: Meta + Ctrl + Alt + Number
 ====Software Licenses and Copyright====
 I am not overly pious about free versus purchased software.  I appreciate people should be rewarded for their efforts.  One has to have the upmost respect for those providing "free" software (true free, e.g. GNU free, **NOT** Facebook or Google free) .  Sadly in general paid software providers merit less respect.
@@ Line 91: / Line 119: @@
 Ultimately the software owner has the right to limit their software to 1 machine per license, however I have the similar right to decided this means the software it too expensive and inconvenient for me to justify to use. For this type of software I want a license that gives me unfettered home use on at least 2 machines and perhaps all home personal use machines, with a separate license for work use.
-===Foxit Pro===
+===Foxit Pro / Qoppa===
 Sadly there is no full featured GNU Licensed Linux PDF writer.  Further to this most paid versions, including Foxit Pro do not work on Linux. Interestingly the Free version of Foxit does have a Linux version.   Hence I purchase a copy of Qoppa Software's PDF Studio PRO that does run of Linux and Windows.  I may end up buying another license of Qoppa for my work machine in the future if happy with it, instead of Foxit Pro.\\  I was quite happy with Foxit Pro on Windows, but if they can not provide a Linux version...  Also Foxit originally allowed 2 installations per license and now seem to be going back to 1 machine one "Single-Use" license, which is a problem for me.  Qoppa states"...can be used on 2 machines of any OS."
@@ Line 98: / Line 126: @@
 ====iTunes - setup====
+++++I hardly ever use iTunes any more|
 iTunes is software I do not particularly like. First of all I do not use the Music feature having long ago rip my CD collection to MP3 and I simply do not like the way iTunes works. So the only real reason to use iTunes is for my iOS devices, backing up iOS devices etc. iTunes, in typical Apple fashion I find is not smart end user friendly as it has been designed for not smart users and attempts to hide the lower level file system. Further to this the configuration, backups and apps end up being very large amounts of files (multiple 1000s) and using huge amounts of disk space, in some cases well over 200GB!. So to help alleviate the excessive file system use on my primary Windows10 SSD I would like to move to my Linux NAS. The following are the steps to achieve this.
@@ Line 120: / Line 148: @@
   *iTunes playing up
 However one good trick is to simply run the install file "C:\Program Files\Common Files\Apple\Mobile Device Support\Drivers\usbaapl64.inf". The easiest way being to right click the file in exploer and select the install option.
+++++
 =====Printer Scanner Setup=====
@@ Line 217: / Line 246: @@
 ======MSExcel Tips======
+=====Show 2 sheets of same file=====
+Use the menu ''VIEW => New Window'' to open a new window in the active workbook
+=====MS Excel Highlight Row or Column=====
+The basic built in way :
+  * ''shift+space'' to highlight the row
+  * ''ctrl+space'' to highlight the column
+Use conditional formating, but this requires hitting ''F9'' or a VB macro to actually highlight.
+Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
+++++VB Code 1|
+<code>
+'from https://www.exceldemy.com/learn-excel/highlight/row/
+Private Sub Worksheet_SelectionChange(ByVal Target As Range)
+  If Target.Cells.Count > 1 Then Exit Sub
+  Application.ScreenUpdating = False
+  'Clear the color of all cells
+  Cells.Interior.ColorIndex = 0
+  With Target
+    'Highlight row and column of the selected cell
+    .EntireRow.Interior.ColorIndex = 38  'or use RGB(200,200,200) to pick a colour
+    .EntireColumn.Interior.ColorIndex = 24
+  End With
+  Application.ScreenUpdating = True
+End Sub</code>
+++++
+++++VB Code 2|
+<code>'from https://www.howtoexcel.org/highlight-current-row-column/
+Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
+Static xRow
+Static xColumn
+If xColumn <> "" Then
+    With Columns(xColumn).Interior
+        .ColorIndex = xlNone
+    End With
+    With Rows(xRow).Interior
+        .ColorIndex = xlNone
+    End With
+End If
+pRow = Selection.row
+pColumn = Selection.Column
+xRow = pRow
+xColumn = pColumn
+With Columns(pColumn).Interior
+    .ColorIndex = 6
+    .Pattern = xlSolid
+End With
+With Rows(pRow).Interior
+    .ColorIndex = 6
+    .Pattern = xlSolid
+End With
+End Sub</code>
+++++
 =====Text to Column=====
 When pasting text from other applications on occassions Excel places all the columns into one column. To adjust into multiple columns the following feature can be used. Menu: Data : Text to Columns
+=====Text Carriage Return / Line Feed=====
+  *Use char(10), e.g. ="Test text"&char(10)&"on new line"
+ON Mac/Linux this may be char(13) due to different ways these OS handle carriage return / end of line and line feed control charaters.
 =====List Windows files and directories into MSExcel=====
@@ Line 237: / Line 327: @@
 ====friction factor calculation====
 Earlier in my engineering career I used Lotus123 and MSExcel with iteration to calculate the friction factor of piping with Newtonian fluid according to the [[https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae#Colebrook%E2%80%93White_equation|Darcy friction factor formulae]].  To remove the iteration from the spreadsheet I wrote a simple VB script that took care of this.  When I get the change I will copy the script here.
+++++VSBasic code for Colebrook Equation|
 <code basic>'Public Re As Double 'Reynold number unitless 0<Re<10E9
 'Public Rr As Double 'Relative Roughness unitless
@@ Line 284: / Line 375: @@
 'Static Function Log10(X)
 '    Log10 = Log(X) / Log(10#)
-'End Function</code>
+'End Function</code>++++
 As can be seen in the wiki page, [[https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae#Colebrook%E2%80%93White_equation|Darcy friction factor formulae]], there are reasonably accurate equations that approximate the Colebrook equation that are available that do not require iterations to solve.  I believe the VBscript is simpler and not an approximation.....
+====Excel Conditional Formatting Applies to Field Changing Unexpectedly====
+MSExcel unnecessarily and annoyingly changes conditional formatting ranges.
+The options menu, advanced options, Editing options, unselect Extend data range formats and formulas reputedly stops this behavior.  Unfortunately, it also stops the automatic copying of formula when inserting new rows or adding new lines to the bottom of an existing list.
+References:
+  *[[https://answers.microsoft.com/en-us/msoffice/forum/all/excel-conditional-formatting-applies-to-field/9fa1d051-0599-4763-9782-87dc118fbfa2|Excel Conditional Formatting Applies To Field Changing Unexpectedly]]
+  *[[https://support.microsoft.com/en-us/office/advanced-options-33244b32-fe79-4579-91a6-48b3be0377c4|MSExcel Advanced Options Description]]
 ======MS Word======
+=====TOC (Table of Content Switches=====
   *[[https://www.bettersolutions.com/word/fields/toc-field.htm|TOC [switches]]]
     *''{ TOC \o "1-2" \h \z \f }''
@@ Line 293: / Line 395: @@
   *[[https://www.bettersolutions.com/word/fields/tc-field.htm|TC "text" [switches]]]
     *''{ TC  "Appendix A - Content/Name" \l 1 \n }''
+A good TOC reference: [[http://wordfaqs.ssbarnhill.com/TOCTips.htm|TOC Tips and Tricks]]  **<fc #ff0000>(Looks like a good MSWord site.)</fc>**  Also [[https://wordmvp.com/|The Word MVP Site]]
+=====Soft and Hard Return and Page Break and Section Breaks=====
+  *Hard Return: A hard return is created by pressing the Enter key. This action signifies the end of a paragraph and the beginning of a new one. It is visually represented in Word as a paragraph mark (¶) when non-printing characters are displayed. Hard returns help organize text into distinct sections, making documents easier to read and navigate.
+  *Soft Return: A soft return, also known as a line break, is created by pressing Shift + Enter. This action moves the cursor to the next line without starting a new paragraph. Soft returns are useful for formatting text within the same paragraph, such as in lists or when you want to break a line without creating additional spacing that a hard return would introduce.
+  *Page break: A page break is created by pressing Ctrl + Enter. These create a break between pages in your document, allowing you to start a new page without affecting the layout of the previous pages. They only partition the body text of the document.
+  *Section Breaks: There is no standard keyboard entry for section breaks.  Section breaks are inserted from the menu ribbon, under layout -> breaks (in the page setup ribbon) These allow you to change the layout or formatting of a section of your document. They can partition not only the body text but also headers, footers, page numbers, and margins, enabling different formatting within the same document.
+    * There are multiplate types of section breaks.  I normally use the __N__ext Page one that creates a new section and new page.
+Usage: Use page breaks for simple page transitions, while section breaks are useful for more complex formatting needs, such as changing the number of columns or page orientation within a document.
 =====MS Word and Excel Keyboard Shortcuts=====
@@ Line 317: / Line 428: @@
 ======Autodesk======
-=====AutoCAD Hardware Acceleration=====
+=====AutoCAD=====
-The Intel built in graphics accelerator seems to have problems with proper full screen resolution on 4K monitors.  A solution to rectify this is to turn off the hardware acceleration within the AutoCAD product, see [[https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-enable-or-disable-hardware-acceleration-in-AutoCAD.html|How to enable or disable hardware acceleration in AutoCAD]].  The hardware configuration option can be found using the following commpands: '' graphicsconfig, 3Dconfig, options.
+====AutoCAD Hardware Acceleration====
+The Intel built in graphics accelerator seems to have problems with proper full screen resolution on 4K monitors.  A solution to rectify this is to turn off the hardware acceleration within the AutoCAD product, see [[https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-enable-or-disable-hardware-acceleration-in-AutoCAD.html|How to enable or disable hardware acceleration in AutoCAD]].  The hardware configuration option can be found using the following commands: ''graphicsconfig'', 3Dconfig, options.
+====Annotative block=====
+If inserting block does not seem to scale or show up check the annotative option on the block properties.  The option can only be changed in block edit.
+====Inserting a Picture====
+Attaching a picture effectively externally references the picture.  Unlike a drawing xref these ole object do not seem to be able to be bound (embedded) to the drawing. This is subject to links path breakage, particularly on multiuser system.  Where the image is in the same directory the path can be specified as "./image.file".
+Use the PASTESPEC command and paste in as a picture file.  This embeds into drawing file, not as a link.
+====New Paperspace View port====
+  *''viewport'' to create new viewport
+  *''grid'' ''off'' to turn off grid
+====STYLEMANAGER====
+The command ''STYLEMANGER'' opens up the directory where the plot styles are stored.  Different plot styles can be copied to and from this directory.
+======Accessibility Contract Checker======
+Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly important to allow easier reading.
+  *WebAIM
+    *[[https://webaim.org/resources/contrastchecker/|Contrast Checker]]
+    *[[https://webaim.org/articles/contrast/|Contract and Color Accessibility]]
+    *[[https://webaim.org/articles/|Articles]]
+  *[[https://www.stylemanual.gov.au/|The standard for Australian Government writing and editing]]
+  *[[https://stylemanual.com.au/contents/writing/logical-structure/styles-and-templates|Sytle and templates]]
-<- home_server:web_server_setup|prev page ^ home_server:index|Start page ^ home_server:index|next page ->
+<- home_server:media_vm_setup|prev page ^ home_server:index|Start page ^ home_server:dokuwiki_setup|next page ->