#apply conditional formatting to cells at runtime

[file-formats-programming]

Apply Conditional Formatting to a Cell or Range of Cells in Excel Files inside Cloud Apps

What's New in this Release?

We are pleased to announce the new release of Aspose.Cells for Cloud 17.8.0. Aspose.Cells for Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. This new release comes up with a new feature. Developers can add and manipulate Conditional Formatting using conditionalformattings API. Conditional formatting allows users to apply formats to a cell or range of cells and have that formatting change depending on the value of the cell or the value of a formula. Aspose.Cells for Cloud API now supports to apply conditional formatting to cells at runtime. The documents/articles in the section explain on how to add and manipulate conditional formatting (add cell area, apply format condition, get conditional formatting, remove conditional formattings, etc.) in the worksheet. The list of new and enhanced features added in this release are given below

Support conditional formatting

Sort table's data using ListObjects API.

Calculate cell's formula using Calculate API.

Start a free trial today – all users need is to sign up with the Aspose for Cloud service. Once users have signed up, users are ready to try the powerful file processing features offered by Aspose for Cloud.

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. Users can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

More about Aspose for Cloud

Learn More about Aspose.Cells for Cloud

Download Aspose.Cells for Cloud

Aspose.Cells for Cloud Documentation

Ask technical questions/queries from Aspose for Cloud Support Team

[sasinstitute-blog]

Program Modules

BASIC EXCEL FUNCTIONS

What is Excel?

Microsoft Excel is a general purpose electronic spreadsheet to use to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business.READ MORE

Provide Basic/Advanced Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools.

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions:-

Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function:-

Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation :-

Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small

Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting,          Data Validation, Group & Ungroup, Data split.

===============

ADVANCED EXCEL FUNCTIONS

Statistical Function & Other Functions :-

Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions:-

And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions:-

VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link                                                          

Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis - Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

Advanced Chart Technique, How to Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt chart.

Advanced Dashboard.

Report Development - (Real World Data)

=====================

DASHBOARD

VBA | MACROS PROGRAMMING

Excel VBA Power Programming For VBA Macros

Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files. Opening & Saving Files

How to Analyze Data On Multi Worksheets And Build Summary Sheets

How to Access The Windows File And Folder System To Open And Close Workbooks

How to Protect Your Code Against Errors

How to Use Excel And VBA To Create Basic Dash Boards

How to Create Your Own Custom Business Worksheet Functions In VBA

How to Create Basic Report Generation Tools Using Excel VBA, Microsoft Word And PowerPoint

How to Use The Excel Visual Basic Macro Recorder To Record Excel Tasks In VBA And Then Interpret The Code

Overview of Using User forms To Create Business Wizards

Working with User Forms & User Forms Events like List box, Combo box, Option Buttons, Checkbox, Textbox, Labels, Command button, Toggle button.

How to create dynamic dashboard on user form with different controls

How to link various user form with each other to create a complete interface between user and system

Connection between Excel VBA & other platforms

How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website through VBA

How to Establish Connection Between Excel VBA and power presentation to create power point through VBA

How to Establish Connection Between Excel VBA and Access database to update the data in access through VBA

How to Establish Connection Between Excel VBA and outlooks through VBA

How to Establish Connection Between Excel VBA and MS Word through VBA

Testing and Debugging Your Code

Effective Error Handling

Automation Development Reports & Live Projects

====================

MS ACCESS & SQL

