excel表格怎样依照内容色彩排序?-英雄云拓展知识分享
327
2024-01-30
Document Themes Part I
文档主题(Document Themes)—第1部份
In the last post, I presented an overview of the work we are doing in the area of “great looking documents”. Over the next few posts, I want to walk through a number of the improvements in a bit more detail. Today, I am going to introduce the idea of Document Themes, because a lot of the other features that I am going to discuss are tied into document themes in one way or another.
在上篇文章中,我概述了我们在精美文档方面所做的改进。在接下来的这几篇文章中,我想从更多的细节方面来进一步介绍这些改进。今天,我要介绍Document Themes(文档主题)这个概念,以后将要介绍的许多其他的特点或多或少与Document Themes(文档主题)有关。
To put it in the simplest terms, a Document Theme (or “theme” for the remainder of this post) is a new way to specify the colours, fonts, and graphic effects that can be used to format a document. We have integrated themes into the applications (Word, Excel, PowerPoint) wherever it is possible to apply formatting, and we have added a set of features to create new themes, change themes, specify themes for templates, etc.
Document Themes(文档主题)(下面简称主题)是一种指定色彩、字体、图形效果的新方法,能用来格式文档。我们已将文档主题整合到了利用程序中(Word,Excel,PowerPoint),使它在任何地方都能利用。同时,还可以创建新的主题、改变主题、为模板指定主题等等。
There are a couple of goals behind this work. First and foremost, we wanted to give users a better set of tools for building good-looking documents without having to worry about the formatting for each element. For example, in current versions of Office, if a user inserts a table, a chart, and some text into a document, they need to worry about tweaking all the low-level formatting to try and make sure that everything matches and “looks good” (the latter being more subjective). The user interface does not make this easy, and the default out-of-the-box formatting does not help in most cases either. Second, we wanted to make it much easier for users to build Word documents that match PowerPoint documents that match Excel documents. Because the theme architecture is shared between all apps, users will find this much simpler. Third, we wanted to provide “professional design help” out of the box … meaning that we have professional designers creating the themes and the cell, Table, PivotTable, and chart styles that will be shipped in Excel 2007, so that users can take advantage of their work in creating documents. Finally, we wanted to make it easy to change the look of a document without needing to adjust all the element-level formatting.
这项工作的目标是:第一,提供一组更好的创建精美文档的工具,而不需要(逐一地对文档的)每一个部份进行格式化。举例来看,在至今为止版本的Office中,如果用户插入一张表格、一张图表、和一些文本到文档中,他们需要对这些部份的格式进行逐渐调剂,并肯定每部份是不是调和和“外观精美”(后者是更主观的)。用户界面不会使这样的操作变得容易,并且在大多数例子中这类预设的所见即所得格式也不会有助于更便利的操作。第2,使用户建立的Word文档更容易与PowerPoint文档和Excel文档相互兼容,由于主题架构就是让所有的利用程序间能更方便地同享。第3,提供所见即所得的“专业设计帮助”……这意味着在Excel 2007中将配置由专业的设计者所创建的主题样式和单元格样式、表格样式、数据透视表样式和图形样式,在创建文档时能加以利用。第4,使改变文档的外观变得容易,而不需要调剂所有(组成文档的)部份的格式。
Let’s take a look at how this is exposed in the Excel user interface in a few places (same goes for Word and PowerPoint for the most part), and then talk through how to create and modify themes, how they related to templates, etc. (Note that a lot of this is primarily exposed through features like styles that I have only touched upon, so things should continue to get clearer after the next several posts.)
让我们先看看在Excel中所显示的(关于文档主题的)用户界面(这些界面大部份在Word和PowerPoint中是相同的),接着介绍如何创建和修改主题,如何使主题与模板相干等等。(注:一些主要的界面像样式特点在这里仅简略地提到,在后面的几篇文章中将有更详细的讲述)
Theme Fonts
主题字体
Each theme specifies two fonts – one for “headings”, and one for “body”. This distinction is more prevalent in Word and PowerPoint, but we do have some cell styles (more on that in a later post) that use the heading font. Excel’s default text style uses the “body” font (the default out-of-the-box case being Calibri), so when users enter data, they are creating themed text. In addition, the Excel’s font picker has been updated to show the user the current theme fonts.
每个主题指定了两类字体,分别为标题和正文设置。这类辨别更普遍的存在于Word和PowerPoint中,但我们使用标题字体设置一些单元格样式(这将在后面的文章中详述)。Excel的默许文本样式使用的是“正文”字体(默许的是Calibri字体),当用户输入数据时,实际上他们就正在创建主题文本。另外,Excel的字体选取器相应地显示用户当前使用的主题字体。
Theme Colours
主题色彩
Each theme specifies a number of colours (12 to be exact). Four of the colours are for text and backgrounds, six are for “accents”, and two are for hyperlinks (followed and not followed). Those 12 colours are designed to look good together. The colour model is designed to handle light text on dark backgrounds, dark text on light backgrounds, and everything in between. In Excel, this becomes important in charts for example. The colours are exposed in the new colour picker. The first four are the text/background colour, the next 6 are the accent colours, and the hyperlink colours are not exposed.
每个主题指明了一些色彩(确切地说是12种色彩),4种是文本质和背风景,6种为突出色(“accents”),2种为超级链接色(跟踪的和没有跟踪的)。这12种色彩被设计组合在一起构成美观的效果。色彩模式被设计来处理在深色背景下的浅色文本,浅色背景下的深色文本,和介于深色和浅色之间的背景和文本。在Excel的图表中,这是重要的。色彩显示在新的色彩选取器中,前4个是文本质/背风景,接下来的6个是突出色,超级链接色未显示。
Note a couple of other things. First, the 10 colours featured are designed to work well together – this is an example of a place where our professional designers have helped out. Second, for each of the 10 theme colours exposed, the first row shows the “most saturated” version, and then the next 5 rows show the same hue with different saturation and lightness. The goal here is to provide users with variants of a colour for use in different scenarios … for example, you would likely want a subtle blue for a cell background, and a more intense blue for a font colour. Third, at the bottom are non-theme standard colours that are always available. Finally, you can always choose “No Fill” or choose any colour you want.
注意其它的几点:第一,这10种特定的色彩被设计在一起很好的协同工作,这是我们的设计专家已帮助完成的其中一个例子。第2,在所显示的10个主题色彩中,第一行是“最饱和”色彩模式,接下来的5行显示具有不同饱和度和明亮度的相同色调,目标是提供在不同情况下不同的色彩……举例来看,单元格背景设置为浅蓝色,而字体为深蓝色。第3,(色彩拾取器界面)底部是可用的非主题标准色。最后,你总是能选择”无填充色(No Fill)”或选择你想要的任何色彩。
In addition to the colour picker, theme colours are used cell styles, Table styles, and PiovtTable styles. More on that in later posts.
除色彩拾取器外,在单元格样式、表格样式和数据透视表样式中也能使用主题色彩,这将在后面的文章中详细介绍。
Theme Effects
主题效果
Charts and shapes have been significantly upgraded – they look great, and they support a much wider set formatting options (more on that in posts coming soon). Each theme specifies the “effects” that will be used by charts and shapes – for example, whether lines are thick or thin, whether fills are simple or opulent, whether objects will have bevels or shadows, etc. This allows users to determine how subtle or intense they want their graphic objects to appear in their work.
极大的升级了图表和形状样式——它们外观精美,支持更多格式设置选项(这方面的内容将在后面的文章中详细介绍)。图表和形状能使用每一个指定“效果”的主题——举例来看,直线的粗或细,简洁的或华丽的填充,对象有没有斜边或阴影,等等。这使得用户可以决定工作表中图形对象色彩的深浅程度。
Here is an example of a formatting gallery for a shape (a rectangle) – you can see how the theme colours and theme effects are combined to provide the user with a gallery of choices that are the result of a graphics designer making a hundred separate decisions.
下图是一个形状(矩形)的格式化gallery(图形目录)示例——能看到合并在一起的主体色彩和主题效果的gallery(图形目录)提供给用户选择,这里有图形设计者创作出的一百个不同的效果。
Themes In Action
使用主题
To finish out this post, here is a (somewhat cheesy) document I whipped up. It took 5 clicks to make it a fairly-good-looking document that hangs together well, in a large part because the formatting for each part of the document (cells, Table, chart, shape) is derived from a single theme that professionally designed … the key point being that the theme, as exposed in the formatting user interface, helps me make good choices when formatting.
这篇文章的结尾是我匆匆做好的一个文档(见下图)。这篇相当精美的文档总共只使用了5次单击,文档的各个部份很好地组合在一起,每一个部份(单元格,表格,图形,形状)的格式来源于专业设计的单个的主题……利用主题的关键在于,在(对文档进行)格式化时,利用显示在用户界面中的格式有助于我们做出好的选择。
And in 3 more clicks, I can change my document to have a different sort of look, but one that still hangs together well. The key point here is that themes have been designed to be flexible, so that you can get many different looks from the same set of colours, fonts, and effects. More on this next time.
(在界面中)多于3次的点击,能改变文档得到不同的外观,但(文档中的各部份)依然很好的组合在一起。这其中的关键在于所设计的主题是灵活的,因而,你能从相同的色彩、字体和效果设置中取得不同的外观。下次将详细介绍这方面的内容。
That’s it for themes today. Next time, I will finish up themes, covering how to create and modify them, how they related to Excel templates, and what to do when you think your theme is starting to look stale.
上面就是今天关于文档主题的内容介绍。下次,我将介绍如何创建和修改文档主题,它们如何与Excel模板相联系,和如何处理你认为没有新意的文档主题,并以此来结束关于文档主题的介绍。
Published Thursday, March 23, 2006 8:15 PM by David Gainer
非常感谢Kevin的帮助和指点!
在现代企业管理中,数据的高效管理和处理至关重要。随着信息技术的不断发展,英雄云的云表单已经成为了提高数据录入、管理和分析效率的不可或缺的工具。让我们来深入探讨英雄云-云表单的几大优势。
英雄云的云表单中包括了各种基础字段,如单行文本、多行文本、数字输入框、单选框、复选框、下拉框、下拉复选框、日期时间、分割线等。这些字段的多样性使用户可以根据具体的业务需求,轻松进行文本、数据和时间信息的录入或修改。例如,您可以使用单行文本字段录入员工姓名、产品型号等,或者使用下拉框进行多选,根据不同情况选择更加方便的字段类型。
英雄云的云表单还提供了高级字段,如地址、图片、附件、手写签名、手机、子表、关联数据、关联查询以及流水号。这些高级字段在基础字段的基础上升级,可帮助用户完成一些琐碎的工作。例如,使用地址字段可以避免逐字打字,而流水号字段可以自动生成规律性的编号,非常适用于合同编号生成等场景。
英雄云的部门成员字段允许企业对各个部门的成员进行精确管理。用户可以通过部门成员字段获取通讯录中的部门成员信息,应用于记录报销人、报销部门等场景。这些成员字段还细分为成员单选和成员多选,可根据具体需求在通讯录中选择一个或多个成员。
英雄云的聚合表功能用于对已存在的表单数据进行聚合计算,从而得到一张聚合表,后续其他表单可调用聚合表进行数据联动、关联查询和关联数据等操作完成数据处理。这一功能可应用于多种场景,如进销存管理、财务管理和门店零售管理等,帮助企业完成数据处理,提高工作效率。
英雄云的表单权限设置允许用户根据企业的具体需求管理表单的访问和操作权限。用户可以根据系统权限或自定义权限对不同成员或团队进行权限设置,以确保数据的安全和合规性。这一功能使企业能够根据变化的业务需求和团队结构,实时调整权限设置。
英雄云的云表单支持自定义打印模板,可将表单数据转换为可打印的Word文档。用户可以根据自己的需求进行排版和编辑,将产品规格说明书等文档轻松生成。这一功能提供了一种标准化的文档输出方式,简化了信息整理的过程。
综合来看,选择英雄云的云表单意味着选择更智能、更灵活、更高效的数据管理工具。无论是提高工作效率,精确管理数据,还是实现数据处理,英雄云的云表单都能满足您的多样化需求,助力您的业务发展。
如果您正在寻找一款强大的云表单工具,不妨考虑英雄云,它将为您带来更多的便捷和智能,助您事半功倍。
免责声明:
本网址(www.yingxiongyun.com)发布的材料主要源于独立创作和网友匿名投稿。此处提供的所有信息仅供参考之用。我们致力于提供准确且可信的信息,但不对材料的完整性或真实性作出任何保证。用户应自行验证相关信息的正确性,并对其决策承担全部责任。对于由于信息的错误、不准确或遗漏所造成的任何损失,本网址不承担任何法律责任。本网站所展示的所有内容,如文字、图像、标志、音频、视频、软件和程序等的版权均属于原创作者。如果任何组织或个人认为网站内容可能侵犯其知识产权,或包含不准确之处,请即刻联系我们进行相应处理。
发表评论
暂时没有评论,来抢沙发吧~