excel表格小技巧
excel表格小技巧
收录了0篇文章 1人关注
关注

在Excel表格中按方向键为什么不移动？原来是这个键的问题

哈士2奇 425 阅读 2020-05-21 16:53:03

表格iferror什么意思？可以这样理解

科技小怪兽 616 阅读 2019-09-20 13:52:05

表格页面设置找不到？具体步骤需了解

科技小怪兽 668 阅读 2019-09-19 17:59:39

表格怎么返回上一步？快捷键操作需了解

科技小怪兽 944 阅读 2019-09-19 17:59:13

表格怎么计算百分比？操作方法是重点

科技小怪兽 905 阅读 2019-09-19 17:58:02

表格文字居中设置教程：操作方法不止一种

科技小怪兽 725 阅读 2019-09-19 17:57:08

表格对象是什么？可以这样理解

科技小怪兽 928 阅读 2019-09-19 15:00:54

表格排列顺序教程：只需这几招

科技小怪兽 872 阅读 2019-09-19 14:59:48

Excel表格如何打出横线？不止一种方式

科技小怪兽 719 阅读 2019-09-19 14:59:16

excel怎么画线，详细方法

伊人 1813 阅读 2019-06-25 17:52:10

excel字体颜色被锁定了，怎么解除

伊人 700 阅读 2019-06-25 17:51:49

表格中饼图怎么显示百分比，详细操作

伊人 2573 阅读 2019-06-25 17:50:34

excel工作表中怎么输入符号

哈士2奇 1414 阅读 2019-06-24 16:39:09

excel怎么取消筛选状态，详细方法

伊人 1278 阅读 2019-06-04 18:09:59

excel拆分数据教程：多种方式可选择

科技小怪兽 4246 阅读 2019-03-10 16:22:06

excel表格怎么求和，公式怎么用

伊人 4037 阅读 2019-03-04 17:36:35

excel表格求和公式是什么，怎么使用

伊人 1769 阅读 2019-03-04 17:36:06

excel怎么固定最上面一行

伊人 3933 阅读 2019-03-04 17:35:36

excel差值函数是什么，怎么使用

伊人 4908 阅读 2019-03-04 17:35:08

excel怎么插入行或列

伊人 2830 阅读 2019-03-04 17:34:39

Microsoft Excel是Microsoft为使用Windows和Apple Macintosh操作系统的电脑编写的一款电子表格软件。

进入话题广场 来这里，发现更多精彩!
关于话题

Microsoft Excel是Microsoft为使用Windows和Apple Macintosh操作系统的电脑编写的一款电子表格软件。

话题达人

科技小怪兽

威望 0 积分 -265170
+关注

六眼飞鱼

威望 0 积分 -338850
+关注

科技1号

威望 0 积分 2000
+关注

哈士2奇

威望 0 积分 -148735
+关注

科技猫

威望 0 积分 2000
+关注
Debug messages:

Template: chaofen


Session:

Session type: file

[nus__Anwsion] Array ( [permission] => Array ( [visit_site] => 1 [visit_explore] => 1 [search_avail] => 1 [visit_question] => 1 [visit_topic] => 1 [visit_feature] => 1 [visit_people] => 1 [visit_chapter] => 1 [answer_show] => 1 ) [client_info] => [human_valid] => )


Plugins:


Loaded Class:

core_config: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/config.php

core_db: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/db.php

Zend_Db: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db.php

Zend_Db_Adapter_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Adapter/Abstract.php

Zend_Db_Adapter_Mysqli: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Adapter/Mysqli.php

Zend_Db_Profiler: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Profiler.php

Zend_Db_Statement_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Interface.php

Zend_Db_Statement: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement.php

Zend_Db_Statement_Mysqli: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Mysqli.php

Zend_Registry: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Registry.php

Zend_Cache: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache.php

Zend_Cache_Backend: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend.php

Zend_Cache_Backend_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend/Interface.php

Zend_Cache_Backend_ExtendedInterface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Cache/Backend/ExtendedInterface.php

Zend_Db_Table_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Table/Abstract.php

core_plugins: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/plugins.php

Zend_Session_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Abstract.php

Zend_Session: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session.php

Zend_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Exception.php

Zend_Session_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Exception.php

Zend_Session_Namespace: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Session/Namespace.php

core_cache: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/cache.php

core_uri: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/uri.php

TPL: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_template.inc.php

Savant3: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Savant3.php

core_user: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/user.php

account_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/account.php

HTTP: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_http.inc.php

Zend_Validate_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate/Interface.php

Zend_Validate: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate.php

Zend_Loader: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Loader.php

Zend_Validate_Abstract: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Validate/Abstract.php

Zend_Filter_Interface: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Filter/Interface.php

Zend_Filter_Digits: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Filter/Digits.php

topic_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/topic.php

Zend_Db_Select: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Select.php

Zend_Db_Expr: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Expr.php

FORMAT: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_format.inc.php

Services_BBCode: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Services/BBCode.php

ACTION_LOG: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/class/cls_action_log_class.inc.php

Services_Diff: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Services/Diff.php

core_lang: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/core/lang.php

