Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 "); } } // // inject some CSS v_CssStyle = ""; v_CssStyle = v_CssStyle + ".zc-Color_Picker .my-color-picker{width:17px;height:17px;border:0 !important;margin-right:1px;}"; v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-cell span{padding:0...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Change div height to fit contenthttps://www.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a sidebar, I don't want it to overlap the header nor the footer.I have a content page next...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: en-GB

Calculate Aspect Ratiohttps://www.joellipman.com/graphic-design/calculate-aspect-ratio.html

17 January 2019 article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new height (original width...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 margin 0.3s ease-in 0s; } .onoffswitch-inner:before, .onoffswitch-inner:after { display: block; float: left; width: 50%; height: 30px; padding: 0; line-height: 30px; font-size: 14px; color: white; font-family: Trebuchet, Arial, sans-serif; font-weight:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones that appear in the ruler as little arrows). So right-click on...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 :c) and works with apple macs!). The HTML Slide #1 Slide #2 Next Slide The CSS #window_slide{ display:block; width:100%; height:400px; overflow:hidden; } #inner_window{ display:block; width:100%; height:400px; overflow:hidden; } #slide_01{...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rs:Format=PDF&rc:PageWidth=11in&rc:PageHeight=8.5in Or a clean export to PDF with minimal margins http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions3.1.1 Artur- Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 encodeUrl("Test Content"); openUrl( "#Page:Notify?p_NotifyTitle="+v_nTitle+"&p_NotifyContent="+v_nText+"", "popup window", "height=150,width=300"); If you want to do this on the click of a link, include the URL parameter zc_LoadIn=dialog: Click Here to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 aligned to the right of a central content section. I separated off the clouds as another div layer, specified the width and height and specified it's left. It caused the horizontal scrollbar which is a bit annoying because you scroll to the right and...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 the CSS though: #container { position: relative; } #content { position: relative; top: 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image: url("../images/bg_contentbox.png"); /* semi...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 Title := "Joes Folder Sizes" Desc := "This program will display folders and their respective sizes." Width := 500 Height := 360 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +ToolWindow -Resize -MaximizeBox -MinimizeBox...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 (3rd) monitor v_XCoord := a_MyArray[2,0] v_YCoord := a_MyArray[2,1] v_ThisWidth := a_MyArray[2, 2] - a_MyArray[2, 0] v_ThisHeight := a_MyArray[2, 3] - a_MyArray[2, 1] ; Open Notepad on right-most (3rd) Screen RunWait, Notepad.exe v_LastID :=...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 it popups a div at the centre of its app. The alert message is always at the center of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch of CSS and instead of...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Desc := "This program will list all the Google Chrome profiles available from your login." Version := "1.0" Width := 400 Height := 800 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border +OwnDialogs" TempDir := "C:\Windows\Temp" ;...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Desc .= " and then add an increment to the file name if a file with the same name exists." Version := "1.1" Width := 600 Height := 600 BgColor := "EEEEEE" FgColor := "34495E" Options := "+Caption +Border +OwnDialogs" DefltDir:= A_ScriptDir ;...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 #eee; } #my-line-items thead tr th:first-child{ width: 50%; text-align:left; } #my-line-items tbody tr td img{ width: 75px; height: auto; max-height: 75px; max-width: 75px; margin-right: 15px; float:left; } #my-line-items tbody tr td{ font-weight:400;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *