Adding Display Zero as Dashes to Custom Excel Number Format
Hi There, I am currently using the following custom format cells for my number display: #,###.0,;[Red](#.0,); I would like to add to this, so that when a value is "0", a dash "-" is displayed instead of the zero. Thanks in advance for the help! EmmaFormat-table combining results from multiple commands on same row
(I'm new to PowerShell and my understanding is limited so I would appreciate a brief explanation as well as a solution if possible) I've got the following code running successfully to query a list of computers and return various data about them in a table. However, the data from the various commands run against a particular computer is not appearing on the same row. Can anyone suggest a way to combine the results for one machine onto a single table row? $hostnames = Get-Content "allpcs.txt" $output = foreach ($hostname in $hostnames) { if (Test-Connection -ComputerName $hostname -Count 1 -ErrorAction 'SilentlyContinue') { Invoke-Command -ComputerName $hostname -ScriptBlock { Get-WmiObject Win32_ComputerSystem | Select-Object -ExcludeProperty name; (Get-ItemProperty -Path "c:\windows\system32\hal.dll").VersionInfo.FileVersion; (Get-ItemProperty -Path "C:\Program Files (x86)\Microsoft Office\root\Office16\ONENOTE.EXE").VersionInfo.FileVersion; gcim Win32_OperatingSystem | select InstallDate,LastBootupTime; Get-PSDrive C | select Free; } } else { write-host $hostname "not connected" } } $output | Format-Table Name,OSver,O365ver,InstallDate,LastBootupTime,Free | Out-File -filepath allpcs.csv -Append Example output: Name OSver O365ver InstallDate LastBootupTime Free ---- ----- ------- ----------- -------------- ---- comp1 10.0.16299.371 (WinBuild.160101.0800) 16.0.8431.2110 05/10/2018 16:18:59 14/11/2018 09:48:33 40862683136 comp2 10.0.16299.371 (WinBuild.160101.0800) 16.0.9126.2259 13/08/2018 15:49:28 09/11/2018 07:46:41 436695408640
Table Of Contents Formatting Not Matching Heading Style Formatting
In my word document (Microsoft Office Professional 2019 / .docx) all of the headings are setup using the Heading 1 style which is set for font= Arial, Size= 12, and BOLD is turned on. My table of contents is setup to use the Heading 1 style as shown: {TOC \h \z \t "Heading 1,1,Heading 2,2,Heading 3,3" } The table of contents works to capture all of the correct pages, however, where all of the headings in the document are done in all caps, the entries in the table of contents vary from all caps, all caps for the first word or two, to all lowercase as shown below. I've tried to update the Heading 1 style and then doing the "Update Field / Update Entire Table", but the text in the TOC stays the same.
Formatted view - hideColumnHeader not working in list webpart
I have a list webpart on a modern site which has a view formatted with some JSON The list column header displays even though the property hideColumnHeader is set to true (this just started happening - was fine before) It is OK on the list page -AllItems.aspx but on webpart page list column header displays I am using https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/view-formatting#get-started-with-view-formatting to test anybody have any ideas?Column Formatting in List View Web Part
I have created a Site Page, where I added a List View Web Part with reference to a list which has JSON-conditional formatting in it. For myself the conditional formatting works (doesn't exactly looks the same but hey, at least I see the colors.), but other coworkers don't see the formatting at all. Those coworkers have the same (or even higher) permissions to the site page and the lists themself, so rights should not be the issue. Does this feature for you guys work and if yes, whats your setup (rights) etc. If my coworkers go to the list them self they see the formatting.
