Differences

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

--- home_server:mswindows_notes [2024-05-22 Wed wk21 16:28] – [Annotative block] baumkp
+++ home_server:mswindows_notes [2025-03-18 Tue wk12 17:10] (current) – [MS Excel Highlight Row or Column] baumkp
@@ Line 91: / Line 91: @@
 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 98: @@
 ====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 120: @@
   *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 218: @@
 ======MSExcel Tips======
+=====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 329: / Line 389: @@
 =====AutoCAD=====
 ====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 commpands: '' graphicsconfig, 3Dconfig, options.
+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.
-====Accessibility Contract Checker====
+====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
+======Accessibility Contract Checker======
 Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly im
   *WebAIM
-    *[https://webaim.org/resources/contrastchecker/|Contrast Checker]]
+    *[[https://webaim.org/resources/contrastchecker/|Contrast Checker]]
     *[[https://webaim.org/articles/contrast/|Contract and Color Accessibility]]
     *[[https://webaim.org/articles/|Articles]]