posts_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/posts.php

answer_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/answer.php

question_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/question.php

system_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/system.php

publish_class: /www/wwwroot/xiuchuang/www.xiuchuang.com/models/publish.php

Zend_Db_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Exception.php

Zend_Db_Statement_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Exception.php

Zend_Db_Statement_Mysqli_Exception: /www/wwwroot/xiuchuang/www.xiuchuang.com/system/Zend/Db/Statement/Mysqli/Exception.php


Database

[ Log time: 1791870923.8912 ] [ Expend time: 0.0068149566650391 ] Connect Master DB

[ Log time: 1791870923.9173 ] [ Expend time: 0.0015799999237061 ] SELECT `aws_topic`.* FROM `aws_topic` WHERE (topic_id = 1505) LIMIT 1

[ Log time: 1791870923.9204 ] [ Expend time: 0.00166916847229 ] SELECT COUNT(*) AS `n` FROM `aws_topic_relation` WHERE (type='article' and topic_id=1505)

[ Log time: 1791870923.9218 ] [ Expend time: 0.00099802017211914 ] SELECT item_id FROM aws_topic_relation WHERE topic_id IN(1505) AND `type` = '10'

[ Log time: 1791870923.9228 ] [ Expend time: 0.00089812278747559 ] SELECT topic_id FROM aws_topic WHERE parent_id = 1505

[ Log time: 1791870923.9321 ] [ Expend time: 0.0076889991760254 ] SELECT `aws_user_action_history`.* FROM `aws_user_action_history` WHERE (associate_id = 1505 AND associate_type IN (4) AND associate_action IN (401,402,403,404,405,410,411) AND associate_attached = '-1') ORDER BY `add_time` DESC LIMIT 10

[ Log time: 1791870923.9341 ] [ Expend time: 0.0017130374908447 ] SELECT `aws_user_action_history_data`.* FROM `aws_user_action_history_data` WHERE (history_id IN(28184,28182,28107))

[ Log time: 1791870923.9366 ] [ Expend time: 0.001680850982666 ] SELECT `aws_users`.* FROM `aws_users` WHERE (uid = 280) LIMIT 1

[ Log time: 1791870923.9459 ] [ Expend time: 0.0019369125366211 ] SELECT `aws_topic_merge`.* FROM `aws_topic_merge` WHERE (target_id = 1505)

[ Log time: 1791870923.9516 ] [ Expend time: 0.0020809173583984 ] SELECT `item_id`, `type` FROM aws_topic_relation WHERE `topic_id` IN(1505)

[ Log time: 1791870923.9579 ] [ Expend time: 0.0044729709625244 ] SELECT `aws_posts_index`.* FROM `aws_posts_index` WHERE (((post_id IN (5243,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5255,5256,5257,5493,9969,11624,11771,11772,11773,20397,20398,20400,20450,20452,20454,20455,20500,36282) AND post_type = 'question')) AND examine=1 AND add_time<1791741323) ORDER BY `id` DESC LIMIT 20

[ Log time: 1791870923.9606 ] [ Expend time: 0.0021049976348877 ] SELECT COUNT(*) AS `n` FROM `aws_posts_index` WHERE (((post_id IN (5243,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5255,5256,5257,5493,9969,11624,11771,11772,11773,20397,20398,20400,20450,20452,20454,20455,20500,36282) AND post_type = 'question')) AND examine=1 AND add_time<1791741323)

[ Log time: 1791870923.9871 ] [ Expend time: 0.0014739036560059 ] SELECT last_answer FROM aws_question WHERE question_id IN (36282,20500,20455,20454,20452,20450,20400,20398,20397,11773,11772,11771,11624,9969,5493,5257,5256,5255,5254,5253)

[ Log time: 1791870923.9897 ] [ Expend time: 0.0020649433135986 ] SELECT `aws_topic_relation`.* FROM `aws_topic_relation` WHERE (item_id IN(36282,20500,20455,20454,20452,20450,20400,20398,20397,11773,11772,11771,11624,9969,5493,5257,5256,5255,5254,5253) AND `type` = 'question')

[ Log time: 1791870923.992 ] [ Expend time: 0.001535177230835 ] SELECT `aws_topic`.* FROM `aws_topic` WHERE (topic_id IN(1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505))

[ Log time: 1791870924.0008 ] [ Expend time: 0.0034248828887939 ] SELECT `aws_question`.* FROM `aws_question` WHERE (question_id IN(36282,20500,20455,20454,20452,20450,20400,20398,20397,11773,11772,11771,11624,9969,5493,5257,5256,5255,5254,5253))

[ Log time: 1791870924.0035 ] [ Expend time: 0.002133846282959 ] SELECT `aws_users`.* FROM `aws_users` WHERE (uid IN(1208,5,280))

[ Log time: 1791870924.0077 ] [ Expend time: 0.0012638568878174 ] SELECT `aws_category`.* FROM `aws_category`