Access is a relational database management system (RDBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. ... It can also import or link directly to data stored in other applications and databases.

Topics Covered as follows:

Access environment and tools

Database terminology and concept

Designing database in Access

Understanding RDBMS

Working with the Design side of Tables

Create Query

Join Tables That Have No Common Fields

Work with Subdatasheets

Create Sub queries

Working with the runtime of Tables

Data migration and importing

Working with the Design side of Queries

Working with the runtime of Queries

Working with the Design side of Forms

Adding Controls to Forms

Creating Sub forms

Organizing Information with Tab Pages

Displaying a Summary of Data in a Form

Applying Conditional Formatting

 Working with the runtime of Forms, Managing Switchboard

Working with the Design side of Reports

Organize Report Information

Format Reports Include Charts in a Report

Add a Calculated Field to a Report

Add a Sub report to an Existing Report

Working with the runtime of Reports

Working with the Design side of Macros

Creating a Macro Restricting Records Using a Condition

Automating Data Entry Using a Macro

Working with the runtime of Macros

How to create a functional specification

Build a real-world business application

Putting altogether and deployment

============

PRACTICAL IMPLEMENTATION

[file-formats-programming]

Set Font Fallback Settings for Rendering & Insert Empty Field in Word Document using Java

What's New in this Release?

Aspose development team is happy to announce the monthly release of Aspose.Words for Java 18.10. The release of this month contains number of new features, enhancements and bug fixes of the issues reported by Aspose users in previous versions. A new feature has been added in Aspose.Words 18.10 to set font fallback settings. Font fallback is used when font is resolved but it doesn’t contain a specific character. It has added new property FontSettings.FallbackSettings to set the settings related to font fallback mechanism. A new class FontFallbackSettings is also added for fallback mechanism settings. It has added new property NodeRendererBase.BoundsInPoints in this release to get the actual bounding box of the shape as rendered on the page. It has added two new properties named Style and StyleName in StructuredDocumentTag class to set or get the style applied to content control. A new feature has been added in this version of Aspose.Words to copy all styles of document into another document. MS Word allows to insert empty field into document. It has added this feature in Aspose.Words 18.10 to insert empty field into document. A new property Table.AllowCellSpacing has been added in this version of Aspose.Words to set or get the option “Allow spacing between cells” of table. It has added new feature in Aspose.Words 18.10 to insert horizontal rule into document. A new method InsertHorizontalRule() has been added to DocumentBuilder class.  There are 84 improvements and fixes in this regular monthly release, such as Aspose.Words for Java is FIPS compliant now. The single sentence ‘SecuritySettings.startFipsMode()’ switches current Aspose.Words thread to the FIPS mode, Support Conholdate.Total for Java licensing system, Compatibility within GroupDocs Total package is improved, Just another Veracode Security Scan Report is fixed, Java 10/11 compatibility updates caused few bugs on some old Java Runtime Environments. We managed to fix these bugs quickly, Massive JavaDoc fixes, Aspose.BarCode compatibility changed to a new architecture that started from v.18.8. BarCode inside AW documents is more consistent now, Implemented new API to set up font fallback mechanism through XML configuration, Provide option to Use a style to format text typed into the SDT control and many more. The list of most notable new and improved features added in this release are given below

The language detection of every Run object

Rupee symbol does not render in PDF when old version of Arial font is used

Provide option to Use a style to format text typed into the SDT control

Add ability to remove paragraphs becoming empty after template extressions are evaluated to empty values

Add feature to remove list item when data source is empty or null

Remove empty paragraph when IF condition returns false in LINQ Reporting

Add feature to remove last list number when HTML is inserted by LINQ Reporting

WordArt rendering support (advanced features)

FIPS compliant version of Bouncy Castle

Fonts are substituted improperly

Support 'Conholdate.Total for Java' licensing system

GroupDocs Total License: resource name conflict after obfuscation    

Links to internal members in public API Documentation

Strange white thick line added to the table

Some metadata properties are missing after document saving

Try to render PNG images with corrupted structure // DOCX to PDF - image is lost

Check Veracode Security Scan report

Shapes (Math equation) do not render correctly

Java documentation for GraphicsQualityOptions settings

"Bad cref:" warning in public API due simplified see tag

Missing javadoc for method with array in signature

Links to .Net system members in Java's javadoc

Remove '#Error Cref' warning errors from public API.

Bad size of border around Barcode image.

Javadoc is missing package-list file.

Hebrew characters are not generating properly from rtf specified format

An invalid characters encoding when saving RTF document to a string

Links to internal members in public API Documentation.

Generic Type is absent in public API

PDF output is corrupted after some page

Missing Text when converting RTF

Space characters in an OfficeMath equation disappear after conversion to MathML

Document is not rendered properly

Word to PDF - Bookmark creation issue with style separator

DOCX to PDF conversion issue with English and Chinese text

Document.PageCount returns wrong value

Add feature to insert Horizontal Rule into document

Aspose.Words produces invalid EPUB documents if HtmlSaveOptions.Encoding is not UTF-8 or UTF-16

A picture at bottom right corner of first page moves inches towards left in PDF

Incorrect rendering of X-axis labels after converting to PDF

Converting Word to Pdf the text layout in Pdf is not correct

Extracted Ole Object has wrong Signature and Binary values differ every time Aspose.Words code executes

TextBox Picture are not preserved in rendered PDF

Document.UpdateFields does not update the TOC field under Swedish culture

Large tables flow off the side of the page when rendering

Incorrect Table/Cell widths are exported to PDF

Header/Footer cut off at the right side of page after conversion from Doc to Fixed file format

Tables appear behind the Shapes in rendered PDF

Docx to Pdf conversion issue with text indentation

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Words for .NET documentation that may guide users briefly how to use Aspose.Words for performing different tasks like the followings.

Copy All Styles from Template

Font substitution and Font fallback in Aspose.Words

Overview: Aspose.Words

Aspose.Words is a word processing component that enables .NET, Java & Android applications to read, write and modify Word documents without using Microsoft Word. Other useful features include document creation, content and formatting manipulation, mail merge abilities, reporting features, TOC updated/rebuilt, Embedded OOXML, Footnotes rendering and support of DOCX, DOC, WordprocessingML, HTML, XHTML, TXT and PDF formats (requires Aspose.Pdf). It supports both 32-bit and 64-bit operating systems. You can even use Aspose.Words for .NET to build applications with Mono.

More about Aspose.Words

Homepage Java Word Library

Download Aspose.Words for Java

Online documentation of Aspose.Words

[file-formats-programming]

Sort Excel Table’s Data, Calculate  Formula & Apply Rich Text Formatting inside Cloud Apps

What's New in this Release?

Aspose team is pleased to announce the new release of Aspose.Cells for Cloud 17.6.0. This new release comes up with a couple of new features and enhancements. Developers can filter data in a worksheet by using an AutoFilter API and calculate all formulas in a workbook using CalculateFormula API.  By filtering information in a worksheet, users can find values quickly. Users can filter on one or more columns of data. AutoFilter API allows users to filter data by Cell Value, Cell Color or by Icon. Experiment with filters on text and numeric data by trying the many built-in test conditions, such as Equals, Does Not Equal, Contains, Greater Than, and Less Than or create a custom filter that uses multiple criteria. CalculateFormula API allows users to calculate all formulas in a workbook. Formula calculation engine is embedded in Aspose.Cells. It can not only re-calculate the formula imported from the designer file but also supports to calculate the results of formulas added at runtime. The list of new and enhanced features added in this release are given below

Filter data by using an AutoFilter API.         

New resource parameters are added in Calculate Formula API.

Support Microsoft Excel 2007 themes and colors.

An enhancement is made for Convert feature.

Import Data API now supports both Cloud file and Request file.   

Start a free trial today – all users need is to sign up with the Aspose for Cloud service. Once users have signed up, users are ready to try the powerful file processing features offered by Aspose for Cloud.

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. Users can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

More about Aspose for Cloud

Learn More about Aspose.Cells for Cloud

Download Aspose.Cells for Cloud

Aspose.Cells for Cloud Documentation

Ask technical questions/queries from Aspose for Cloud Support Team