请问Web移动端如何滑动？单元格无法触摸滑动 #6175
请问Web移动端如何滑动？单元格无法触摸滑动
#6175
Replies: 1 comment 5 replies
-
|
Hey, this is the univer repository. |
Beta Was this translation helpful? Give feedback.
5 replies
-
|
But the luckyexcel repository is already archived. |
Beta Was this translation helpful? Give feedback.
-
|
Are you talking about luckysheet? |
Beta Was this translation helpful? Give feedback.
-
|
Ahhh yeah yeah yeah, the frontend component. |
Beta Was this translation helpful? Give feedback.
-
|
Well, in a way, Univer could be seen as a modern successor to Luckysheet. However, it is not built upon Luckysheet 😉. We chose to establish a more suitable architecture and developed a brand-new SDK. BTW, Univer does provide experimental mobile support: https://github.com/dream-num/univer/tree/dev/examples/src/mobile-s |
Beta Was this translation helpful? Give feedback.
-
|
Can you give some advice on migrating from Luckysheet to Univer? <!DOCTYPE html>
<html lang=''>
<head>
<meta charset='utf-8'>
<meta
content='IE=edge'
http-equiv='X-UA-Compatible'
>
<meta
content='width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no'
name='viewport'
>
<link
href='<%= BASE_URL %>favicon.ico'
rel='icon'
>
<title><%= htmlWebpackPlugin.options.title %></title>
<link
href='static/excel/xspreadsheet.css'
rel='stylesheet'
/>
<script src='static/excel/xlsx.full.min.js'></script>
<script src='static/excel/xspreadsheet.js'></script>
</head>
<body>
<div id='app'></div><template>
<div class='edit_excel content_box'>
<div
class='search_bar_excel'
style='text-align: right'
>
<el-button
v-if='isEdit'
:loading='btnLoading'
size='mini'
type='primary'
@click="option('save')"
>{{ $t('Save') }}
</el-button>
<el-button
size='mini'
style='background: #AFAFAF; border: 1px solid #E9E8E8'
type='info'
@click="option('cancel')"
>{{ $t('Cancel') }}
</el-button>
</div>
<div
id='luckysheet'
class='luckySheet'
/>
</div>
</template>
<script>
import LuckyExcel from 'luckyexcel'
import { saveExcel } from './export'
import { exportExcel } from './exprot1'
import { downloadFile } from '@/api/base'
import { getRule, setRule } from '@/api/public'
import { uploadFile } from '@/api/user'
export default {
name: 'ExcelEditor',
props: {
msg: String,
showImport: {
type: Boolean,
default: false
},
showExport: {
type: Boolean,
default: false
},
showtoolbar: {
type: Boolean,
default: true
},
showAddSheet: {
type: Boolean,
default: false
},
showSave: {
type: Boolean,
default: false
},
isEdit: {
type: Boolean,
default: true
}
},
computed: {},
data () {
return {
token: this.$store.state.user.token,
options: {
container: 'luckysheet',
lang: 'zh',
showinfobar: false,
showtoolbar: this.showtoolbar,
showsheetbar: false,
sheetFormulaBar: false,
showsheetbarConfig: {
add: this.showAddSheet,
menu: true,
sheet: true
},
dataVerification: {}
},
btnLoading: false
}
},
created () {
},
mounted () {
this.$nextTick(() => {
window.luckysheet.create(this.options)
})
},
beforeDestroyed () {
window.luckysheet.create(this.options)
},
methods: {
async initExcel (filePath, fileName, annexId = undefined) {
const file = await this.downloadFile(filePath, fileName)
let rule
if (annexId) {
rule = await this.getRule(annexId)
}
await this.loadFile(file, rule)
},
async downloadFile (filePath, fileName) {
return await downloadFile({ path: filePath }).then((res) => {
const reader = new FileReader()
reader.onload = function (result) {
console.log(result)
}
reader.readAsArrayBuffer(res)
return new window.File([res], fileName, { type: 'xlsx' })
})
},
async getRule (annexId) {
return await getRule(annexId).then((res) => {
if (res.data?.jsonData) {
return JSON.parse(res.data.jsonData)
} else {
return undefined
}
})
},
loadExcel (evt) {
const files = evt.target.files
if (files == null || files.length === 0) {
alert('No files wait for import')
return
}
const name = files[0].name
const suffixArr = name.split('.')
const suffix = suffixArr[suffixArr.length - 1]
if (suffix !== 'xlsx') {
alert('Currently only supports the import of xlsx files')
return
}
this.loadFile(files[0])
},
async loadFile (file, rule) {
const _this = this
await LuckyExcel.transformExcelToLucky(
file,
await function (exportJson) {
if (exportJson.sheets == null || exportJson.sheets.length === 0) {
alert(
'Failed to read the content of the excel file, currently does not support xls files!'
)
return
}
if (rule) {
// exportJson.sheets[0].dataVerification = rule todo
exportJson.sheets = rule
}
window.luckysheet.create(
Object.assign(_this.options, {
data: exportJson.sheets,
title: exportJson.info.name,
userInfo: exportJson.info.name.creator
}),
res => {
console.log(res)
}
)
}, err => {
console.log(err)
}
)
},
downloadExcel () {
exportExcel(window.luckysheet.getLuckysheetfile(), '下载').then((res) => {
console.log(res)
})
},
async saveExcel (name) {
this.btnLoading = true
return new Promise((resolve) => {
const luckysheet = window.luckysheet.getAllSheets()
saveExcel(luckysheet).then((res) => {
const formData = new FormData()
formData.append('file', res, name)
uploadFile(formData).then((response) => {
console.log(response)
// const json = luckysheet[0]?.dataVerification todo
setRule(response.data.id, luckysheet)
resolve(response)
})
})
}).finally(() => {
this.btnLoading = false
})
},
getAllSheets () {
return window.luckysheet.getAllSheets()
},
closeExcel () {
window.luckysheet.destroy()
},
option (type) {
this.$emit('excelOption', type)
}
}
}
</script>
<style
lang='scss'
scoped
>
.edit_excel {
width: 100%;
height: 480px;
position: relative;
z-index: 99999;
}
</style> |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
"luckyexcel": "^1.0.1"
移动端打开后手指在单元格区域滑动，滑动的是整个页面，单元格没有反应
Beta Was this translation helpful? Give feedback.
All reactions