[ Log time: 1791870924.0148 ] [ Expend time: 0.0020310878753662 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 36282) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0182 ] [ Expend time: 0.0019791126251221 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20500) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0207 ] [ Expend time: 0.0016379356384277 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20455) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0231 ] [ Expend time: 0.001492977142334 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20454) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0256 ] [ Expend time: 0.0016930103302002 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20452) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0276 ] [ Expend time: 0.0012547969818115 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20450) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0299 ] [ Expend time: 0.0014660358428955 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20400) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0318 ] [ Expend time: 0.0011608600616455 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20398) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0338 ] [ Expend time: 0.0011439323425293 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 20397) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0359 ] [ Expend time: 0.0013279914855957 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11773) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0376 ] [ Expend time: 0.00095510482788086 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11772) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0393 ] [ Expend time: 0.00093698501586914 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11771) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.041 ] [ Expend time: 0.0009620189666748 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 11624) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0428 ] [ Expend time: 0.0011241436004639 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 9969) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0446 ] [ Expend time: 0.0010600090026855 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5493) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0464 ] [ Expend time: 0.0010430812835693 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5257) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0478 ] [ Expend time: 0.00077009201049805 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5256) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0492 ] [ Expend time: 0.00076413154602051 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5255) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0508 ] [ Expend time: 0.00088882446289062 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5254) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.0521 ] [ Expend time: 0.00073099136352539 ] SELECT `aws_attach`.* FROM `aws_attach` WHERE (item_type = 'question' AND item_id = 5253) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1791870924.06 ] [ Expend time: 0.00062894821166992 ] SELECT `item_id`, `type` FROM aws_topic_relation WHERE `topic_id` IN(1505)

[ Log time: 1791870924.0614 ] [ Expend time: 0.00080394744873047 ] SELECT `aws_posts_index`.* FROM `aws_posts_index` WHERE (((post_id IN (5243,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5255,5256,5257,5493,9969,11624,11771,11772,11773,20397,20398,20400,20450,20452,20454,20455,20500,36282) AND post_type = 'question')) AND is_recommend = 1 AND examine=1 AND add_time<1791741324) ORDER BY `add_time` DESC, `id` DESC LIMIT 20

[ Log time: 1791870924.0623 ] [ Expend time: 0.00064516067504883 ] SELECT COUNT(*) AS `n` FROM `aws_posts_index` WHERE (((post_id IN (5243,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5255,5256,5257,5493,9969,11624,11771,11772,11773,20397,20398,20400,20450,20452,20454,20455,20500,36282) AND post_type = 'question')) AND is_recommend = 1 AND examine=1 AND add_time<1791741324)

[ Log time: 1791870924.064 ] [ Expend time: 0.0007469654083252 ] select a.* from aws_article as a join aws_topic_relation as r on a.id=r.item_id where a.uid != 894 and r.type='article' and and r.add_time<1791741324 r.topic_id in (1505) order by a.views desc limit 0,20

[ Log time: 1791870924.0695 ] [ Expend time: 0.0050368309020996 ] select * from aws_users where 1 order by article_count desc limit 5


Cache

[ Log time: 1791870923.9015 ] Backend: File

[ Log time: 1791870923.9017 ] [ Expend time: 0.000127 ] Get Cache: crond, result type: boolean

[ Log time: 1791870923.908 ] [ Expend time: 0.000364 ] Get Cache: user_group_99, result type: array

[ Log time: 1791870923.9527 ] [ Expend time: 0.000267 ] Get Cache: posts_list_by_topic_ids_c3501383086a50d7371b6f01b81f3cba, result type: boolean

[ Log time: 1791870923.9581 ] [ Expend time: 0.000170 ] Get Cache: db_rows_cache_3dbd979d5bb711ff2eb3e334a04387e6, result type: boolean

[ Log time: 1791870923.9763 ] [ Expend time: 0.015570 ] Save Cache: db_rows_cache_3dbd979d5bb711ff2eb3e334a04387e6, result type: integer

[ Log time: 1791870923.9835 ] [ Expend time: 0.007137 ] Save Cache: posts_list_by_topic_ids_c3501383086a50d7371b6f01b81f3cba, result type: array

[ Log time: 1791870923.9836 ] [ Expend time: 0.000123 ] Get Cache: posts_list_by_topic_ids_found_rows_6f889deebc88c7cd1ff8c04e99881daf, result type: boolean

[ Log time: 1791870923.9842 ] [ Expend time: 0.000540 ] Save Cache: posts_list_by_topic_ids_found_rows_6f889deebc88c7cd1ff8c04e99881daf, result type: integer

[ Log time: 1791870924.0604 ] [ Expend time: 0.000089 ] Get Cache: posts_list_by_topic_ids_b31dafa729961503c348ef7b38f308dd, result type: boolean

[ Log time: 1791870924.0615 ] [ Expend time: 0.000080 ] Get Cache: db_rows_cache_467c550290bbd1290555abfff64111ae, result type: boolean

[ Log time: 1791870924.0624 ] [ Expend time: 0.000093 ] Get Cache: posts_list_by_topic_ids_found_rows_ced40bdf66b05d6d7f2fcca0f0739a39, result type: boolean


Escape time: 0.55889391899109, 43 queries, PHP Memory usage: 5062.2578125 KB, Server time: 2026-10-13 13:55:23